Home · Training · Microsoft Excel Training Courses

Excel is an important tool for analysing and visualising data to uncover key insights that help inform business decisions. To get the most out of its capabilities, you need to understand how to manage and manipulate the data quickly and easily.

Our professional Excel courses will give you the skills and confidence you need to make full use of this essential spreadsheet application.

Our expert trainers will show you how to use Excel to:

  • Analyse and visualise complicated data
  • Manage and manipulate numbers
  • Build tables and forms
  • Create colourful charts and graphs
  • Extract insights for business intelligence

Our courses will take you from the basics all the way to complex calculations and programming. So whether you’re new to Excel, a competent user or looking for extra help on a specific topic, we have a course to fit – just choose from the links below.

Client Service Excellence

In an increasingly competitive and service focused market, clients expect and demand increased levels of service. This course provides extremely useful and practical approaches to handle this fact including strategies and techniques for identifying client needs.

Consulting Skills

Consulting and collaboration opens the opportunity for deeper levels of understanding and leads to more positive relationships with clients and stakeholders. This 1-day program focuses on developing a more consultative approach to important workplace interactions. It explores the traits of a trusted consultant, outlines the 5 step consulting process and the specific skills required to excel at consulting.

Customer Service – Reaching for Remarkable

A provider of excellent customer service uses skills and behaviours to listen to, identify and act upon the wants, needs and emotions of their customers. This course is about exploring those customer-focused behaviours to move beyond delivering just good customer service to delivering remarkable customer service. Being remarkable will delight your customers, secure their loyalty and grow your business.

Customer Service Excellence

In an increasingly competitive and service focused market, clients expect and demand increased levels of service. This course provides extremely useful and practical approaches to handle this fact including strategies and techniques for identifying client needs.

Emerging Leaders Program

Being technically excellent will only get you so far. The ability to inspire and lead others in order to meet organisational objectives and achieve outstanding results are what differentiate successful managers from the pack. The key skills for driving business performance in the 21st century are:
 
Learning and collaborating - creating new knowledge and communicating and working with others
Critical thinking and problem solving - analysing options and reaching workable solutions
Creativity and innovation - working creatively with others to implement innovative ideas
Flexibility and adaptability - understanding, negotiating and balancing diverse views to initiate and aid
  others in adapting to change

Excel Advanced

Master complex formulas and learn about best practice in designing  secure‚ robust and user friendly spreadsheet solutions.
Duration: 1 day
Level: Experienced
Pre-requisites: Completion of MCI Solutions Excel Introduction course or equivalent
Versions: This course is suitable for users of Excel 2010, 2013 and 2016
Not sure which level to attend? Click here to take our quick online course prerequisite test

Excel Intermediate

Learn techniques to help you get the most out of Excel formulas‚ charts and Pivot Tables. You will learn how to effectively analyse data, make better decisions and produce insightful reports.
Duration: 1 day
Level : Experienced
Pre-requisites: Completion of MCI Solutions Excel Introduction course or equivalent
Versions: This course is suitable for users of Excel version 2010, 2013 and 2016
Not sure which level to attend? Click here to take our quick online course prerequisite test

Excel Introduction

Learn to create‚ edit, format and print a simple spreadsheet with basic calculation formulas.
Duration: 1 day 
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for users of Excel 2010, 2013 and 2016
Not sure which level to attend? Click here to take our quick online course prerequisite test

Excel VBA Advanced

You will learn complex programming methods and practices and write code using the VBA Editor. You will learn how to write String Functions, code macros to handle errors, interact with Charts and other Microsoft Applications and how to create complex user forms to capture input data
Duration: 2 days
Level : Experienced
Pre-requisites: Completion of MCI Solutions Excel VBA Introduction course or equivalent
Versions: This course is suitable for Excel versions 2010, 2013, 2016

 

Excel VBA Introduction

This course will help experienced users of Excel to  create and edit macros using  Visual Basic for Applications (VBA) programming . Macros can be used to automate and speed up routine Excel tasks like reports and print jobs as well as more complex tasks like cleaning up imported data. You will also learn about good programming practices and how to write, edit and debug /fix VBA programs using the Visual Basic Editor.
Duration: 2 days
Level : Experienced
Pre-requisites: Completion of MCI Solutions Excel Advanced course or equivalent
Versions: This course is suitable for Excel versions 2010, 2013, 2016

Virtual Class - Excel: Advanced Filters for Databases and Lists

Learn to use Advanced Filters in Excel  to summarise and analyse large data lists and complex data sets.
Duration: 90 minutes virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and sorting and filtering simple data lists
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

 

Virtual Class - Excel: Automation with Macros

Learn to record, run and edit Macros to automate routine Excel tasks using the Macro Recorder and Visual Basic for Applications (VBA) programming code.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Charts and Graphs

Learn how to display Excel data graphically using a variety of compelling charts.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Collaboration and shared workbooks

Learn to share and co-author Excel workbooks and collaborate with team members online.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Excel: Dashboards

Learn how to create a dashboard in Excel to help you keep a visual track of important performance measures and targets in your spreadsheet models.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and charts
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Data modelling with Scenarios, Goal Seek & Solver

Learn how to use Scenario Manager, Goal Seek and Solver to perform complex spreadsheet modelling and how to quickly analyse options and make better decisions.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Error-proofing your spreadsheets

Learn how to find and fix common errors in spreadsheets and how to create models that have built-in error prevention mechanisms to help maintain data integrity.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Fast formatting tips

Learn tips and tricks for fast formatting. Apply best practices and improve the layout and presentation of your Excel data quickly and easily.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

 

Virtual Class - Excel: Formulas for everyday calculations

Learn how to write and edit simple formulas in Excel to calculate results. You will learn how to write formulas that add totals and calculate averages and how to use built-in formulas called Functions.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Formulas for financial analysis

Learn to use Excel formulas that work on financial data. Financial functions are used to calculate many finance related operations including loan repayments, depreciation of assets and rates of return on investments.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with formulas in Excel
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Excel: Formulas for more complex adding and multiplying

Learn to use Excel Functions for complex mathematical operations. Math functions are used for many mathematical operations including adding up totals, multiplying values and rounding numbers.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Excel: Formulas for statistical analysis

Learn how to use Excel Statistical Functions to calculate averages, standard deviations and other useful statistical information for analytical and reporting purposes.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Excel: Formulas for What-If analysis

Learn how to write and edit IF formulas to return results based on variable conditions in your spreadsheet data.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Formulas for working with text

Learn to use Excel Text Functions to clean up imported text and manipulate how textual data is stored and displayed.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with formulas in Excel
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Excel: Mastering VLOOKUP formulas

Learn how to create and edit VLOOKUP and other Lookup formulas to extract data from Excel lists and tables based on variable conditions and criteria.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Pivot Tables and Pivot Charts

Learn how to create and edit Pivot Tables and Pivot Charts to quickly visualise and analyse large Excel data sets and make better business decisions.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and charts
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Power Pivot and Power View

Learn to use Excel Power View and Power Pivot to connect to, analyze and visualize massive amounts of data.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and Pivot tables
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Excel: Quick viewing and printing tips

Learn tips and tricks for viewing and printing Excel data effectively and efficiently.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Sorting and Filtering Lists and Databases

Learn how to turn raw data into useful business information to help you make more informed decisions. Work with built-in, easy to use database and list management tools in Excel to analyse large sets of business data quickly and efficiently.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010, 2013 and 2016

Virtual Class - Excel: Top ten tips

Learn ten essential tips and shortcuts that will dramatically improve the way you use Excel.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Beginner
Pre-requisites: None
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016

Virtual Class - Power BI Dashboards

Learn to use Power BI Desktop - a suite of business analytics tools - to analyse data and share insights. Create dashboards to monitor your business with rich, interactive reports and visual analytics.
Duration: 90 minute virtual classroom delivered live online using Citrix GoToTraining
Level : Experienced
Pre-requisites: Basic familiarity with Excel formulas and Pivot tables
Versions: This course is suitable for Excel versions 2010‚ 2013 and 2016