Excel’s Best Data Cleaning Tricks (Updated 2022)
Learn Excel’s data cleaning features with this comprehensive course. Discover formulas like MID, LEFT, RIGHT, TEXTJOIN, CONCATENATE, SEARCH, SUBSTITUTE, and more. Explore special use cases and hidden tricks not found in other programs. The instructor, who has taught professionals from top consulting firms, shares practical experience and real-life examples. Gain unlimited, lifetime access to practice files and videos. Suitable for Excel users at the basic to intermediate level. Enroll now and take advantage of Udemy’s 30-day money back guarantee.
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
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
Be the first to review “Excel’s Best Data Cleaning Tricks (Updated 2022)”
You must be logged in to post a review.
There are no reviews yet.