CPD Certified

MS Excel 365 - Master

This master MS Excel course is for anyone who needs to take their Excel skills to the next level. We assume learners will already be familiar with using a keyboard, mouse, computer and assistive technology. By the end of this course you will be able to use

  • Financial functions such as PMT, FV, PV and Rate
  • Lookup and Reference Functions such as Match, Index, Offset, Filter and Sort
  • Pivot Tables and Charts
  • Documenting and Auditing and manipulating Data including Sorting, Compare and Merge and Flash Fill. Lastly automating repetitive tasks with Macros.
This course also covers the desktop and web versions.

Estimated Course duration is 3 - 4 hours.  Each lesson take on average 3-5 minutes to complete


Course Content

Financial Functions

PMT Function
FV and PV Functions
Rate Function

Lookup and Reference Functions

Combining MATCH with INDEX
Combining LOOKUP and MATCH
Using Lookup Functions with Named Ranges
OFFSET Function
FILTER Function
SORT Function

Pivot Tables and Pivot Charts

Working with Pivot Tables
Rearranging Pivot Tables
Slicers
Formatting Pivot Tables
Pivot Charts
Using GETPIVOTDATA with Pivot Tables

Documenting and Auditing

Formula Errors
Evaluating Formulas
Using the Watch Window
Using Comments
Data Validation
Workbook Co-Authoring
Displaying and Printing Formulas

Manipulating Data

Sorting by Values
Sorting by Formatting
Advanced Sorting Features
Converting Text to Columns
Compare and Merge Data
Flash Fill

Automating Repetitive Tasks

Explaining Macros
Macros Security levels
Recording Macros
Running Macros
Assigning Macros to the QAT

Analytical Options

Goal Seek
Solver
The Analysis Toolpak Quick Analysis Tool
Scenarios

Data Tables

One Input variable
Two Input Variable