5

0

ratings 

Microsoft Excel Power Query course is the perfect course for the professionals. Learn key concepts, strategies of Microsoft Excel Power Query and boost your career with a marketable skill. Learn from the experts and become an expert. 

£15.00
Course Access

Unlimited Duration

Last Updated

August 26, 2021

Students Enrolled

3

Course Duration

3 hours, 24 minutes

Course Instructor
Certification
This Microsoft Excel Power Query is designed for professionals who want to thrive in their profession. The Microsoft Excel Power Query course covers all the essential skills and knowledge needed to become specialised in this sector. You will learn real life knowledge and expertise from the industry experts and practitioners from this Microsoft Excel Power Query course.
 
The Microsoft Excel Power Query Course starts with the basic knowledge of Microsoft Excel Power Query and gradually shares expertise knowledge. In this course you will get a complete idea of Microsoft Excel Power Query with key concepts, strategies regarding use of it and in-depth knowledge. The Microsoft Excel Power Query course is completely an online course. You can access this course from any part of the world with just a smart device and the internet.
 
By the end of this course, you will get complete knowledge and marketable skills. The course also comes with an accredited certificate, which will add extra value to your resume and help you stand out in the job market. In short, Microsoft Excel Power Query Course is the perfect course to fast track your career. So what are you waiting for? Enrol today!
 

What you will learn

  • Become more PRODUCTIVE at using Excel Power Query which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
  • Increase your Excel & Power Query SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
  • 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
  • Discover the power of Excel Tables to give color and analytical power to your boring lists
  • Understand in what situations you need to use Excel Formulas v Excel Analytical Tools
  • We teach you how to use Excel Power Quey with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
  • Use Text, Lookup & Logical Formulas & Functions to pull data out & reorganize it to your desired outcome
  • Use Conditional Formatting to find hidden and hard to find data
  • Learn the various techniques within Power Query/Get & Transform to shape your data & consolidate reports without the need to use Formulas or Macros
 

Course Media

Who is this course for?

This course is ideal for those who work in or aspire to work in the following professions:
  • 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!
   

Why Choose Microsoft Excel Power Query course?

  • Accredited by CPD
  • Conducted by industry experts
  • Get Instant E-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • Tutor Support
   

Certification

By the successful completion of your course, you will get an instant accredited e-certificate. Our courses are fully accredited with updated industry knowledge and skills that aim at making you an expert in the field. The hard copy of the certificate is also available and can be sent to your address. The delivery charge is applicable with a shipping cost of £4.99. All the certificates have no expiry dates but to stay updated and valued certificates are recommended to be renewed every year.
   

Career Path

This training course will lead you to many different career opportunities, here are few prospects:
  • Office Administrator - £22,000 per annum
  • Data Analyst - £26,000 per annum
  • Microsoft Office Specialist - £42,500 per annum

Instructor

Profile Photo
5 5
115

Students

Microsoft Office | Finance | SQL

Accredited by

Course Curriculum

    • Introduction to Power Query 00:03:00
    • Installing Power Query in Excel 2010 00:05:00
    • Installing Power Query in Excel 2013 00:05:00
    • Power Query and Query Editor Ribbon 00:09:00
    • Split Text Fields 00:10:00
    • Trim 00:05:00
    • Format Dates and Values 00:02:00
    • Parsing URLs 00:05:00
    • Group By 00:03:00
    • Import From Folder 00:07:00
    • Filtering Rows 00:05:00
    • Sorting Columns 00:02:00
    • Extract Based on 2 Criteria 00:05:00
    • Compiling Data From Multiple Worksheets 00:04:00
    • Merge 00:08:00
    • Intro to Joins 00:04:00
    • Full Outer Join 00:06:00
    • Right Anti-Join 00:09:00
    • Doing Auto Cleanup 00:07:00
    • M Overview 00:02:00
    • M Function List using #Shared 00:02:00
    • Using M Functions 00:10:00
    • Viewing M Code 00:02:00
    • Simple M Expressions 00:08:00
    • Simple M Expressions – Nested Expressions 00:03:00
    • M Variables 00:08:00
    • M Functions 00:06:00
    • M Functions – Reusable Functions 00:02:00
    • M Functions – Invoking 00:00:35
    • Passing M Functions 00:08:00
    • Passing M Functions – Using the “each” keyword 00:03:00
    • Data Shaping and Flat Files 00:05:00
    • Extract Data from Forms 00:14:00
    • Pivoting Columns 00:03:00
    • Unpivoting Columns 00:06:00
    • Split Columns Into Other Columns 00:05:00
    • Transform and Add Columns 00:07:00
    • Modulo 00:06:00
    • Get Your Certificate & Transcript 00:00:00

Course Reviews

© Course Central 2021. Course Central is a trading style of Idea Republic Ltd. Company registered in England and Wales. Registration no: 08664232 | Registered Address: 1 Flag Business Exchange, Vicarage Farm Road, Peterborough, PE1 5TX | VAT no: 196 1993 55

X