![The Financial Analyst's Complete Guide to Excel [2022]](https://www.psdly.site/wp-content/uploads/2022/03/The-Financial-Analysts-Complete-Guide-to-Excel-2022.jpg "The Financial Analyst's Complete Guide to Excel [2022] 1")
What you’ll learn:
Excel techniques and functions used in banking, private equity, real estate & more
Gain EXTREME confidence in your abilities to use Excel to solve financial problems
Learn financial modeling and how to build your own custom financial models from scratch
Build a loan amortization table from scratch. Take this one to the bank!
Advanced search & lookup functions including VLOOKUP, INDEX/MATCH & more
Creating 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!
Requirements:
Excel 2010 or newer
A basic working knowledge of Excel is required.
Basic knowledge of finance is a plus but is not necessary. You will learn a lot about finance in this course.
Description:
What is this class all about?
This class is for those who want to quickly go from ordinary to extraordinary Excel users! This course is packed with functions, techniques, and best practices that will take your Excel abilities to the next level. These materials are tailored towards financial professionals, but anyone looking to improve in Excel can benefit from this course.
