Cleaning Data in Excel (1-Hour Recorded Webinar)
This recorded live webinar will walk you through various formulas and functions that can help you with cleaning data in Excel.
Our Excel expert trainer, Deb Ashby, discusses the common issues you may encounter with your data set and teach you various ways to clean and manipulate data before moving on to using Power Query to import, combine, and clean up data.
Deb covers the following:
- Why clean data?
- Common issues with data
- Adjusting rows and columns
- Deleting blank rows
- Filling blank cells
- Removing duplicates
- Clearing messy formatting
- Formatting columns
- Converting numbers stored as text to numbers
- Changing case
- Removing spaces, line breaks, and non-printing characters
- Finding and replacing data
- Check spelling
- Formatting data as a table
- Using functions to extract data
- Using Power Query to clean data
Watch the session here, and download the instructor demo files to follow along.
Cleaning Data in Excel – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
10 Tips for Better Outlook Email Management (1-Hour Recorded Webinar)
Using the Data Model to Create PivotTables (1-Hour Recorded Webinar)
Getting to Grips with PivotTables in Excel (1-Hour Recorded Webinar)
Please visit our free Microsoft Office resources center for more high-quality Microsoft guides.
Simon Calder
Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!
