Excel Formulas for Financial Work
CPE for CPAs: use Excel formulas to improve financial analysis, reporting and spreadsheet review.
Practical CPE for accounting professionals
Develop more flexible spreadsheet calculations and make their logic easier to follow. This on-demand course focuses on formulas that help CPAs organize data, answer analytical questions and review financial workbooks.
What you will work on
- Apply lookup functions, including INDEX-MATCH and XLOOKUP.
- Use SUMIFS and conditional logic to organize analysis.
- Work with financial, statistical and logical functions.
- Investigate formula errors and review how calculations behave.
Who this course is for
CPAs and accounting professionals who use Excel for recurring analysis and reporting.
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: Advanced
Delivery method: QAS Self Study
Prerequisites: Excel Fundamentals or equivalent proficiency with worksheet navigation and basic formulas.
Advance preparation: None. Excel desktop is required for hands-on practice.
Credit and completion: 5 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
- Construct logical formulas with IF, AND, OR, and IFERROR.
- Build VLOOKUP, HLOOKUP, and XLOOKUP formulas with intentional match behavior.
- Build flexible retrieval and scenario formulas with MATCH, INDEX, OFFSET, and CHOOSE.
- Calculate and interpret descriptive results with core statistical functions.
- Apply conditional aggregation functions with correctly aligned criteria and value ranges.
- Clean, standardize, combine, and format text with Excel text functions.
- Parse variable-length strings with LEFT, RIGHT, MID, LEN, FIND, and CELL.
- Extract, construct, shift, and display dates with Excel date functions.
- Build controlled interactions with Data Tables, Data Validation, conditional formatting, and self-referencing IF statements.
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.