FP&A Excel and Modeling
For FP&A professionals looking to strengthen their Excel and financial modeling skills. Learn to efficiently cut and analyze data in Excel and build an annual software model.
90 mins each
and practice exercises
What you’ll learn
Efficient Excel Analysis
- Review of key Excel formulas via multiple analytical examples
- Data cleanup in Excel
- Comparison of multiple data sets
- P&L summarization
Customer Cohort Analysis
- Summary tables by cohort (from raw order data)
- Relevant retention tables
ARR Bridge Analysis
- ARR bridge from contract level data
- Relevant retention calcs
Software Annual Model Build
- Sources & uses
- Multiple income statement cases
- NWC & PP&E schedules
- Opening balance sheet and goodwill calc
- Return calculations and sensitivities
- Debt schedules
- Back of the envelope math vs compared to a full model
Interested in a future training?
Hands down Katie’s delivery style is just one that I think resonates with just about anybody. I think she has a way of giving real world examples, which is really great because everybody can draw their own experiences and apply it
Recalc training is an innovative and practical way to acquire the skills needed for success in a PE environment. Katie tailored a curriculum for our portfolio company CFOs and they’ve seen immediate benefit.
Highly recommend classes with the Recalc Academy! I have taken several and find each to provide valuable and actionable insights I was immediately able to apply to my day-to-day work life. The extra office hours are such a wonderful perk to get more personalized and one-on-one training.
Frequently asked questions
Everything you need to know about the courses and billing.
-
How do the courses work?
Each course is taught over multiple highly-interactive Zoom-based classes. They are designed so you can follow along in your own spreadsheet and try out what you’re learning during the class. Participants can also attend individual office hours to help connect in-class concepts to their real work.
-
Can I arrange training for my team?
Yes, we primarily offer training for corporate and investment teams. Please contact us at support@recalcacademy.com to discuss and schedule training for your team.
-
I am not part of a team. Can I still join training?
Yes, we offer training for individuals and we always have a few upcoming courses. Please visit our upcoming courses page or contact us at support@recalcacademy.com.
-
I use Google Sheets. Can I still take this training?
Yes! We teach Excel and Google Sheets. And if you feel like you lost efficiency by moving from Excel to Google Sheets, we’re here to help! You’ll learn the shortcuts and formulas to help you save time and learn to love Sheets.
-
I use a Mac. Can I still take this training?
Yes! We teach PC and Mac users.
-
Can you tailor the content to my business?
Yes, we are happy to incorporate your company’s data or other examples that are relevant to your business to make it highly relatable and impactful for your team.
-
How much does training cost?
Please reach out to us at support@recalcacademy.com for more information on courses and pricing.