The Financial Analyst's Complete Guide to Excel
Use Excel to advance your career in finance & accounting! Finance functions, financial modeling, analysis, and more!
What you will learn
Excel techniques & functions used in banking, private equity, real estate, corporate finance & more
Gain EXTREME confidence in your ability to use Excel to perform financial analysis
Learn the basics of financial modeling and how a financial analyst builds custom models
Build a loan amortization table from scratch. Take this one to the bank!
Advanced search & lookup functions including VLOOKUP, INDEX/MATCH & more
Create macros to automate everyday, mundane tasks
Pivot tables and other data analysis tools
Keyboard shortcuts and keyboard movement
Conditional formatting
Logical operator functions
and more!
Why take this course?
What is this class all about?
Feel more confident and use Excel more efficiently in this comprehensive class designed to take you from ordinary to extraordinary Excel user in just 4 hours! No prior experience needed. Together we'll discuss the functions, techniques, and best practices that will take your Excel abilities and financial analysis to the next level. This course is geared towards financial professionals, but anyone looking to improve in Excel can benefit.
What will I learn?
Whether you're a total rookie or an experienced financial analyst, this class will help you become an Excel expert and will teach you a lot about the industry along the way. With over 50 lectures and over a dozen downloadable resources, you'll learn formulas & techniques that are commonplace in finance, an intro to financial modeling, advanced search & lookup functions, keyboard shortcuts, pivot tables & other data analysis tools, macros, and more. Each lesson contains a real-world, practical exercise to prepare you for the tasks performed by financial analysts. I've also included a keyboard shortcut PDF to print out and keep at your desk!
Why are you qualified to teach me?
I'm a CFA charterholder and have been a financial analyst since 2015. I spend every workday (and some of my weekends :) in Excel and have built dozens of financial models that are used to make daily investment decisions. I currently work at a small business lender and previously worked at a public REIT with some very smart people who were great with Excel and showed me the ropes. I take great pride and enjoyment in teaching, and I've spent a lot of time perfecting these lessons to be easily digested and applied in the real world.
What else can you tell me?
Being proficient with Excel is an essential part of being a good financial analyst and can greatly boost your marketability in this industry. If you aren't truly proficient with Excel, you could be missing out on career and/or advancement opportunities in your field. This class comes with a 30-day money-back guarantee so if you aren't satisfied for any reason, contact me for a refund. It's that easy!