About the ‘Data Cleanup in Excel Course’

The Data Cleanup in Excel course covers all the tools and functions that can be used to clean or scrub your data.

Data Cleanup in Excel Course Details

  • 44 lessons
  • 92 video clips
  • 21 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
  • Aimed at Intermediate and above Excel users, based on our free Excel skills assessments
  • Equivalent of attending a 1 day live course
  • Lifetime access
  • Start/ stop as required and repeat when necessary

Examples of what you will be able to do

After the lessons and exercises you will be able to:

Split key text into their own columns

 

Easily delete unwanted rows

 

Fill in Gaps (easily)

 

Make a report into a database
Perform more complex data normalisations

 

Convert numbers that Excel does not recognise
Fix ‘numbers’ that Excel seems to not see

 

Keep/ put back leading zeros

 

Remove parts of cells

 

Keep leading zeros especially when importing data

 

Fix messy system dates
Sort out problemsome Excel dates

 

Split columns based on constant size

 

Put imported data into its own Excel columns

 

Split columns using formula
Split text into columns based on a delimitor

 

Identify duplicates
Identify duplicates for deletion or further analysis

 

Neaten up your spreadsheets

 

and much, much more!

For the full list of contents go back to the Data Cleanup in Excel Course contents main page.

Buy the course now to get immediate access!

Back to: Advanced MS Excel for Auditors and Consultants