
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
- % Difference Formula
- Add Months to Date
- Advanced Excel Formulas
- Alphabetize in Excel
- Autosum
- AVERAGEIF Function
- Basic Excel Formulas
- Best Excel Courses
- COLUMN Function in Excel
- Common Excel Confusions
- Convert Time to Seconds in Excel
- Corkscrew Calculation
- Correlation Matrix
- Countif Multiple Criteria
- Count Words in Excel
- Dashboard Creation in Excel
- Data Validation in Excel
- Developer Tab
- Documenting Excel Models
- Documenting Excel Models Best Practices
- Dynamic Dates, Sum, Average and Scenarios
- Dynamic Financial Analysis
- Error Bars in Excel
- Excel Array Formulas
- Excel Convert Formula to Value
- Excel Comments
- Excel Consolidate
- Excel Current Date and Time
- Excel Dashboards
- Excel Definition
- Excel Drop Down List
- Excel for Beginners
- Excel for Finance
- Excel Formulas Cheat Sheet
- Excel IF Statement
- Excel Modeling Best Practices
- Excel Pivot Table Guide
- Excel Round Down
- Excel Solver
- Excel Shortcuts
- Excel Shortcuts Overview
- Excel VBA
- Excel VBA Macros
- Excel VBA Examples
- Find and Replace in Excel
- Flash Fills
- Football Field Graphs
- FORECAST Function
- Formula Vs Function
- GEOMEAN Function
- Go To Special
- Goal Seek Function
- Google Sheets
- Gridlines in Excel
- Group in Excel
- Histogram
- How to Add a VBA Button in Excel?
- How to Expand All Grouped Cells in Microsoft Excel?
- How to make a Graph in Excel?
- How to Reduce Excel File Size
- How to Repeat Previous Command in Excel?
- HLOOKUP Function
- IF Statement Between Two Numbers
- IFS Function
- Index Match Formula
- Insert Today's Date in Excel
- Merge Cells in Excel
- MIRR Guide
- MOD Function
- NOW Function in Excel
- Power Query
- PowerPoint Shortcut Keys
- REPLACE Function
- ROUNDUP Excel
- Sales Tax Decalculator
- Scatter Plot
- Secondary Axis
- Sheet Name Code
- Slicer in Excel
- Tips For Writing VBA in Excel
- Trace Precedents
- Types of Errors in VBA for Excel
- Types of Graphs
- VBA Cell References
- VBA Do Loop
- VBA For Loop
- VBA Glossary
- VBA: How to Debug Code
- VBA If Else
- VBA in Excel
- VBA Loop
- VBA Methods
- VBA Quick Reference
- VBA: Sub Vs. Function
- VBA Variables, Data Types and Dim
- VBA Variable Types
- VBA Workbook Events
- Vertex42® Excel Templates
- VLOOKUP
- Waterfall Charts
- XLOOKUP
- XMATCH
- XNPV Function

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?