The Financial Analyst's Complete Guide to Excel

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

4.52 (241 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
The Financial Analyst's Complete Guide to Excel
1,083
students
4 hours
content
Mar 2024
last update
$64.99
regular price

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!  

Screenshots

The Financial Analyst's Complete Guide to Excel - Screenshot_01The Financial Analyst's Complete Guide to Excel - Screenshot_02The Financial Analyst's Complete Guide to Excel - Screenshot_03The Financial Analyst's Complete Guide to Excel - Screenshot_04

Reviews

Shanda
March 23, 2023
This course was exactly what I was looking for! Philip takes his time and goes through everything so thoroughly, showing exactly how to master each skill as you go! I love that the course is divided into so many sections and sub-sections for easy refreshers or to review or go over sections that I need to work on! I highly recommend diving in!
Ouattara
March 8, 2023
For me the quality of these courses is amazing. It’s really easy to understand the courses and the explanation is clear.
Maha
February 14, 2023
Thank u so much for this course it`s really helpful i was very bad in excel and i improved it`s good content and straight forward looking for your next excel courses .
Anekant
February 4, 2023
I really learnt new ways of handling data on excel. I am going to be more efficient in my work from now on and for that i would like thank Mr Philip for uploading this. The course is amazing :)
Preethi
February 2, 2023
yes it was definitely a good course to learn and I will definitely inculcate at my work place, but ifs statement a slower way as is little confusing so can u make me understand in
Roham
December 26, 2022
So far this course is amazing! very well presented material, recommended to everyone in the Finance Industry
Vineeth
November 10, 2022
Calling it a complete guide is too far fetched. The course doesnt really talk much about finacial formulas, In some modules he only talked about the very basics. It is a good course for begineers
Mohammad
August 8, 2022
Perfect course for people who are interested in the field of finance. The instructor explains the topics in an excellent manner. Definitely recommended.
Ziulyn
July 26, 2022
Excellent course!! Philip Handke delivers short, simple, easy to follow digestible bites that will increase your excel knowledge.
John
April 26, 2022
As far as a 10,000 foot overview I don’t think it could get much better. Nesting IF statements, keyboard shortcuts, index match match, and the data analysis tools section were all great refreshers. I would recommend this excel crash course to any finance professional especially in areas where financial modeling is required.
Tom
April 12, 2022
This is an excellent course and is taught very clearly. I would recommend it for new users as well as users who first learned Excel many years ago as some of the tools discussed in this course were added to Excel in just the past few years.
Justin
March 15, 2022
The lessons in this series are easy to follow and very applicable for finance professionals. Definitely useful if you are looking to become more efficient and useful to your organization
Carl
March 12, 2022
Great videos and explanations. I’m excited to learn some new functions and about the data analysis tools.
Jenny
March 9, 2022
This class has helped me drop all the mouse moving and clicking. I’m now a keyboard only excel user and my efficiency has gone way up. Thanks Phil!
Anna
March 6, 2022
Great course, exceptional instructor! Love the real world examples. I now feel more confident in my excel skills and can’t wait to put them to use at work.

Charts

Price

The Financial Analyst's Complete Guide to Excel - Price chart

Rating

The Financial Analyst's Complete Guide to Excel - Ratings chart

Enrollment distribution

The Financial Analyst's Complete Guide to Excel - Distribution chart
4245800
udemy ID
8/16/2021
course created date
3/6/2022
course indexed date
Bot
course submited by