For the most part, an overweight rating indicates less about the literal meaning of giving a stock higher weight than a given benchmark. Instead, it's typically used as Wall Street jargon to indicate a positive attitude about a particular stock.
To set an option to automatically refresh PivotTable data when you open your workbook, do the following: 1  Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. 2  Click Analyze > Options. 3  In the PivotTable Options dialog box, on the Data tab, check the Refresh data when opening the file box.
Task: Create a simple formula for a calculated column. 1  If you are not already in the Power Pivot window, in Excel, on the Power Pivot ribbon, click Power Pivot Window. 2  In the Power Pivot window, click the FactSales table (tab). 3  Scroll to the right-most column, and then in the column header, click Add Column.