Microsoft Excel 2007 Advanced

Course Aims
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel tools and concepts in order to increase their knowledge and productivity.
Who Should Attend?
Users with a good understanding of Microsoft Excel 2007 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Course Outline: Microsoft Excel 2007 Advanced
Advanced Topics
· Setting Excel Options · Excel and Windows · Using the Excel Viewer
Getting the Most from your Data
· Getting the Most from your Data · PivotTables · More About PivotTables · Exploring Scenarios · What If Analysis
Excel and the Internet
· Excel and Hyperlinks · Saving Workbooks as Web Pages · Getting Data from the Internet
Advanced Excel Tasks
· Creating and Using Shared Workbooks · Using Custom AutoFill Lists · Using the VLOOKUP Function · Linking, Consolodating, and Combining Workbooks
Introduction to Macros
· Recording and Playing Macros · Copying and Deleting Macros