Excel Advanced Session 2

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 class is hands-on and highly interactive and attendance is required for both sessions.

Session 1:Thursday, September 15

Session 2: Friday, September 16

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.