CPD Accredited Course
0
0
5
Students
GET THIS COURSE AND 1500+ OTHERS FOR ONLY £149. FIND OUT MORE
Course Overview
Gear up to get well equipped in Microsoft Excel: Master Power Query in 120 Minutes! now, and make up your mind to be the best in the business! All you need is proper training, firm support and a push to shine in your vocation, and Compliance Central is determined to provide you with it all! Explore what you got in this exclusive Microsoft Excel: Master Power Query in 120 Minutes! Skills, start learning and excel in it! This amazing Microsoft Excel: Master Power Query in 120 Minutes! course has been designed and developed by the industry specialists.! You’ll get to-the-point knowledge both practical and theoretical, and gain valuable insights into the business which will help you understand the drill better than ever! Join today, be skilled, learn with positive energy and enthusiasm, and create an excellent career using your full potential! Brace yourself, enrol now for an amazing venture!This Microsoft Excel: Master Power Query in 120 Minutes! Course Package Includes
- Comprehensive lessons and training provided by experts on Microsoft Excel: Master Power Query in 120 Minutes!
- Interactive online learning experience at your convenience
- 24/7 Access to the course materials and learner assistance
- Easy accessibility from any smart device (Laptop, Tablet, Smartphone etc.)
- A happy and handy learning experience for the professionals and students
- 100% learning satisfaction, guaranteed by Compliance Central
Certification
You can instantly download your certificate for £4.79 right after finishing the Microsoft Excel: Master Power Query in 120 Minutes! course. The hard copy of the certification will also be sent right at your doorstep via post for £10.79. All of our courses are continually reviewed to ensure their quality, and that provide appropriate current training for your chosen subject. As such, although certificates do not expire, it is recommended that they are reviewed or renewed on an annual basis.Who Is This Course For
Compliance Central aims to prepare efficient human resources for the industry and make it more productive than ever. This helpful course is suitable for any person who is interested in Microsoft Excel: Master Power Query in 120 Minutes!. There are no pre-requirements to take it. You can attend the course if you are a student, an enthusiast or a- Employee
- Employer
- Manager
- Supervisor
- Entrepreneur
- Business Professional
- Company Leader
- HR Professional
Course Currilcum
-
- Power Query Intro and Excel version 00:03:00
- Excel Power Query – Introduction 00:03:00
- Excel Power Query – Query Editor Ribbon 00:09:00
- Transform Data – Trim in Excel Power Query 00:05:00
- Transform Data – Format Dates and Values in Excel Power Query 00:02:00
- Transform Data – Parsing URLs in Excel Power Query 00:05:00
- Transform Data – Split Text Fields in Excel Power Query 00:10:00
- Transform Data – Group By in Excel Power Query 00:03:00
- Transform Data – Unpivoting Columns in Excel Power Query 00:05:00
- Transform Data – Pivoting Columns in Excel Power Query 00:02:00
- Transform Data – Split Columns into Other Columns in Excel Power Query 00:04:00
- Transform Data – Filtering Rows in Excel Power Query 00:05:00
- Transform Data – Sorting Columns in Excel Power Query 00:02:00
- Transform Data – Transform and Add Columns in Excel Power Query 00:07:00
- From Folder – Import From Folder in Excel Power Query 00:07:00
- From Folder – Doing Auto Cleanup in Excel Power Query 00:13:00
- From Folder – Extract Data from Forms in Excel Power Query 00:13:00
- From Workbook – Extract Multiple Criteria in Excel Power Query 00:05:00
- From Workbook – Extract Multiple Worksheets in Excel Power Query 00:04:00
- Joins – Intro to Joins 00:04:00
- Joins – Merging 00:08:00
- Joins – Full Outer Join 00:06:00
- Joins – Right Anti Join 00:09:00
- Power Query – Convert Reports into Pivot Tables 00:05:00
- Modulo 00:06:00
Student Reviews
Ben lim
Gaining improve knowledge in the construction project management and the course is easy to understand.
Mr Brian Joseph Keenan
Very good and informative and quick with marking my assignments and issuing my certificate.
Sarah D
Being a support worker I needed add a child care cert in my portfolio. I have done the course and that was really a good course.
Sam Ryder
The first aid course was very informative with well organised curriculum. I already have some bit and pieces knowledge of first aid, this course helped me a lot.
Ben lim
Gaining improve knowledge in the construction project management and the course is easy to understand.
Thelma Gittens
Highly recommended. The module is easy to understand and definitely the best value for money. Many thanks
BF Carey
First course with Compliance Central. It was a good experience.
Course Currilcum
-
- Power Query Intro and Excel version 00:03:00
- Excel Power Query – Introduction 00:03:00
- Excel Power Query – Query Editor Ribbon 00:09:00
- Transform Data – Trim in Excel Power Query 00:05:00
- Transform Data – Format Dates and Values in Excel Power Query 00:02:00
- Transform Data – Parsing URLs in Excel Power Query 00:05:00
- Transform Data – Split Text Fields in Excel Power Query 00:10:00
- Transform Data – Group By in Excel Power Query 00:03:00
- Transform Data – Unpivoting Columns in Excel Power Query 00:05:00
- Transform Data – Pivoting Columns in Excel Power Query 00:02:00
- Transform Data – Split Columns into Other Columns in Excel Power Query 00:04:00
- Transform Data – Filtering Rows in Excel Power Query 00:05:00
- Transform Data – Sorting Columns in Excel Power Query 00:02:00
- Transform Data – Transform and Add Columns in Excel Power Query 00:07:00
- From Folder – Import From Folder in Excel Power Query 00:07:00
- From Folder – Doing Auto Cleanup in Excel Power Query 00:13:00
- From Folder – Extract Data from Forms in Excel Power Query 00:13:00
- From Workbook – Extract Multiple Criteria in Excel Power Query 00:05:00
- From Workbook – Extract Multiple Worksheets in Excel Power Query 00:04:00
- Joins – Intro to Joins 00:04:00
- Joins – Merging 00:08:00
- Joins – Full Outer Join 00:06:00
- Joins – Right Anti Join 00:09:00
- Power Query – Convert Reports into Pivot Tables 00:05:00
- Modulo 00:06:00
