FREE ONLINE LIVE SESSION

Excel Data Cleaning tricks - Beyond Basics (2022 updates)

Saturday August 27th | 10AM Eastern time / 7:30PM IST

Data Cleaning in Excel helps you correctly use your raw data for data analysis. Problems include – wrong date format, mixed values in a single cell, data not in a proper tabular format, irrelevant values, etc.


What will you learn in this live session?

These days you don’t need to write lengthy VBA Macros code to clean up your data. You now have access to Power Query and Office 365’s new formulas.

The concepts of Data Cleansing also apply to Data Science and Machine Learning.

1. When to apply which technique?

Most of the tutorial videos teach you features. This webinar will guide you on the logic to decide which Excel feature to use when.

2. How to combine different techniques?

A LOT of times, you will have to combine multiple logics and/or formulas to get your job done.

3. What do you do when a technique (say, FlashFill) doesn’t work?

If you know how to solve a problem using alternative methods, you will never get stuck.


ABOUT THE HOSTS

Frequently Asked Questions

When is the Live Session?

The Live Session is on Saturday, 27th August, 2022 at 10AM Eastern time / 7:30PM IST

Will it be recorded?

No. it won’t be recorded

Do I get notes & files to practice?

Absolutely, You will get Practice files.

Days
Hours
Minutes
Seconds

FREE ONLINE LIVE SESSION

Excel Data Cleaning tricks - Beyond Basics (2022 updates)

Saturday August 27th | 10AM Eastern time / 7:30PM IST

Days
Hours
Minutes
Seconds

Data Cleaning in Excel helps you correctly use your raw data for data analysis. Problems include – wrong date format, mixed values in a single cell, data not in a proper tabular format, irrelevant values, etc.

What will you learn in this live session?

These days you don’t need to write lengthy VBA Macros code to clean up your data. You now have access to Power Query and Office 365’s new formulas.

The concepts of Data Cleansing also apply to Data Science and Machine Learning.

1. When to apply which technique?

Most of the tutorial videos teach you features. This webinar will guide you on the logic to decide which Excel feature to use when.

2. How to combine different techniques?

A LOT of times, you will have to combine multiple logics and/or formulas to get your job done.

3. What do you do when a technique (say, FlashFill) doesn’t work?

If you know how to solve a problem using alternative methods, you will never get stuck.


ABOUT THE HOSTS

Rishabh Pugalia

Trained 80K+ professionals through LIVE workshop since 2010, Taught at PwC, EY, Flipkart, XLRI, and many more.

Frequently Asked Questions

When is the Workshop?

The Workshop is on Saturday, 27th August, 2022 at 10AM Eastern time / 7:30PM IST

Will it be recorded?

No. it won’t be recorded

Do I get notes & files to practice?

Absolutely, You will get Practice files.