The Financial Analyst's Complete Guide to Excel [2023]

The Financial Analyst's Complete Guide to Excel [2023]

What is this class all about?

This is an Excel best practices class that will teach you how a financial analyst uses Excel on a daily basis. My goal is to take you from an ordinary to an extraordinary Excel user! 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 tailored 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!  

Use Excel to advance your career in finance & accounting! Finance functions, financial modeling, analysis, and more!

Url: View Details

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

Rating: 4.52632

Level: All Levels

Duration: 4 hours

Instructor: Philip Handke, CFA | Analyze Finance