
Self Study Excel
Excel best practices, tips, functions and formulas
Excel Modeling Best Practices
It is a good idea to follow best practices when modeling in Excel, as it will help you build your model quickly, accurately, and reliably. You might have heard some of them before. In this article, we will explore these best practices so that you can make sure to avoid common pitfalls when building your model!
Index Match Formula
Index and Match are two of the most popular functions used in Excel. However, they can be combined together to form a tool that is more powerful than VLOOKUP and HLOOKUP in Excel. You might wonder what is the need for the Index Match formula when the same results could be achieved with VLOOKUP or an HLOOKUP formula. This article will empower you to use the best tool known to Excel users.
Advanced Excel Formulas
Based on many years of experience, we have compiled the ten most important and advanced Excel formulas that every world-class financial analyst must know. Not only can these functions help shave minutes off your work, but they also allow the overall Excel worksheet to be more fleshed out and connected. While it may not sound like much, these minutes can eventually add up to hours of saved work.
Group in Excel
Ever worked on a cluttered spreadsheet, spending the whole night figuring out why your calculations are off, only to realize that some of the rows had been hidden and not updated? Some of us have. In this article, we briefly talk about why hide should never be used, at least not in financial modeling, before going on to talk about the powerful Group function.
All Excel Self-Study Learning Resources:
- #REF Excel
- Add Months to Date
- Advanced Excel Formulas
- Alphabetize in Excel
- Autosum
- AVERAGEIF Function
- Best Excel Courses
- COLUMN Function in Excel
- Developer Tab
- Documenting Excel Models
- Documenting Excel Models Best Practices
- Excel Modeling Best Practices
- Excel Pivot Table Guide
- Excel Solver
- Excel Shortcuts
- Excel Shortcuts Overview
- Football Field Graphs
- GEOMEAN Function
- Group in Excel
- Histogram
- HLOOKUP Function
- IF Statement Between Two Numbers
- IFS Function
- Index Match Formula
- MOD Function
- REPLACE Function
- Scatter Plot
- Slicer in Excel
- Types of Graphs
- VBA For Loop
- VBA If Else
- VLOOKUP

Sign Up for our Free Excel Modeling Crash Course
Begin your journey into Excel modeling with our free Excel Modeling Crash Course.
or Want to Sign up with your social account?