Course Outline
Pre-Requisites
Microsoft Excel 365 / 2019 / 2016 Level 2 or equivalent experience
Lessons
This course completes the Excel series by teaching users how to perform what-if analysis on data, protect data, manage and manipulate lists, convert list data into Pivot Tables, and use Macros to automate repetitive tasks (without knowledge of programming).
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Objectives
- Performing What-If Analyses using Goal Seek, Data Tables, and Scenario Manager
- Protecting Data in the Worksheets and Workbook
- Managing and Manipulating Data in a List
- Creating and Managing Pivot Tables
- Using Sparkline charts to add graphical representation to data
- Using Other Advanced Analysis Techniques and Tools
Outline
-
Performing What-If Analysis
- Using Goal Seek
- Using Data Tables
- Using Scenario Manager
-
Protecting Data
- Using Data Validation
- Using Worksheet Protection
- Using Workbook Protection
- Password Protecting a Workbook
- Using "Read-Only"Mode
-
Working with Lists (aka Datasets, Recordsets)
- Creating a List
- Sorting a List
- Filtering a List using AutoFilter
- Filtering a List using Advanced Filter
- Outlining data
- Subtotaling data in a List
-
Creating and Managing Pivot Tables
- Identifying the Structure of a Pivot Table
- Creating a Pivot Table from worksheet data
- Creating a Pivot Table from an external data source
- Modifying, filtering, and formatting a Pivot Table
- Using Slicers to filter a Pivot Table
- Formatting Slicers for a consistent look
- Sharing Slicers between Pivot Tables
-
Sparklines
- Understanding the types of Sparklines
- Creating a sparkline
- Customizing sparklines
- Controlling which value points are shown
- Changing the style of or format sparklines
-
Working with Macros
- Understanding what a Macro really is
- Recording and Using Macros
- Assigning Macros
Cancellation Policy
Should you postpone or cancel your course you must give 5 business days notice.
Training Location
Virtual
Your Address
Your City,
Your Province
Your Country