Startseite Kurse durchsuchen Office & Documents Excel Power User: Pivot Tables, Power Query and Macros
Kostenloser Kurs English Verifiziertes Zertifikat 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 Bewertungen)
94 eingeschriebene Lernende
758 Aufrufe
30 lessons
~15 min gesamt
Im eigenen Tempo, lebenslanger Zugriff

Worum geht es in diesem Kurs?

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.

Was sind die wichtigsten Fakten zu diesem Kurs?

Preis Kostenlos
Zertifikat Verifiziertes Zertifikat
Dauer 15 min
Lektionen 30
Sprache English
Niveau Beginner
Prüfung Im eigenen Tempo, lebenslanger Zugriff

Lehrplan

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

Abschlusszertifikat

Nach Abschluss des Kurses schaltest du ein verifiziertes Zertifikat frei — als PDF herunterladbar, mit eindeutiger Nummer und Verifizierungslink.

Jedes Zertifikat hat einen eindeutigen Verifizierungslink und QR-Code.

Häufig gestellte Fragen

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?

Nach Abschluss des Kurses kannst du ein verifiziertes Zertifikat mit eindeutiger Nummer und öffentlichem Verifizierungslink herunterladen.

Bewertungen von Lernenden

4.4
5 Bewertungen
5
3
4
1
3
1
2
0
1
0
O
Olivia H. Verifiziert · 29 Apr 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. Verifiziert · 30 Mär 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. Verifiziert · 15 Feb 2026

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

A
Andrew S. Verifiziert · 8 Dez 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. Verifiziert · 7 Jul 2025

Macros without the mystery

Learned how to automate repetitive monthly report steps.

Das könnte Ihnen auch gefallen

Python for Business Automation Kostenlos Verified
🇬🇧 EN 17 3h

Python for Business Automation

#Büro & Dokumente #python #business
4.5 (4) · 146
Google Workspace Mastery: Docs, Sheets, Slides Kostenlos Verified
🇬🇧 EN 30 6h

Google Workspace Mastery: Docs, Sheets, Slides

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