Home تصفح الدورات Office & Documents Excel Power User: Pivot Tables, Power Query and Macros
Free course English شهادة موثقة Beginner #office skills #documents #spreadsheets #workplace tools #power #excel #query #macros

Excel Power User: Pivot Tables, Power Query and Macros

In this course, you will learn how to work faster and more confidently in Excel. You will use PivotTables, Power Query, and macros to organize data, clean reports, and automate repeat tasks with practical workplace examples.

4.4 (5 ratings)
94 learners enrolled
758 views
30 lessons
~15 min total
Self-paced, lifetime access

عن ماذا تدور هذه الدورة؟

This beginner-friendly, hands-on course helps working professionals become confident Excel power users. You will learn how to organize data, summarize information quickly with PivotTables, clean and reshape data with Power Query, and automate repetitive tasks with macros. The course uses real-world workplace examples such as sales reports, expense tracking, customer lists, and monthly performance dashboards. Each module begins with a short introduction, each lesson includes clear explanations and practical guidance, and every lesson ends with 1-2 short exercises you can complete in 5-15 minutes. By the end of the course, you will be able to work faster, reduce manual errors, and create repeatable Excel workflows that save time every week.

ما أهم الحقائق حول هذه الدورة؟

السعر Free
الشهادة شهادة موثقة
المدة 15 min
الدروس 30
اللغة English
المستوى Beginner
الاختبار Self-paced, lifetime access

Curriculum

6 modules · 30 lessons

1
Module 1: Excel Power User Foundations
5 lessons
  • Lesson 1: Getting Started with Power User Thinking
  • Lesson 2: Navigating Excel Efficiently
  • Lesson 3: Data Entry Best Practices
  • Lesson 4: Basic Formatting for Clarity
  • Lesson 5: Understanding Tables and Workbook Structure
2
Module 2: Building and Using PivotTables
5 lessons
  • Lesson 1: What PivotTables Do and Why They Matter
  • Lesson 2: Creating Your First PivotTable
  • Lesson 3: Organizing and Formatting PivotTable Results
  • Lesson 4: Filtering, Slicers, and Drill-Downs
  • Lesson 5: PivotTable Best Practices and Common Problems
3
Module 3: Power Query for Cleaning and Shaping Data
5 lessons
  • Lesson 1: Why Power Query Changes the Way You Work
  • Lesson 2: Importing Data into Power Query
  • Lesson 3: Cleaning Data Step by Step
  • Lesson 4: Splitting, Merging, and Reshaping Columns
  • Lesson 5: Combining and Refreshing Queries
4
Module 4: Data Analysis and Reporting with PivotTables and Power Query
5 lessons
  • Lesson 1: From Clean Data to Insightful Reports
  • Lesson 2: Comparing Categories, Regions, and Time Periods
  • Lesson 3: Grouping Dates and Numbers
  • Lesson 4: Building Simple Dashboards
  • Lesson 5: Sharing and Presenting Your Analysis
5
Module 5: Macros and Automation Basics
5 lessons
  • Lesson 1: What Macros Are and When to Use Them
  • Lesson 2: Recording Your First Macro
  • Lesson 3: Managing Macro Security and File Types
  • Lesson 4: Reusing Macros for Everyday Tasks
  • Lesson 5: Troubleshooting Simple Macros
6
Module 6: Capstone Workflow and Real-World Practice
5 lessons
  • Lesson 1: Designing a Complete Excel Workflow
  • Lesson 2: Building a Repeatable Monthly Report
  • Lesson 3: Quality Checks and Error Prevention
  • Lesson 4: Choosing the Right Tool for the Job
  • Lesson 5: Final Capstone and Next Steps

Certificate of completion

بعد إكمال هذه الدورة ستفتح شهادة موثقة — قابلة للتنزيل بصيغة PDF مع رقم فريد ورابط تحقق.

Each certificate has a unique verifiable link and QR code.

Frequently asked questions

Is this course free to start?

Yes. You can start learning this course for free.

Who is this course for?

This course is designed for learners who want practical, job-relevant skills and a structured path from basics to application.

Do I need prior experience?

No prior experience is required unless specific prerequisites are listed in the course requirements section.

How long does this course take?

The estimated total study time for this course is 15 min.

How does the certificate work?

بعد إكمال هذه الدورة يمكنك تنزيل شهادة موثقة برقم فريد ورابط تحقق عام.

Learner reviews

4.4
5 ratings
5
3
4
1
3
1
2
0
1
0
O
Olivia H. Verified · 29 أبريل 2026

Helpful, just a bit basic

Good intro to PivotTables and Power Query. I just wished the macro section went a little deeper.

R
Rachel T. Verified · 30 مارس 2026

Power Query clicked

I finally got how to clean and reshape messy expense data with Power Query. That part was really practical.

C
Christopher G. Verified · 15 فبراير 2026

The sales-report PivotTables example stood out. Simple, and easy to reuse at work.

A
Andrew S. Verified · 8 ديسمبر 2025

Best for true beginners

Solid walkthrough of the basics, especially if you've never touched PivotTables or macros before. If you already know some Excel, parts of it will feel pretty slow.

D
David K. Verified · 7 يوليو 2025

Macros without the mystery

Learned how to automate repetitive monthly report steps.

You might also like

Python for Business Automation مجاني شهادة
🇬🇧 EN 17 3h

Python for Business Automation

#Office & Documents #python #business
4.5 (4) · 146
Google Workspace Mastery: Docs, Sheets, Slides مجاني شهادة
🇬🇧 EN 30 6h

Google Workspace Mastery: Docs, Sheets, Slides

#office skills #documents #spreadsheets
4.5 (4) · 34