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.
Advanced MS Excel for Auditors and Consultants Course
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 )
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.
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.
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.