Learn by Source
LinkedIn Learning · on LinkedIn Learning

Excel PivotTables: Mastering PivotTables and PivotCharts

Intermediate 4.1 hours English Course Certificate
SkillsExcelPivotTablesPivotChartsData summarisationGroupingReporting

Is this course right for you?

Our take
PivotTables are one of Excel's highest-leverage skills, and this LinkedIn Learning course covers them thoroughly.

Good for: Mastering PivotTables and PivotCharts, a high-leverage Excel skill.

Skip if: You are new to Excel or want full data analysis beyond pivots.

Over about four hours you learn to prepare data, build and format PivotTables, filter, sort and group, add calculated values, and create PivotCharts — the fast route from raw rows to insight. It assumes Excel basics and keeps its focus on pivots, so newcomers or people wanting full data analysis should look elsewhere. It sits behind a LinkedIn Learning subscription (usually a free trial first; free through many libraries), with Excel requiring its own Microsoft 365 licence. The completion certificate is evidence of the learning, not a formal credential. PivotTables work today much as they always have (as of 2026).

Comparison · LBS

Compare alternatives for Excel PivotTables: Mastering PivotTables and PivotCharts

Same topic, different options. We surface the trade-offs others hide so you can pick the course that actually fits your time, budget, and goals.
LinkedIn Learning
Excel PivotTables: Mastering PivotTables and PivotCharts
Price
Paid
LinkedIn Learning subscription
Duration
4.1 hrs
Level
Intermediate
Certificate
Course Certificate
LinkedIn Learning
Excel with Copilot: AI-Driven Data Analysis
Price
Paid
LinkedIn Learning subscription
Duration
1.6 hrs
Level
Intermediate
Certificate
Course Certificate
View course →
Udemy4.6(26,000)
Excel Skills for Business: Advanced Analytics
Price
Paid
Paid, frequently discounted
Duration
18 hrs
Level
Intermediate
Certificate
Course Certificate
View course →
LinkedIn Learning
Become a Financial Analyst
Price
Paid
LinkedIn Learning subscription
Duration
12 hrs
Level
Intermediate
Certificate
Course Certificate
View course →
Prices & availability can change — confirm on the provider's site. We're not affiliated with any single provider.

About this course

Excel PivotTables: Mastering PivotTables and PivotCharts turns raw rows into insight fast. Over about four hours you learn to prepare data, build and format PivotTables, filter, sort and group, add calculated values, and create PivotCharts and interactive dashboards — using real-world examples throughout.

Browse all Data Science courses Browse all LinkedIn Learning courses

Instructor

CD
Chris Dutton
LinkedIn Learning instructor

Taught by Chris Dutton, founder of Maven Analytics and a top-rated Excel and analytics instructor known for practical, project-based courses.

Frequently asked questions

Yes, some. PivotTables are an intermediate Excel feature, so you should already be comfortable with spreadsheets — entering data, basic formulas, and formatting — before starting. It is not an Excel-from-scratch course. If the basics are new, do a foundational Excel course first; with them in place, this teaches you to summarise and analyse data powerfully with PivotTables.

Because they are one of Excel's most powerful features for analysis — they let you summarise, group, and explore large datasets in seconds without writing formulas, turning raw data into insights quickly. For anyone working with data in Excel, PivotTable skill is genuinely high-value and widely expected in analyst and business roles, which is why mastering them is worth a dedicated course.

Yes. As the title indicates, it covers both PivotTables and PivotCharts — the charting counterpart that visualises PivotTable data interactively. So you learn not just to summarise data in tables but to present it visually and dynamically, which together form Excel's core toolkit for exploring and communicating data analysis.

Not by default — it runs on LinkedIn Learning, which is subscription-based — but a free trial is common, and many public libraries and universities give members full access at no cost. Check whether a library card or an institution you belong to already provides LinkedIn Learning before paying, since that quietly unlocks this course and the whole catalogue.

Yes, you earn a LinkedIn Learning completion certificate for your profile. Treat it as a signal of professional development rather than a formal qualification — Excel skill is shown by what you can actually do with data. The real value is genuine PivotTable and PivotChart proficiency, which shows up in your analysis work far more than the certificate.
Paid
LinkedIn Learning subscription
Enroll now