Objective: Learn the skills needed to clean up data to facilitate analysis, such as sorting, filtering, and creating pivot tables and graphs.

With so much information available at our fingertips, most people struggle to analyse their data in Excel. This is often because they weren’t aware that they needed to “clean” their data up BEFORE they started sorting and filtering or creating pivot tables or charts. As a result, they run into errors and roadblocks that make doing this regular task both frustrating and time-consuming!

If this sounds like you, you are in the right place! Donna Hanson has put this short course together to focus on Cleaning up Data in Microsoft Excel, making it easier to start analysing your information in Excel.

The added bonus is that if it is exactly the same every single time, you may even be able to automate it with a macro!

What you will learn in this course :

- The most common tools and techniques you will need to tidy up data imported into Excel from programs such as Oracle, SAP or accounting programs.
- How to take data in one column and split it into two based upon a particular criteria
- How to connect text in two columns together into one cell
- The simple way to remove duplicate entries in your data lists
- How to easily change cells containing numbers that Excel considers text so you can perform calculations
- How to change or correct text casing

This user-friendly, jargon-free course is a MUST for anyone working with large amounts of data who wants help cleaning up data so they can get on with analyzing it in Microsoft Excel.