Mastering the CPA Exam Spreadsheet

Only noobs use the basic calculator and scratch paper provided by Prometric. But you? You're smart. You're about to complete my quick and free spreadsheet course which will tell you the secrets of how to use the AICPA Spreadsheet! I'll share with you how it looks, what formulas I recommend remembering, and how to use Excel in general. Don't go sharing this knowledge with your coworkers though, because then you'll be known as the "Excel Guru" and your entire career will consist of "how do I do this in excel?" Don't be a noob. Take this course. It's free! By the way, I'm constantly adding more topics and videos into this course as I come across charts, formulas, and better methods to use on the CPA exam!

What do you have to lose? It's a free course.

See why some are swearing by Pass with Jack to pass their exam.

Enroll for FREE now!

Curriculum

5 Chapters · 12 Lessons

1
The intro
1. (Included in full purchase)
  Basics of the Spreadsheet
2
Spreadsheet Charts
1. (Included in full purchase)
  Download the Charts (Updated: 07/20/25)
2. (Included in full purchase)
  Bonds
3. (Included in full purchase)
  Leases
4. (Included in full purchase)
  Dollar Value LIFO
5. (Included in full purchase)
  Weighted-Average Common Stock Outstanding (WACSO)
3
Formulas to Know
1. (Included in full purchase)
  Present Value Formula (Part 1)
2. (Included in full purchase)
  Present Value Formula (Part 2)
3. (Included in full purchase)
  PV Formula Warning
4. (Included in full purchase)
  Depreciation Formulas
4
Calculations of Certain Topics
1. (Included in full purchase)
  Construction Contracts - Percentage of Completion
5
Course Feedback
1. (Included in full purchase)
  Course Survey

You're on the right track to Pass with Jack!

What do you have to lose? It's a free course.

Curriculum

The intro

Spreadsheet Charts

Formulas to Know

Calculations of Certain Topics

Course Feedback