Knowledge Accelerators
Intermediate Excel: Data Modeling, Analysis, and Dashboards
Knowledge Accelerators

Intermediate Excel: Data Modeling, Analysis, and Dashboards

Keith Gibson

Instructor: Keith Gibson

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

2 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

2 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Essential skills to import, clean and format data (plus an introduction to using power query to automatically maintain data in Excel)

  • Understand and build confidence creating pivot tables, pivot charts, slicers, filters, dashboards for use in Excel

  • Manage and protect Excel workbook data to maintain data security and learn to keep data integrity intact

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

September 2025

Assessments

13 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 6 modules in this course

Streamline your workflow and take control of your data! Discover how to import, explore, and prepare information effortlessly using powerful Excel tools. Through quick videos and interactive activities, you’ll learn to automate repetitive tasks and eliminate manual work so you can spend more time uncovering insights that drive smarter decisions.

What's included

10 videos3 assignments

Quickly summarize and analyze large datasets with PivotTables without using complicated formulas. Watch short videos and complete interactive activities to group, aggregate, and refresh data dynamically, so you can uncover trends and make smarter decisions in minutes.

What's included

4 videos2 assignments

Combine data from multiple sources and create relationships between tables to build powerful data models in Excel. Through short videos and interactive activities, you’ll learn to use Power Pivot to organize complex data and generate dynamic insights.

What's included

5 videos2 assignments

Turn your PivotTables into interactive charts that make data easier to understand and explore. Through short videos and hands-on activities, you’ll learn to create PivotCharts and apply filters for dynamic, visual analysis.

What's included

5 videos2 assignments

Bring your data to life with interactive dashboards, right inside Excel. Combine PivotTables, PivotCharts, slicers, and timelines into a single, dynamic dashboard. Through short videos and a hands-on activity, you’ll discover how to arrange, format, and control multiple elements for a polished, Power BI–style experience.

What's included

5 videos2 assignments

Keep your data secure and maintain control over edits in Excel. Learn how to protect entire workbooks or specific cells, manage permissions, and review recent changes. Through short videos and a hands-on activity, you’ll gain the skills to safeguard your work while collaborating effectively.

What's included

4 videos2 assignments

Instructor

Keith Gibson
Knowledge Accelerators
17 Courses392,700 learners

Offered by

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Coursera Plus

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions