Microsoft Excel 365 / 2019 / 2016 Level 3
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.
Duration: 1 Day
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
Prerequisites
- Microsoft Excel 365 / 2019 / 2016 Level 2 or equivalent experience
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