Excel Advanced

Excel Advanced

Requirements:
All attendees must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered in our Introduction and Intermediate courses either by previous hands-on experience or by having attended our or a similar course(s).
More Database tools: Revie- of Auto Filter. Using The Advanced filter.
Working with Pivot Tables: What are Pivot Tables? Creating a Basic Pivot Table Outline. The Pivot Table Tool Bar. Understanding Pivot Table Fields and Data. Moving Fields to redistribute and Group Pivot Data. Change Pivot Table Criteria, 'SUM', 'TOTAL', AVERAGE'.
Advanced Excel Tools: What is Goal Seek? Using Goal Seek. What is Scenario Manager? Subtotals.
Automating Print Settings and Ranges: (2000 - 2002 Users only) what is a Report Manager? Setting up Print Ranges. Adding Print Ranges to the Report Manager. Using the Report manager.
Macros: What are Macros? What is VBA? Where are Macros stored? Record a simple Macro. Play Back a Macro. Add a Macro to the Worksheet with an Object. Add a Macro to a toolbar. Vie- your Macro Code.
Data Consolidation: Sharing Workbooks. Tracking Changes in Workbooks. What is Data Consolidation?
More Advanced Chart Features: Create Custom Default Charts. Add ne- data to existing Charts. Add Pictures to Chart Data Markers. Revie- of Chart elements.