Tutorialspoint

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

Microsoft Excel Power Query - Master Power Query!

person icon Biztech Matters

4.3

Microsoft Excel Power Query - Master Power Query!

Master Microsoft Excel Power Query, Get & Transform in Excel Power Query 2010-2019 and Excel Power Query for Office 365

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Biztech Matters

category icon Office Productivity,Excel

Lectures -36

Resources -1

Duration -3 hours

4.3

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

You’re Just Seconds Away From Leveraging Excel & Power Query That Will Make It Possible For YOU To:

  1. Increase your Excel & Power Query SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel & Power Query which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel Power Query with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

This is the Ultimate Microsoft Excel Data Cleansing course which has over 60 short and precise tutorials. This course was created by the No1 ranked Excel course creator (John Michaloudis) and an Excel Book Author (Bryan Hong)!

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single analytical & data cleansing tool that is available in Microsoft Excel. 

The course is designed for Excel 2007, 2010, 2013, 2016 or 2019 and Office 365. There are 21 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life examples.

In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers! 

The course is just over 4 hours long so you can become an awesome analyst and advanced Excel user within 1 day!
----------------------------------------

The course covers all of Excel's must-know features for importing, cleaning up and transforming messy data that gets downloaded from an external data source or an Excel file.

In the first part of the course you will learn the various "Data Cleansing" techniques using Power Query or Get & Transform - as its name changed in Excel 2019 and Office 365.  We will show you how to:

  • Clean & transform lots of data quickly

  • Import data from various external sources, folders & Excel workbooks

  • Consolidate data with ease

  • Sort & Filter data

  • Merge data

  • Join data

  • Data shaping & flat files

  • Auto cleanup your data

  • M Functions

----------------------------------------

In the second part of the course you will learn "Data Cleansing" techniques using various Excel features such as:

  • Text Function

  • Logical and Lookup Functions

  • Text to Columns

  • Find & Remove Duplicates

  • Conditional Formatting

  • Find & Replace

  • Go to Special

  • Sort & Filter

----------------------------------------

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including downloadable Excel workbooks, Quizzes, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Who this course is for:

  • People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
  • People who want to change career and apply for a new job
  • If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Goals

What will you learn in this course:

  • Become more PRODUCTIVE at using Excel Power Query which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!

  • We teach you how to use Excel Power Quey with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

  • Increase your Excel & Power Query SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  • Use Text, Lookup & Logical Formulas & Functions to pull data out & reorganize it to your desired outcome

  • Learn the various Data Analytical tools within Excel to easily find & clean your data such as: Text to Columns, Remove Duplicates, Find & Replace, Go to Special, Text to Columns, Sort & Filter plus much more

  • Use Conditional Formatting to find hidden and hard to find data

  • Discover the power of Excel Tables to give color and analytical power to your boring lists

  • Learn the various techniques within Power Query/Get & Transform to shape your data & consolidate reports without the need to use Formulas or Macros

Prerequisites

What are the prerequisites for this course?

  • Compatible with Microsoft Excel 2010, 2013, 2016, 2019 and Office 365

  • This course is for Excel Beginners, Intermediates or Advanced Users

  • No prior Power Query knowledge is required

Microsoft Excel Power Query - Master Power Query!

Curriculum

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

Introduction
1 Lectures
  • play icon Introduction to Power Query 03:04 03:04
POWER QUERY (GET & TRANSFORM) - INTRO
7 Lectures
Tutorialspoint
POWER QUERY (GET & TRANSFORM) - SORT & FILTER
2 Lectures
Tutorialspoint
POWER QUERY (GET & TRANSFORM) - FROM EXCEL WORKBOOK
2 Lectures
Tutorialspoint
POWER QUERY (GET & TRANSFORM) - MERGE
1 Lectures
Tutorialspoint
POWER QUERY (GET & TRANSFORM) - JOINS
3 Lectures
Tutorialspoint
POWER QUERY (GET & TRANSFORM) - Auto Cleanup
1 Lectures
Tutorialspoint
Power Query M - Introduction
3 Lectures
Tutorialspoint
Power Query M - Various Uses
9 Lectures
Tutorialspoint
POWER QUERY PRO TIPS!
7 Lectures
Tutorialspoint

Instructor Details

user profile image

Biztech Matters

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

Feedbacks

T

Taranvir Singh Ugal

Really Helpful

U

Ujjwal singh bisht

easy to understand. Please solve mine query which I asked in QNA session.

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