Excel's Best Data Cleaning Tricks (Updated 2022)

Focused View

Yoda Learning

1:36:15

144 View

1. Go To (Special) - select cells by specific criteria

1.1 Go To - Special.xlsx

1. Use Go To (Special) feature - to locate errors and formula inconsistency.mp4

07:18

2. Use Go To (Special) feature - to fill up blank cells logically.mp4

05:48

3. Use Go To (Special) feature - for smart formatting.mp4

04:51

4. Quiz related to Go To - Special.html

2. FlashFill - automatically gives solution based on sample pattern

1.1 FlashFill.xlsx

1. Basics of FlashFill (Ctrl E) - Dos & Donts.mp4

06:54

2. Project - Extract complex bank details using FlashFill & Formulas.mp4

06:08

3. Project - Cleanup electricity usage details using FlashFill, Find & Replace.mp4

07:53

4. Quiz related to Flash Fill.html

3. Find & Replace

1.1 Find & Replace.xlsx

1. Find & Replace - Basics.mp4

02:45

2. Find & Replace - with wildcard characters .mp4

04:55

3. Find & Replace - Hidden tricks.mp4

03:57

4. Quiz related to Find and Replace.html

4. Text formulas - Extract relevant data and cleanup unformatted data

1. Use LEFT, RIGHT, MID and VALUE - to extract data.mp4

04:59

2.1 Text Formulas.xlsx

2. Use SEARCH with MID - to extract data.mp4

04:37

3. Use TRIM, LEN, SUBSTITUTE - to cleanup data.mp4

02:09

4. Use UPPER, PROPER, LOWER - to change case.mp4

00:49

5. Quiz related to Text Formulas.html

5. Text to Columns - split data into multiple cells

1.1 Text to Columns.xlsx

1. Text to Columns - Delimiter vs. Fixed Width.mp4

05:38

2. Text to Columns - Format Change (Date).mp4

02:38

3. Text to Columns - Troubleshoot hanging formulas.mp4

02:12

4. Quiz related to Text to Columns.html

6. Concatenate - Join data in one cell

1.1 Concatenate - Join Strings.xlsx

1. CONCATENATE (Basics) - using two methods.mp4

02:12

2. CONCATENATE vs. FlashFill.mp4

03:02

3. CONCATENATE vs. & vs. TEXTJOIN vs. CONCAT - Who is the best.mp4

02:50

4. Performing Concatenation using different methods in Excel.html

7. Excel's Power Query for Data Preparation

1.1 Power Query - Data Cleansing.xlsx

1. Power Query's feature - Split to Rows vs. Excel's Text to Columns.mp4

03:59

2. Power Query's feature - UnPivot columns.mp4

03:55

3. Quiz related to Power Query.html

8. Dealing with Duplicates

1.1 Duplicates.xlsx

1. Using Remove Duplicates feature vs. UNIQUE.mp4

02:05

2. Use COUNTIFS to detect duplicates.mp4

03:27

3. Quiz related to Remove or Recognize duplicates.html

9. Formatting tricks

1.1 Formatting.xlsx

1. Formatting tricks - Clear Format, Double-click Format Painter.mp4

01:14

Description

Excel's best data cleaning tricks - a course to supercharge your Excel productivity in 1.5 hrs

What You'll Learn?

Data Cleaning formulas & features in Excel
FlashFill, Find & Replace, Go To (Special)
Text to Columns, Text formulas
Power Query's WOW features

Who is this for?

Excel - Basic to Intermediate users

What You Need to Know?

Basic knowledge of Excel

Some formulas are available in Office 365 or Excel 2019

More details

Description
This course helps you learn Excel's data cleaning features.
This includes multiple formulas and techniques.
Features - FlashFill, Go To (Special), Text to Columns, Power Query
Formulas - MID, LEFT, RIGHT, TEXTJOIN, CONCATENATE, SEARCH, SUBSTITUTE, etc.
Special use cases and hidden tricks NOT included in other programs are shared in this course.
E.g., using wildcard with Find & Replace, new age Concatenation formula - TEXTJOIN, FlashFill on complex data, Date format correction, etc.

The instructor has taught 1000s of consulting professionals from two of the Big4 firms.Â
His practical experience is reflected in our TrustPilot ratings (Yoda Learning). What past learners have to say -
Vijay - "Advanced Excel course is so good the reviews were given by C-Suite of Mckinsey Australia and seeing that I had opted for it, and it very much helps for Sr Managers to use these techniques though for more than a decade have been using but some of the niceities for sure a very much been missed by much of the Directors, even Sr Directors as such this course gives much edge for the people who take."

You just don't want to learn a feature. You want to learn where it is used in real-life. The bonus is hidden tips and tricks neatly embedded in the video.

Note:
Once enrolled, you have unlimited, lifetime access to the course!
Practice files
Access to all videos 24 x 7
Udemy's 30-day money back guarantee
Who this course is for:
Excel - Basic to Intermediate users

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Yoda Learning

Instructor's Courses

20,000 Classroom Students | 100,000+ Students Onlineex-KPMG, ex-J.P. Morgan | Chartered AccountantTaught 12k+ participants across PwC, EY and Deloitte over last 10 yearsI am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.