Excel: Data Analysis with Formulas/Functions and PivotTables
Completed by MarÃa Antonieta Bogantes Villalobos
February 21, 2026
4 hours (approximately)
MarÃa Antonieta Bogantes Villalobos's account is verified. Coursera certifies their successful completion of Excel: Data Analysis with Formulas/Functions and PivotTables
What you will learn
Construct advanced spreadsheet formulas using named ranges, logical functions, and nested evaluation criteria.
Control user input quality using data validation dialog boxes, custom error alerts, and interactive form layout controls.
Summarize massive transactional datasets into dynamic reporting views using dynamic array lookups and automated PivotTables.
Data files for this course are provided in the first course of this specialization, "Excel: Data Analysis and Visualization Fundamentals".
Skills you will gain
- Category: Excel Formulas
- Category: Spreadsheet Software
- Category: Pivot Tables And Charts
- Category: Data Validation
- Category: Data Analysis
- Category: Data Visualization
- Category: Microsoft Excel
- Category: Interactive Data Visualization
- Category: Data Integrity
- Category: Productivity Software
- Category: Microsoft 365
