Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
  1. Courses
  2. /Office Productivity
  3. /MS Excel

Excel PivotTables: From Slicers to Dashboards

Turn Raw Data into Insights with Quick, Practical Excel Skills for Professionals.

Created byLinda Hoskins
AdvancedUpdated Jan 22, 2025

What You'll Learn

  • check_circleRecognise the power of Excel PivotTables
  • check_circleUnderstand how to prepare data for a PivotTable
  • check_circleLearn how to create, filter and group data in PivotTables
  • check_circleBe able to analyse PivotTables data using formulas
  • check_circleUse PivotCharts, Slicers and Timelines to graphically illustrate your data
  • check_circleUltimately, present PivotTable data as in interactive Dashboards

About This Course

Master Excel PivotTables, PivotCharts, and Dashboards in Just 1.5 Hours!

Ready to unlock the true power of Excel? This fast-paced, practical course is your gateway to mastering PivotTables, PivotCharts, and Dashboards—even if you only have basic Excel knowledge.

What You'll Learn:

  • PivotTables Made Easy: Quickly summarize, filter, and analyze your data like a pro.
  • Dynamic PivotCharts: Visualize your insights with sleek, interactive charts.
  • Professional Dashboards: Build dashboards that transform raw data into actionable insights.

Course Highlights:

  • Bite-Sized Learning: 14 on-demand video lessons, each just 5 minutes long.
  • Hands-On Practice: Downloadable Excel data files to follow along step-by-step.
  • Guided Support: A PDF with easy-to-follow instructions for every technique.
  • Test Your Skills: Quizzes at the end of each of the 4 sections to check your understanding.

Why Choose This Course?

Your progress is tracked, but you have the freedom to revisit and replay lessons anytime. Whether you're a beginner or just looking to level up your Excel skills, this course will have you creating professional-grade reports and dashboards in no time.

Don’t miss the chance to elevate your Excel game—enroll now and impress with your data-driven decision-making!

Course Content

5 activities • 14 videos • duration: 1h 18m

remove
PivotTable Basics3 videos • 1 quiz • 16 min
  • videocamLesson 1: Creating a PivotTable from an Excel Table
    Duration 5:57
  • videocamLesson 2: Using Slicers to Filter & Updating the PivotTable
    Duration 6:00
  • videocamLesson 3: Grouping & Formatting PivotTable Data
    Duration 4:44
  • quizSection 1: Quiz
add
Calculations4 videos • 1 quiz • 22 min
add
Graphical Side of PivotTables3 videos • 1 quiz • 15 min
add
Dashboards3 videos • 1 quiz • 19 min
add
Bonus Material1 videos • 3 min

Your Instructors

Linda Hoskins

Professional, qualified IT Trainer and Course Developer

menu_book1 courses
star177 reviews

Linda is a versatile and committed IT professional with over 25 years experience of  training  and supporting adult learners. She has developed many successful training programs for a range of organisations, including the Open University, Bedford College, Chamber of Commerce and Knight Frank. Linda has been praised for her open approachable style both in the classroom and when coaching colleagues. She has trained mostly desktop PC products including Microsoft Office and Adobe Captivate, but has also covered various business skills, adult literacy, and personal development subjects.

Linda Hoskins

Professional IT Trainer and Course developer

Linda is a versatile and commited IT professional with over 25 years experience of training and supporting adult learners. etc

Credit Information

Is this course eligible for my CPD requirements as a Canadian CPA?

Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.

Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.

What Students Are Saying

5.0 out of 5
Student's Choice
177 reviews
  • GK
    Glenn K.
    starstarstarstarstar

    Love learning the power of excel. This was a great format to learn the tools to get the most out of pivot tables.

  • MS
    Marcello S.
    starstarstarstarstar

    Great Class

  • CC
    Chin Tung C.
    starstarstarstarstar

    This is a must take course for anyone who works in excel but needs to do presentations.

  • AW
    Ashley Yun-Ching W.
    starstarstarstarstar

    It is an excellent course! Linda explains the steps so clearly, especially the dashboard. I knew Pivot table quite well but I learned a lot about dashboard. I will definitely use it at work this year! Thank you!

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(556 reviews)
    2 CPD hrs
  • Finance: Budgeting & Financial Forecasting

    Critical Skills for CFOs & Controllers: Budgeting & Forecasting Strategies for Today’s World

    starRated5.0out of 5,(113 reviews)
    2.5 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(646 reviews)
    2.5 CPD hrs