Clean And Format Excel Data For Analysis: Intermediate

Clean And Format Excel Data For Analysis: Intermediate
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Take your Excel skills to the next level with Excel Intermediate.

What you’ll learn

Clean and standardize text data using functions.

Format data as a table for improved organization.

Remove blank rows, cells, and duplicates to clean data.

Utilize Flashfill and CONCAT for data manipulation and joining.

Requirements

Basic knowledge of Excel.

Understanding of basic Excel operations, including data entry, formatting cells, and simple formulas.

Access to Microsoft Excel 2021 (or similar versions with Get & Transform tools).

Description

Overview

Section 1: Prepare Data for Analysis

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Files

Lecture 4 DOWNLOAD ME: Exercise Files

Lecture 5 Importing Data into Excel

Lecture 6 Removing Blank Rows, Cells and Duplicates

Lecture 7 Changing Case and Removing Spaces

Lecture 8 Splitting Data using Text to Columns

Lecture 9 Splitting Data using Text Functions

Lecture 10 Splitting or Combining Cell Data Using Flashfill

Lecture 11 Joining Data using CONCAT

Lecture 12 Formatting Data as a Table

Lecture 13 Exercise

Lecture 14 Course Close

Beginners to intermediate Excel users familiar with basic Excel functions but want to level up their skills.,Data analyst and data professionals who want to improve their Excel data management skills.,Anyone looking to improve Excel skills whether for personal use or career growth.