top of page

Microsoft Excel Training

Our personalised Excel training is designed to teach you how to master spreadsheets with confidence. You will learn how to use a variety of Excel tools, such as formulas and functions, create charts, sort and filter data, create reports, and more. You can also extend your Excel skills to an advanced level with pivot tables, data linking and consolidation, lookup functions and macros.

1 

Excel Level 1

  • Covering Exploring the Workbook

  • Entering Data in Workbooks

  • Manipulating Data

  • Formatting

  • Databases

  • Printing

2

Excel Level 2

  • Absolute Cell References

  • Formulas and Functions

  • Cell Referencing 

  • Naming Cells

  • More on Copying Data

  • Charts 

  • Extra - Printing Charts

3

Excel Level 3

  • Advanced Charts

  • 3-D Formulas and Linking

  • Testing for Data & Errors

  • Lookup Functions

  • Arrays

  • Options, Tips & Toolbars

  • Outlining a Worksheet

  • Final Workshops

  • Extra – Financial Functions 

4

Excel Level 4

  • Revision Exercise

  • Custom Number Formats

  • Styles

  • Templates

  • Outlining a Worksheet

  • Consolidating Data

  • What-If Analysis

  • Review Exercise

  • Extra– Custom Format Codes

4

Excel Advanced Levels

  • Enquire about Excel Level 5

bottom of page