Office Specialist Beg Word Expert Word Beg Excel Expert Excel PowerPoint Outlook Access Vista  

Using Analysis Tools: Work with Scenarios, Goal Seek and Pivot Tables Adding a New Scenario Creating What If Scenarios  Data -> Pivot Table and Pivot Chart Wizard  Pivot Table: AutoFormat Pivot Table: Page Sections  Pivot Table: The Data Diagram Pivot Table: The Pivot Table Tool Bar Pivot Tables: Changing the data diagram for a different view  Customizing Pivot Tables  Tools -> Goal Seeking  Tools -> Scenarios    Working with Formulas and Functions: Revise formulas Calculating the Duration of an Appointment   Displaying and Formatting Data Apply conditional formats Perform single and multilevel sorts Use grouping and outlines Use data forms Use subtotaling Apply data filters	Displaying and Formatting Data Format -> Conditional Formatting  Data Validation Format a Control: Resizing a combo box  Format a Control: Select the Input Range   Working with Named Ranges Add and delete a named range Use a named range in a formula Use Lookup Functions (Hlookup or Vlookup)   Importing and Exporting Data Analyzing Outlook Data in Excel	Expert Microsoft Excel 2007 Microsoft Office Specialist (MOS) and Microsoft Certified Application Specialist (MCAS) reference topics