Donna Hanson's Online Courses

With so much information available at our fingertips, most people I work with struggle to analyze their data in Excel.  

This is often because they weren’t aware that they needed to “clean” their data up BEFORE they start 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! I have put this short course together to focus just on how to Clean Up Data in Microsoft Excel to make it easier to start analyzing your information in Excel.  

The added bonus is that if it 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

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

NOTE: It doesn't matter what version of Microsoft Excel you are using, the topics covered in this program will work