4.67
(39 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.7
Total 39 Ratings
5
30 Ratings
4
5 Ratings
3
4 Ratings
2
0 Rating
1
0 Rating
MA
2 weeks ago
Gooooood course
AK
4 weeks ago
Good
AB
4 weeks ago
powerfull
AE
4 weeks ago
good
MA
1 month ago
Really amazing
AS
1 month ago
Nice one
A
1 month ago
الكورس جيد و لكنه بسيط جدا و لا يخاطب افكار و مشاكل كتيرة يستطيع الباور كويرى حلها
ارجو العمل على هذا
YA
2 months ago
اسلوب العرض واضح وشيق*
مختصر (مش قادر احكم مختصر بزيادة اوي ولا ده الطبيعي)*
مش قادر احكم برضوا او احدد هل الكورس مغطي جميع جوانب ونقاط وادوات الباور كويري او لأ *
AA
2 months ago
excellent
AM
2 months ago
Thanks 🤩
MS
2 months ago
informative
MA
2 months ago
need more sessions about how to get data from PDF, how to choose from Pages or tables to append them in one table
MM
2 months ago
Excellent
Baker Adams Omran
2 months ago
amazing thank you very much
MS
2 months ago
Amazing and useful course .
AA
2 months ago
Amazing , " Query " It makes data more easy than wonderful. & The curriculum is amazingly well organized.
RA
2 months ago
-
MK
3 months ago
GDOF
YA
3 months ago
انا استمتعت جدا في الكورس وكان سهل والشرح بسيط وحتى لما واجهت شوية حاجات مش فهماها عندي اختيار اني اعيد الفيديو مرة واتنين
ولما طبقت الكلام ده على الشيتات اللي مرفقة مع كل سيشن استفدت كتير
SA
3 months ago
goood
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