Microsoft Excel Training

SecretsNinjasGurusDashboardsBusiness IntelligencePower BI Desktop Visualisations

Excel Secrets (Level 1)

Microsoft Excel Spreadsheet

Learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulas everyone should know! Secrets of formatting and navigating super-fast and how to create charts which are a stunning representation of your figures. You will create a chart with one click and learn how to manage large workbooks. A day crammed with delightful shortcuts and quicker ways to work!

Our Excel Secrets course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!).

You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know!

Excel Ninjas – Level 2


You’ll cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links; special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Make amazing tables in one click with secret built in formula; You’ll learn how to speed up navigation around your spreadsheet and use range names in formula; using the auditing features to check your work and protect your spreadsheet. We take a look at useful built in templates and how you can use them and finish with a first look at Pivot Tables and Charts.

To help you become an Excel Ninja on this course we cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links.

We also look at special number formats to speed up data entry, ways to collapse large workbooks to see the totals you need and advanced charting – making amazing tables in one click with the secret built in formula!

Excel Gurus – Level 3

You will learn how to become an Excel Guru using Logical functions to work out ‘What IF’ questions. We cover 5 Popular Math and statistical functions for geeks but in a way that makes it easy to understand and conquer! Financial, Date and Time functions and Array formulas, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; Cover importing and exporting data into Excel, how to use built-in Analytical tools like Goal Seek and Solver and finally discover how to cut down repetitive tasks by creating your own macros.

On this course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes it easy to understand and conquer! Financial, Date and Time Functions and Array Formulae, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; cover Importing and Exporting Data into Excel, how to use built in Analytical Tools like Goal Seek and Solver and finally discover how to cut down repetitive tasks by creating your own Macros. The ability to use advanced formulas will set you apart giving you that all important edge in knowledge and skills enabling you to do your work faster and more effectively.

Excel Dashboards

Microsoft Excel Advanced Dashboards

If the numbers you need to track are spread out across different systems, learn how to have everything on one screen so all you need to do is give it a glance. Yes, it’s time to make a dashboard. It’s like the instrument panel for your business. Your car has one. Planes have one. Let us help you make one for your business too.

Excel Business Intelligence


When you need to see all your key business data and be able to visualise what this data means…Learn how to shape and show your data faster using Get & Transform, Power Pivot, Power Maps and a first look at Excel Desktop Power BI Visualisations.

This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel Business Intelligence course has been developed to fill the gap with this innovative new collection of add-on features in Microsoft Excel 2013. This course runs through getting the BI modules installed, then how to use the 4 new tools – Power Query, Power Pivot, Power Maps and a first look at Excel Desktop Power BI Visualisations.

Excel Power BI Desktop Visualisations (Level 6)

Microsoft Excel Advanced Dashboards

This training course is a practical guide to using the Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

Learn to create dashboards to analyse and interrogate large data sets.

Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues.