Advanced MS Excel for Auditors and Consultants

Or log in to access your purchased courses

An online MS Excel course that will teach you all of the key tools that would be required by Auditors and Consultants. .

When you sign up you get access to 4 separate courses so that you can learn in increments. This course is perfect for all auditors and consultants who regularly have to:

  • get information from clients
  • rework it to make it usable
  • analyse it to see what it is saying
  • present the findings and set up management reports.

It is recommended that you are at at least an Intermediate MS Excel level (assess yourself with our free MS Excel Skills Assessment )

Adrian
Course By

Adrian

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Lessons

About the ‘Data Cleanup in Excel Course’

Free Preview

Length: 5 minutesComplexity: Easy

No matter what your client says, the data you get is never in EXACTLY the correct format. You will need to do some cleaning up and scrubbing to make it useable. This course shows you all the tips and tricks with cleaning up data.

About the ‘PowerQuery Course’

Free Preview

Length: 5 minutesComplexity: Easy

PowerQuery is the free new tool in Excel that is built for data cleanup issues. It solves all the problems that you thought you needed VBA for and makes it easy to automate regular data cleanup processes.

About the ‘Pivot Tables in Excel Course’

Free Preview

Length: 5 minutesComplexity: Easy

Before you can present any useful findings, you will need to be able to (easily) play with the data to see what the trends are, where the anomalies are, and determine which reports are meaningful. Pivot Tables are the ideal way to quickly and easily create reports and look at getting true business intelligence out of them.

About the ‘Excel Dashboards and Management Reporting Course’

Free Preview

Length: 5 minutesComplexity: Easy

Once you know what you are trying to tell your client, you need to be able to convert it to meaningful, reusable reports and visualisation to help the client understand the issues. This course shows all the tips on how to build Excel dashboards and management reports.