4.75
(32 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 32 Ratings
5
27 Ratings
4
2 Ratings
3
3 Ratings
2
0 Rating
1
0 Rating
YA
1 day ago
اسلوب العرض واضح وشيق*
مختصر (مش قادر احكم مختصر بزيادة اوي ولا ده الطبيعي)*
مش قادر احكم برضوا او احدد هل الكورس مغطي جميع جوانب ونقاط وادوات الباور كويري او لأ *
AA
4 days ago
excellent
Thanks 🤩
MS
7 days ago
informative
MA
7 days 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 weeks ago
Excellent
amazing thank you very much
MS
2 weeks ago
Amazing and useful course .
AA
2 weeks ago
Amazing , " Query " It makes data more easy than wonderful. & The curriculum is amazingly well organized.
RA
2 weeks ago
-
MK
4 weeks ago
GDOF
YA
1 month ago
انا استمتعت جدا في الكورس وكان سهل والشرح بسيط وحتى لما واجهت شوية حاجات مش فهماها عندي اختيار اني اعيد الفيديو مرة واتنين
ولما طبقت الكلام ده على الشيتات اللي مرفقة مع كل سيشن استفدت كتير
SA
1 month ago
goood
AA
1 month ago
great explanation from great instructor, Thanks Mr Mohamed
TA
2 months ago
Exception
Nice information
ME
3 months ago
good
Professional
R
3 months ago
love it
AS
3 months ago
شرح رائع جزاكم الله خيرا
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