Inicio Explorar cursos Office & Documents Excel Power User: Pivot Tables, Power Query and Macros
Curso gratuito English Certificado verificado 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 valoraciones)
94 estudiantes inscritos
759 visualizaciones
30 lessons
~15 min en total
A tu ritmo, acceso de por vida

¿De qué trata este curso?

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.

¿Cuáles son los datos clave de este curso?

Precio Gratis
Certificado Certificado verificado
Duración 15 min
Lecciones 30
Idioma English
Nivel Beginner
Examen A tu ritmo, acceso de por vida

Programa

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

Certificado de finalización

Al terminar este curso desbloquearás un certificado verificado — descargable en PDF, con número único y enlace de verificación pública.

Cada certificado tiene un enlace verificable único y un código QR.

Preguntas frecuentes

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?

Tras finalizar este curso podrás descargar un certificado verificado con un número único y enlace público de verificación.

Opiniones de los estudiantes

4.4
5 valoraciones
5
3
4
1
3
1
2
0
1
0
O
Olivia H. Verificado · 29 abr. 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. Verificado · 30 mar. 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. Verificado · 15 feb. 2026

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

A
Andrew S. Verificado · 8 dic. 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. Verificado · 7 jul. 2025

Macros without the mystery

Learned how to automate repetitive monthly report steps.

También te puede gustar

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

Python for Business Automation

#Oficina y documentos #python #business
4.5 (4) · 146
Google Workspace Mastery: Docs, Sheets, Slides Gratis Verified
🇬🇧 EN 30 6h

Google Workspace Mastery: Docs, Sheets, Slides

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