Duration
1 day
Course Description
This Advanced Microsoft Excel 2019 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
Target Audience
Students who have intermediate skills with Microsoft Excel 2019 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2019 interface.
Module 1: Managing Data
- Consolidating Information
- Configuring Data Validation
- Converting Text to Columns
- Using Flash Fill
Module 2: Outlining and Grouping Data
- Outlining Data
- Showing and Hiding Outline Details
- Grouping Data
- Creating Subtotals
- Removing Outlining and Grouping
Module 3: Data Visualization
- Understand Types of Charts
- Creating Treemap Chart
- Creating Waterfall Chart
- Creating Map Chart
- Creating Funnel Chart
Module 4: Analyzing Data (I)
- Using Goal Seek
- Using Data Tables
- Using Solver
Module 5: Analyzing Data (II)
- Analysis on Stocks Data Type
- Analysis on Geography Data Types
- Using Ideas
Module 6: PivotTable Features
- Creating a Basic PivotTable
- Creating a Basic PivotChart
- Using the PivotTable Fields Pane
- Adding Calculated Fields
- Sorting Pivoted Data
- Filtering Pivoted Data
- Using Slicers
- Creating Timelines
Programme scope, delivery arrangements and suitability are confirmed during enquiry.