MS Excel

Microsoft Excel is one of the most important everyday tools for any modern business. From simple data entry and organisation to building reports, charts, pivot tables and automated processes, Excel can substantially improve productivity, accuracy and the speed of decision-making.

The course is designed around your team’s level of knowledge, daily tasks and real needs. The aim is not merely to learn functions, but to apply them immediately in practical business scenarios, such as sales reports, financial tracking, list management, data analysis and building recurring reports.

Excel basic

The basic level is for users who have no previous experience with Excel or who use it mostly by trial and error. Participants become familiar with the working environment and learn to create, manage and present simple tables with sound structure and professional formatting.

By the end of this module, users will be able to enter and organise data, apply basic mathematical formulas, create simple charts, sort and filter information, and print clean, readable reports.

Typical topics include:

• The basics of MS Excel

• Printing

• Creating simple formulas

• AutoShapes and diagrams

• Automatic table formatting

• Basic Functions

• Charts / Graphs

• Sorting data

• Filtering data

• Basic principles of clean data structure for future analysis

Excel advanced

The advanced level is for users who already know Excel’s basic functions and want to use more complex tools to process, analyse and present larger volumes of data.

Typical topics include:

• Complex functions

• Conditional formatting

• Pivot Tables and Charts

• Subtotals in tables

• Scenarios

• The Solver tool

• What-if Analysis, Goal Seek and scenario tools to support decisions

• Building professional reports and dashboards with charts, slicers and dynamic presentation of data

Excel expert

The Expert level is for very good Excel users who want to use the program as a tool for advanced analysis, automation and producing specialised reports.

Typical topics include:

• Advanced conditional formatting

• Managing pivot tables to produce specialised reports

• Special functions for data analysis

• Creating custom functions and automations with VBA

• Connecting Excel to external data sources and databases to build complex reports

• Cleaning, combining and preparing data for analysis and reporting

• Designing dynamic reports for management information

Pivot Tables

This is a short, highly practical course designed for users who want to learn how to summarise, analyse and present large volumes of data using Pivot Tables.

Typical topics include:

• Creating a Pivot table

• Filtering information

• Sorting

• Creating custom fields

• Displaying summary reports

• Creating Pivot charts

• Using slicers and timelines for interactive filtering of reports

To follow this module, participants are advised to know basic formulas, charts, and sorting and filtering of data.

Excel VBA

The Excel VBA course is for advanced users who want to take the next step in automating tasks. Participants learn how to create their own tools, custom functions and automations that cut the time spent on repetitive tasks and reduce human error.

The syllabus is set after a meeting with your company’s managers, so that users’ real needs are identified and a practical, focused programme is designed that can be applied immediately to the business’s daily processes.

Typical topics include:

• The programming environment

• Basic principles of the language

• Creating functions

• Managing sheets and workbooks

• Creating a graphical interface

• Communicating with databases

• Automating recurring reports and daily processes