4.75
(4 Ratings)

Master Power query

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Dive into the world of Power Query, Excel’s game-changing tool for data transformation and automation. This course will take you from beginner to expert, equipping you with the skills to clean, reshape, and automate data workflows efficiently. Say goodbye to repetitive manual tasks and hello to smarter, faster data processing.

What You’ll Learn:

  • How to access and import data from various sources.
  • Transforming and cleaning messy data with ease.
  • Merging and appending datasets for seamless integration.
  • Advanced techniques like conditional columns and custom transformations.
  • Automating data workflows to save time and reduce errors.
  • Best practices for managing and sharing Power Query solutions.

Why This Course?
Power Query is an essential tool for anyone dealing with large or complex datasets. By mastering it, you’ll improve your productivity and enhance your ability to derive actionable insights from data. Whether you’re an analyst, accountant, or Excel power user, this course will revolutionize the way you work with data.

Show More

Course Content

1-What is get and transform

  • Download exercise file
  • 01-Intro about get transform
    02:20
  • 02-Power query Example
    09:57
  • 03-Diffrence between Excel & power query
    08:38

2-Working with quires

3-Working with columns

4-Working with formulas

5-Pivoting and unpivoting data

6-Grouping

7-Appending a query

Student Ratings & Reviews

4.8
Total 4 Ratings
5
3 Ratings
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
MG
2 weeks ago
Wonderful Course Very informative
HE
2 months ago
Gamed😎
DA
2 months ago
thanks
HG
2 months ago
Good
whatsapp-logo
Need help?
Kindly provide your credentials to gain access to your account.

Google reCaptcha: Invalid site key.

Forget your password? Lost password

Don’t have account? Register