Excel Cleaning Data: Bits & Bytes|System Source

During this one-hour live webinar session, our top-rated instructor will demonstrate the process and tools needed to import data into excel. Imported data frequently needs to be cleaned to properly sort, filter, and manipulated for reporting. Students are encouraged to ask questions in the chat window at any time during the demonstration.

This is a demonstration style webinar and Q&A Session only, no software/files


09/25/25 - VIR - Live Virtual Demo w/ Q&A - Live Virtual Demo w/ Q&A	(click to enroll)
12/15/25 - VIR - Live Virtual Demo w/ Q&A - Live Virtual Demo w/ Q&A	(click to enroll)

During this live demonstration you will learn to:

Import Text Files
Format Dates
Find Blank Cells (Ranges)
Add a Range of Blank Cells
Trim Text
Concatenate Text
Text to Columns

Importing Text Files
1. Import wizard
2. Copying sheets from one workbook to another
Formatting Dates
Finding Blank Cells (Ranges)
1. Filling in missing data
2. Copying and pasting formulas as values
Adding a Range of Blank Cells
1. Filling in a new range with a date
Trimming Text
Concatenating Text
Text to Columns

Excel Cleaning Data: Bits & Bytes

Course Overview

Scheduled Classes

What You'll Learn

Outline

Prerequisites

Who Should Attend

Next Step Courses