Excel Advanced Session 1

Excel Advanced is targeted at experienced Excel users and builds on the key concepts learned from the Introduction and Intermediate courses. Content focuses on importing and exporting data, formatting numbers, working with ranges, working with macros, data analysis tools, summarizing data, using “what-if” data analysis and workgroup collaboration. This full day class is hands-on and highly interactive.
After completing the course, participants will be able to: • Apply advanced functions, including logical, financial, statistical, and database functions • Use Data Tables to explore the effects of different input values on a formula • Find specific values or determine the cell address of a specific value with lookup functions • Implement data validation to control which values are allowed in cells • Set up, use, and format Pivot Tables to analyze complex data sets • Present results to stakeholders graphically with PivotCharts, SmartArt graphics, and conditional data bars or icons • Use text files, XML files, Microsoft Queries, and Web Queries to import and export spreadsheet data • …and much more
Prerequisite: A strong, working knowledge of Microsoft Excel required. Completion of Excel Introduction and Excel Intermediate training classes is preferred.