Importing and Cleaning Data in Excel

In this recorded, Excel webinar we look at how to import and clean data in Excel. Cleaning data is one of the most important skills you’ll need in Excel. In this session we look at various formulas and functions to help you clean data in Excel, we then move on to using Power Query to import, combine, and clean up data.

Download the accompanying files and follow along HERE

Note: We used multiple files for this session. They are saved in a DropBox folder. Click download in the top right and then unzip the folder to use them.

Agenda

• Why clean data?
• 10 data cleaning tips and tricks
  • Widen columns
  • Delete blank rows
  • Fill empty cells
  • Clear formatting
  • Remove duplicates
  • Format columns
  • Numbers stored as text
  • Changing case using the text functions
  • Find and replace
• Importing data into Excel from a text file
• Importing data from an Access file
• Using text functions to extract data
• Combining files in Power Query
• Basic clearing in Power Query
• Updating queries in Power Query

For more, free Excel content from Simon Sez IT. Take a look at our Excel Resource Centre.

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.