It is said that around 80 – 85% of time is spent on data cleaning & data transformation by Data Scientists, Data Engineers & Data Analysts. With Power Query tool, acquiring, transforming, and preparing data becomes faster and simpler. Microsoft Excel’s Power Query tool is the biggest feature Microsoft has added to Excel since Pivot Tables. It will save loads of time as you take advantage of this powerful feature.

Training will be given by Microsoft Certified Excel & Power BI Professional & Microsoft Certified Trainer, has trained 15,000+ world-wide Industry Professionals, University Professors, and Students in MS Excel, MS Power BI, Tableau and Google Looker Studio. He has a reputation for delivering excellent, logically structured courses that are easy to follow and get the point across without wasting learners’ time.

In this brand new 12-hour live virtual training on MS Excel – Advanced Level, you will learn how to use Excel Power Query to CONNECT & TRANSFORM data in Excel and perform ADVANCED TRANSFORMATION like Merging, Appending, Unpivoting, Grouping and Custom Calculations. Also, you will learn how to create DATA MODELS in Excel and perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Segmentation. At completion of this training, you will have mastered the most popular & widely used Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace.