MS Excel - Master

This Master course is aimed at learners who have a good sound knowledge of Excel and can use basic functions such as IF and OR, NOT, countif and countblank. This course covers topics to enable data to be summarised and format data depending on criteria. It also covers some analytical functions.  It also covers how to record repetitive tasks. By the end of the course you will be able to

  • use financial functions such as PMT, FV and Rate 
  • use Match and Index functions
  • use conditional formatting to high trends and exceptions with a click of the mouse
  • work with pivot tables and charts
  • create and play back macros
  • use some analytical functions such as goal seek, solver and scenarios as well as use one and two input data tables.

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

You can also access our Quick Tip Videos, that only last a few minutes, under Tips and Tricks.


Course Content

Financial Functions

Lookup Functions

Logical Functions

Conditional Formatting

Pivot Tables & Pivot Charts

Documenting and Auditing

Custom Sorts

Advanced Features

Macros

Analytical Options

Data Tables

<< Back
For volume ordering of licences please click here.
Copyright © 2025 Bite Size Limited. All rights reserved.
This work is registered with the UK Copyright Service. Registration No: 298849.
Bite Size Ltd is registered with the UK Register of Learning Providers: UK Provider Reference Number: 10026607.
Registered Office: Bite Size Limited, Cube House, 5a Whytecliffe Road South, Purley, Surrey, CR8 2AY.
Product Logos
Privacy Statement Terms & Conditions Return and Delivery Policy Contact Us
Developed by Paramount Web Technology
feedback
X