Udemy

Excel's Best Data Cleaning Tricks (Updated 2023)

Enroll Now
  • 336 Students
  • Updated 4/2023
4.8
(46 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 36 Minute(s)
Language
English
Taught by
Yoda Learning
Rating
4.8
(46 Ratings)

Course Overview

Excel's Best Data Cleaning Tricks (Updated 2023)

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

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

Course Content

  • 10 section(s)
  • 25 lecture(s)
  • Section 1 General
  • Section 2 Go To (Special) - select cells by specific criteria
  • Section 3 FlashFill - automatically gives solution based on sample pattern
  • Section 4 Find & Replace
  • Section 5 Text formulas - Extract relevant data and cleanup unformatted data
  • Section 6 Text to Columns - split data into multiple cells
  • Section 7 Concatenate - Join data in one cell
  • Section 8 Excel's Power Query for Data Preparation
  • Section 9 Dealing with Duplicates
  • Section 10 Formatting tricks

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

Skills covered in this course


Reviews

  • G
    Gabriel Jattani Tolosa
    5.0

    This is exactly what I was looking for. Thanks

  • G
    Gemma Maria Tony
    5.0

    Great

  • A
    Anahi Garcia Rojas
    5.0

    Thank you

  • D
    Dylan Reneau
    5.0

    Videos are clear and concise.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed