Wait! Before you purchase, do you want access to this course and more for a single subscription?

Then choose the buy now button below to get access to this course AND a monthly Group Zoom Q&A call with me!

  • $67.00 / month

    $67.00 / monthDonna Hanson's Productivity Academy

    Wait! Before you purchase, do you want access to this course and more for a single subscription? Then choose the buy now button on the right to start your subscription and get access to this course and regular monthly Q&A calls with me!
    US$ 67 per month Buy Now!

Course Overview

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 

Course curriculum

  1. 1
    • What you need to know and do before you start this course

    • Download this reference booklet before you start

  2. 2
    • Before you start, watch this video

    • Excel 2016 (365) - Text to Columns

    • Excel 2016 (365) - Remove Duplicates

    • Excel 2016 (365) - Concatenate

    • Excel 2016 (365) - Text to Numbers

    • Excel 2016 (365) - Proper

    • Excel 2016 (365) - Lower case

    • Excel 2016 (365) - Upper case

    • Excel 2016 (365) - Find & Replace

    • Excel 2016 (365) - Trim

    • Excel 2016 (365) - Clear Formatting

  3. 3
    • Watch this important video BEFORE you start the Time to Automate segment!

    • Excel 2016 (365) - Macros

  4. 4
    • What's Next?