MS Excel (2016, 2019, 365) - Level 3
211-16
Productivity software
Advanced Techniques to Help You Manage Your Data
This advanced level, one-day course is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn advanced analysis tools like the Scenario Manager, Goal Seek, Data Tables, and advanced functions. Basic macros will also be covered in this course.
By the end of this workshop, you will be able to:
- Use more advanced functions: VLOOKUP, IF, database functions to summarize data
- Understand concepts of What-If-Analysis: Goal Seek, Data tables, Scenarios
- Summarize data by using subtotals
- Create and use Pivot Tables and Pivot Charts
- Create a basic Dashboard
- Record basic macros
More Advanced Functions
- Using lookup tables
- Using functions to summarize data
- Logical functions
Projecting Figures
- Goal seek
- Data tables
What-If Analysis
- Scenario concepts
- Creating scenarios
- Managing scenarios
PivotTables
- Data list and Excel table concepts
- PivotTable concepts
- Creating PivotTables
- Modifying PivotTable layouts
- Working with PivotTables
- Options
- Pivot charts
- Slicers
- Basic Dashboard
Macros
- Create simple macros
There are no prerequisites for this course.
Experienced Excel users who need to manage large amounts of data using Pivot Tables to summarize and analyze the data. Users will learn more advanced functions and Excel What-If tools to make business decisions.
This workshop addresses:
- Achievement and Results Orientation
- Computer and Digital Technology
- Document Use
- Planning and Organizing
- Working with Data and Numbers
To learn more about core competencies, click here.
Open to all members of the public.
$ 475 plus tax
Choose my session