Search Contextures Sites

Excel Tutorial Videos 07 Data Validation Basics  Clear Old Items from a Pivot Table in Excel 2007  Excel 2007 Pivot Table Layout  Selecting Sections of an Excel Pivot Table Add Running Totals to an Excel Pivot Table  Data Validation Basics Use data validation to add a drop down list to a cell. The items in the list can be typed in a row or column on a worksheet, or the items can be typed directly into the Data Validation dialog box. If you type the list items on a worksheet, and name the range, you can refer to that list from any worksheet in the same workbook. For written instructions for this Excel tutorial, see: Data Validation Intro Clear Old Items from a Pivot Table in Excel 2007 If you change the data in the pivot table source, items that were previously in the source might be no longer included. For example, some employees might leave the company, and the names of their replacements would be entered in the source table. This video tutorial shows how you can change a pivot table option to prevent the old items from appearing in the pivot table drop down lists, for Excel 2007. For written instructions for this Excel tutorial, see: Change Retain Items Setting Excel 2007 Pivot Table Layout The default setting for pivot tables in Excel 2007 is to show all the row labels in the same column. You might prefer the layout from previous versions, where each row label was in a different column. In this video tutorial, you'll see how to change the pivot table layout in Excel 2007, so each Row Label is in a separate column. Selecting Sections of an Excel Pivot Table You can use the Selection Arrow to highlight specific sections of an Excel Pivot Table. Before the Selection Arrow can work correctly, you might have to turn on the Enable Selection feature. In this video tutorial, you'll see how to enable selection and use the Selection Arrow. For written instructions for this Excel pivot table tutorial, see: Pivot Table Selection Add Running Totals to an Excel Pivot Table With running totals you can show accumulated amounts over time. For example, you could calculate company sales for the year, over all twelve months. To show running totals, you'll u se the Custom Calculation feature in Excel's pivot tables, as shown in this video tutorial. For written instructions for this Excel tutorial, see: Pivot Tables -- Running Totals

	Excel Tutorial Videos 01 Excel Tutorial Videos 02 Excel Tutorial Videos 03 Excel Tutorial Videos 04 Excel Tutorial Videos 05 Excel Tutorial Videos 06 Excel Tutorial Videos 07 Excel Tutorial Videos 08  Excel Tutorial Videos 09  Excel Tutorial Videos 10    Excel Tutorial Videos 11    Excel Tutorial Videos 12

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright ©2012 All rights reserved.	Debra Dalgleish

Last updated: December 16, 2010 7:45 PM