Skip to content

Excel Data Magic: Cleaning, Formatting & Manipulating Data with Ease

01 Format & Clean Messy Data

01 - 00 Intro and Resources

01 - 01 Formatting Messy Data the Easy Way

01 - 02 Remove All Formatting Instantly Sample Lesson

01 - 03 Remove Extra Spaces or Bad Characters

01 - 04 Make Text UPPER, lower or Proper Case

01 - 05 Removing Duplicates and Getting a Unique List Instantly

01 - 06 Excel A.I. to Split Columns & Correcting Flash Fill

01 - 07 Importing A Text Document into Excel (3 methods)

01 - 08 Separate One Column into Many Columns

02 Find & Fix Errors

02 - 01 Delete Blank Rows or Columns

02 - 02 Delete Rows That Have Blank Cells

02 - 03 Fill Blank Cells with Zero (or anything else)

02 - 04 Finding and Replacing Mistakes, Advanced Wildcards Trick

02 - 05 Using Filter To Ensure Consistent Naming, Spelling and Grammar Tool

02 - 06 HIghlight or Remove Error Cells

02 - 07 Dealing with Trailing Minus and Debit-Credit Symbols

03 Advanced Solutions

03 - 01 Rotate Cell Data with Transpose (2 Methods)

03 - 02 Unstack Data To Single Rows

03 - 03 Highlight Duplicates in 1 or More Columns

03 - 04 Converting Text Numbers to Real Numbers, Numbers to Percent

03 - 05 Data Validation Tricks

03 - 06 Change Language Trick for Huge List Instantly Sample Lesson

04 Format/Analysis Functions

04 - 01 FIND and SEARCH functions

04 - 02 REPLACE and SUBSTITUTE functions

04 - 03 LEFT, RIGHT, LEN, MID Functions

04 - 04 Combining Columns and Making Mini-Report Summaries

04 - 05 Does a Cell Contain Certain Text

04 - 06 Adding Leading Zeros to Number Field

05 Lookup Functions

05 - 01 Lookup, VLookup and HLookup Functions

05 - 02 Index, Match Functions

05 - 03 XLOOKUP Function Sample Lesson

06 Date & Time Functions

06 - 01 Fixing Dates and Times

06 - 02 Cleaning Invalid Date Formats

Previous Lesson

03 - 06 Change Language Trick for Huge List Instantly

Excel Data Magic: Cleaning, Formatting & Manipulating Data with Ease
03 - 06 Change Language Trick for Huge List Instantly

Previous Lesson

Leave a Comment Click here to cancel reply.

You must be logged in to post a comment.

X

Username

Password

Remember me

Forgot Password?

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account