Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

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

Current Status

Not Enrolled

Price

Now Streaming in Excel Ninja Pro

Get Started

Course Content

01 Format & Clean Messy Data
01 - 00 Intro and Resources
01 - 01 Formatting Messy Data the Easy Way
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 - 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
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
06 Date & Time Functions
06 - 01 Fixing Dates and Times
06 - 02 Cleaning Invalid Date Formats

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2025 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram