Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

MS Excel Power Query Course: Data cleaning with Power Query

person icon Asim Noaman Lodhi

4.2

MS Excel Power Query Course: Data cleaning with Power Query

Learn Excel functions to do data cleaning, data manipulation and analysis using Power Query (Excel 365, 2019 & 2016)

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Asim Noaman Lodhi

English [CC]

category icon Office Productivity,Excel

Lectures -16

Resources -13

Duration -1.5 hours

4.2

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Welcome to very simple yet powerful Excel: Data cleaning and analysis using Power Query functions.

We are glad to meet you. If only we could shake hands.

What makes our course different from others?

Our course content is unique - you learn exactly what you are required to do in your daily work.

You get 1 hours of crisp synthesized practical real life illustrations of all concepts.

You will be carrying out the real life illustrations along with the instructor.

Same set up as the instructor. All illustration spreadsheets are shared.

It's almost like as if somebody is guiding you in person to carry out the various analysis.

You are going to love our instructor's teaching style.

He makes it very engaging and fun learning experience.

You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course.

Our support team responds to any course queries within 24 hours of your request.

And of course, the price is competitive.

Learn Advanced Excel tricks on Data Cleaning Analytic - Go To, Date Correction, Replace using Wildcards, Text to Columns.

We get data from various sources like ERP, SAP and in different formats. In order to make it useful to analyse, we have to clean this and put them in a structured format. It's a pure time-consuming activity. In order to save time and effort on cleaning and put the structure in place, We need few important data cleaning techniques as mentioned below which are part of this course. Check the list of Topics being covered in this course on Data Cleaning in Excel:

Goals

What will you learn in this course:

  • Anyone can learn who wants to control business decisions.


Prerequisites

What are the prerequisites for this course?

  • Only Laptop or Desktop.
  • Power Query runs on Excel 2010 and 2013. Best if you have Excel 2016 or newer.
MS Excel Power Query Course: Data cleaning with Power Query

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
3 Lectures
  • play icon Introduction to Data Cleaning 01:40 01:40
  • play icon Power of Knowledge 01:40 01:40
  • play icon What is Mean by Data? 03:38 03:38
Introduction to Power Query
11 Lectures
Tutorialspoint
How to perform Descriptive Analysis
1 Lectures
Tutorialspoint
Final Assignment
1 Lectures
Tutorialspoint

Instructor Details

Asim Noaman Lodhi

Asim Noaman Lodhi

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515