Excel Essentials for Finance Teams
CPE for CPAs: refresh essential Excel techniques for more efficient accounting and finance work.
Practical CPE for accounting professionals
Make everyday spreadsheet work more efficient. This foundational Excel course gives CPAs and accounting teams a focused refresher on the functions, formulas and shortcuts used in routine financial analysis.
What you will work on
- Apply essential mathematical functions and formulas.
- Use keyboard shortcuts to navigate and work more efficiently.
- Practice spreadsheet techniques through guided activities.
- Build a stronger foundation for further Excel-based analysis.
Who this course is for
CPAs and accounting teams seeking a focused refresher in essential spreadsheet skills.
Fit CPE learning around your work
Learn on demand and apply the material through the course activities. Review the CPE program details and completion requirements before enrolling. Credit is earned through successful completion, not purchase alone; acceptance is determined by your state board.
Choose practical CPE you can apply in your next analysis, report or client conversation.
CPE program details
Field of study: Computer Software & Applications — Non-Technical
Program level: Basic
Delivery method: QAS Self Study
Prerequisites: None.
Advance preparation: None. Excel desktop is recommended for hands-on practice.
Credit and completion: 1.4 CPE hours. Complete all required content and reinforcement activities and score at least 70% on the final assessment. A downloadable certificate is issued after successful completion.
Registration and access: Create or sign in to a Pillars account and complete enrollment or purchase. Individual self-study access expires 365 days after enrollment.
Refunds, cancellations, and complaints: Review the Terms & Conditions. Submit program or service complaints through Pillars Support.
Learning objectives
- Configure Excel settings that affect calculation and modeling workflow.
- Navigate workbooks efficiently and create cross-sheet references.
- Select and expand worksheet ranges using keyboard controls.
- Copy, paste, fill, cut, and undo with core modeling shortcuts.
- Use relative, absolute, and mixed references correctly when copying formulas.
- Write basic arithmetic and SUM formulas using Excel operators.
- Build and interpret simple growth and driver relationships.
Pillars of Wall Street LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors (Registry ID 122036). State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website.
Course Overview
See the lessons, assessments, and required evaluation included in this CPE course.
Course content will appear here when available.