Advanced Microsoft Excel 2007™

"Microsoft Excel 2007 offers a vast array of functionality to assist in manipulating and analysing data. This course looks at importing data using queries, whether from the web or databases, prepping the data and analysing it with What If, Scenario building and Pivot tables. Course Outline: Text Functions in Excel 2007 Count Functions Advanced ‘If’ statements Auditing Worksheets Trace Cell Precedents &, Cell Dependents Locate Errors in Formulas Locate Invalid Data and Formulas Watch and Evaluate Formulas Goal Seek to reverse calculate a formula Creating Single Input Data Tables Dual Input Data Tables Setting up and manipulating scenarios for What-If? Analysis Consolidating Data by position Consolidate by Label Group And Outline Features Create a Pivot Table Reports from new Analysing Data with Pivot Tables ,Manipulate the Pivot Table Formatting Pivot Tables Creating Pivot Charts Grouping data in Pivot Tables Importing Text Files Setting Up Database Queries Connecting Excel to the Web to Import Data Recording Macros Edit a Macro Creating Buttons to Run the Macros Customize Access to Excel Commands Adding Icons to the Toolbars Creating your own Menu Editing Menus Adding Options to Menus to run Macros"