Datrix Training offers Office Excel is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Microsoft Excel 2007 also offers more room for you to work in and delivers faster performance.
Print this course outline
MS EXCEL2003 ADVANCED – 1 DAY COURSE
Module 1: Working with PivotTables in Excel 2003
Creating a PivotTable
Specifying the Data a PivotTable Analyzes
Changing a PivotTable's Calculation
Selecting What Appears in a PivotTable
Grouping Dates in a PivotTable
Updating a PivotTable
Formatting and Charting a PivotTable
Module 2: What If Analysis in Excel 2003
Defining a Scenario
Creating a Scenario Summary Report
Using a One and Two Input Data Table
Understanding Goal Seek
Using Solver
Module 3: Automating Tasks with Macros in Excel 2003
Recording a Macro
Playing a Macro and Assigning a Macro a
Shortcut Key
Adding a Macro to a Toolbar
Editing a Macro’s Visual Basic Code
Inserting Code in an Existing Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If…Then…Else Statement
Module 4: Working with Other Programs in Excel 2003
