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
Package
bylearnformula

CERTIFICATE: PivotTables for CPAs

Master PivotTables and Ethical Decision-Making to Enhance Your Excel Reporting and Professional Integrity

checkIncluded with Unlimited Pass — a ready-made path to your 21 CPD hours.
4curated courses
+
21CPD hours
=
1consolidated certificate
·schedule21 CPD hrs·Appropriate for all levels·Published Jun 24, 2025
Most popular package
4 courses bought separately:Original price: CA$919
CA$399
You save CA$520
sellCancel anytime·verified_user10-day money-back

What you will get

  • local_library1-year Unlimited Pass: all CPD courses & packages
  • library_booksThis package: 21 CPD hours, 4 courses
  • verified 1 consolidated certificate for the package
  • bolt Instant access
  • monitoring Built-in credit tracker for your renewal
groups

Team License Available

Train your entire team with volume pricing, centralized billing, and compliance reporting.

Learn about Team License →
4 courses · 21 CPD hours

Package Content

Each course is a standalone module.

NumberCourseHoursCredit Type
017.5 hrs—
021.5 hrs—
038 hrs—
044 hrs—
  1. 01
    MS ExcelAdvanced PivotTablesSimon Sez ITIndividually CA$279
    Hours
    7.5 hrs
    Credit Type
    —
  2. 02
    MS ExcelExcel PivotTables: From Slicers to DashboardsLinda HoskinsIndividually CA$168
    Hours
    1.5 hrs
    Credit Type
    —
  3. 03
    MicrosoftMicrosoft Excel 365 IntermediateSimon Sez ITIndividually CA$299
    Hours
    8 hrs
    Credit Type
    —
  4. 04
    Ethics for AccountantsEthics Stories From the Trenches 2026David TrahairIndividually CA$173
    Hours
    4 hrs
    Credit Type
    —
all_inclusive
Every other course is included with your Unlimited PassNeed extra hours or a different topic? Take any course at no extra cost.
If purchased each course individually: CA$919Package: CA$399You save CA$520

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.

The convenience pitch

What This Package Replaces

You already know what you need to do. The package collapses every step into one purchase.

Without this package

Searching, tracking, filing — 4 times.

  • closeSearch the catalog of 4 courses to find the ones that match your requirements
  • closeBuy 4 separate courses — at CA$919 if you assembled it yourself
  • closeTrack progress across 4 separate enrollments and dashboards
  • closeDownload 4 different certificates and combine them yourself
→
With this package

One purchase. One certificate. Done.

  • checkOne purchase — CA$399 for the whole package
  • checkOne progress tracker for all 4 courses
  • checkOne certificate — covers all 4 courses
  • checkTailored to your professional body's requirements
  • checkNeed more? The entire catalog is already unlocked
About

Description

This certificate program empowers CPAs with the practical skills and ethical insight needed to master Excel PivotTables and apply them effectively in financial reporting, data analysis, and dashboard creation. From intermediate Excel operations to advanced PivotTable customization, learners will gain hands-on experience with slicers, filters, and dashboard tools that streamline and elevate data interpretation. The program also integrates professional ethics, using real-world scenarios to help CPAs navigate complex ethical challenges with integrity and sound judgment. This well-rounded certificate ensures proficiency in data-driven reporting while reinforcing the ethical foundation essential to the accounting profession.

 

Instructors

  • workspace_premiumBest Instructor
    Simon Sez ITSince 2008, we've taught 2 million learners in over 190 countries, with 200+ courses
    151 courses·405 reviews
  • Linda HoskinsProfessional, qualified IT Trainer and Course Developer
    1 course·177 reviews
  • workspace_premiumBest Instructor
    David TrahairAcclaimed Author and On-demand Course Developer
    39 courses·35 reviews
One certificate, all 21 hours

Instant, in the format your professional body expects

Most providers issue you a stack of 4 separate PDFs. We issue one consolidated certificate that lists every topic, hours per topic, and totals — exactly what your professional body needs to file. Per-course certificates are still available if you prefer.

  • checkSingle PDF lists all 4 topics & 21 hours
  • checkVerification ID on every certificate
  • checkCertificates stored for life
×4
Without package
→
CPD certificate
CERTIFICATE: PivotTables for CPAs4 courses · 21 CPD hrs
verified
With this package
From verified package buyers

Real Outcomes from Our Students

  • Earned 21 CPD hours
    Rated 5 out of 5

    “I found this ethics course the best out of all i've taken so far as it was from true stories”

    KM
    Karleen M.
  • Earned 21 CPD hours
    Rated 5 out of 5

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

    GK
    Glenn K.
  • Earned 21 CPD hours
    Rated 5 out of 5

    “Well explained and reasonably entertaining.”

    JC
    Jason C.
  • Earned 21 CPD hours
    Rated 5 out of 5

    “The course topics are very useful, the instructor showed everything very clear and professional. Great job!”

    LW
    Lingyun W.
FAQ

Questions Students Usually Ask

This package is a bundle of pre-selected courses designed to cover specific topics and credit requirements. You can view the full list under the Package Content section on this page, and click on any course to see detailed course information. In addition, you'll receive unlimited access to our entire course library, so you're not limited to just the courses included in the package.

Stop Searching. Get this Package.

21 CPD hours, one certificate, 10-day money-back. Plus a year of unlimited access to all our courses.

  • shield10-day money-back·
  • boltInstant certificate·
  • autorenewCancel anytime