Microsoft Excel 2003 Advanced

Course Aims
This course will give students the ability to create advanced spreadsheets using the full range of Microsoft Excel 2003's tools and features.
Who Should Attend?
The course is intended for existing users of Microsoft Excel 2003 or XP who want to use the more advanced features of the software in order to increase their productivity and effectiveness. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Course Outline: Microsoft Excel 2003 Advanced
Getting the Most From Your Data
Outlining and Grouping your Data:· Using Automatic Outlining · Displaying And Collapsing Levels · Grouping Data Manually · Creating Subtotals
PivotTables:· What Is A PivotTable? · Creating A PivotTable Frame · Specifying Data in a PivotTable · Rearranging PivotTable Data
More on PivotTables:· Modifying PivotTable Calculations · Formatting A PivotTable · Refreshing A PivotTable · Charting A PivotTable · Creating A PivotTable Based On Data From An External Database
Exploring Scenarios:· What Is A Scenario? · Creating A Scenario · Creating A Scenario Summary Report · Saving Multiple Scenarios
What if Analysis:· Using A One And Two Input Data Table · Goal Seek · Solver
Excel and the Internet
Excel and Hyperlinks:· Hyperlinks and the Internet · Inserting Hyperlinks · Modifying Hyperlinks · The Web Toolbar · Browsing Hyperlinks In Excel
Excel Workbooks as Web Pages:· Interactive and Non-Interactive Web Pages · Saving A Workbook As A Web Page · Saving A Worksheet As A Web Page · Saving A Chart As A Web Page · Saving A Range As A Web Page
Advanced Excel Tasks
Creating and Using Shared Workbooks:· Sharing A Workbook · Requesting Reviews · Reviewing A Workbook · Tracking Changes · Merging And Revising A Shared Workbook
Advanced File Management:· Identifying File Properties · Searching For Files · Protecting Personal Information · Creating Back Up Files · Changing Auto-Recovery Settings
Excel Security:· Digital Signatures · Macro Security · Protecting Your Workbook With A Password
Custom and Advanced Features in Excel:· Customizing Excel By Changing Options · Using Custom AutoFill Lists · What Is Text To Speech? · Using Detect And Repair
Working with Macros and Controls
Creating Macros in Excel:· What Is A Macro? · Creating A Macro · Playing A Macro · Assigning A Shortcut Key To Macro · Macros, Buttons, And Toolbars
Excel Form Controls:· What Is A Form Control? · The Form Toolbar · Adding A Control To A Worksheet · Assigning A Macro To A Control · Form Controls
Visual Basic and Macros:· Adding Code To Your Macro · Adding Comments To VBA Code · Declaring Variables · Prompting For User Input · Iteration Over A Range · If Then Else Statements