Microsoft Excel Level 3
This course completes the Excel Essential series by teaching users how to manage and manipulate data; as lists, converting list data into tables, using advanced formulas to query data, create and use Pivot Tables, and introduces Macros which automate repetitive tasks.
Duration: 1 Day
Objectives
- Understand how to use Functions to query data
- Managing and Manipulating Data in a List
- Converting data into Tables
- Creating and Managing Pivot Tables
- Using Other Advanced Analysis Techniques and Tools
Prerequisites
- Microsoft Excel Level 2 or equivalent experience
Outline
- Using Functions to query data
- Functions with IF
- Functions with IFS
- DSUM Function
- Working with Lists
- Creating a List
- Sorting a List
- Filtering a List
- Outlining data
- Using the Subtotaling Feature
- Working with Tables
- Formatting as a Table
- Table Styles
- Filtering Tables
- Using the Total Row
- Using SUBTOTAL Function
- Structured References
- Creating and Managing Pivot Tables
- Identifying the Structure of a Pivot Table
- Creating a Pivot Table from worksheet data
- Modifying, filtering, and formatting a Pivot Table
- Using Slicers to filter a Pivot Table
- Formatting Slicers for a consistent look
- Pivot Table Charts
- Introduction to Macros
- What are Macros?
- Understanding Macro Security and the Trust Center
- Recording and Using Macros
- Introduction to Visual Basic
- Using the Visual Basic Editor
- Assigning Macros