The Top 100+ Excel Shortcuts for Both Windows and Mac
Get the Shortcuts "Cheat Sheet" →
Free Course: Excel for Mac Users
Watch Free Course →
XLOOKUP in Excel
5-Min Read →
Scenario Analysis: Integrating Operating Cases (OFFSET / MATCH)
Watch Free Lessons (2-Part) →
Write Your First Excel VBA Macro From Scratch
Watch Free Course →
Master Excel: Become an Excel Power User
View Course →
Explore
All Excel Content
-
Adjust Column Width in Excel
Adjust Column Width in ExcelHow to Adjust Column Width in Excel The following tutorial demonstrates the process of how to adjust the column width in Excel using keyboard shortcuts. Adjusting the column width in a financial model...
-
Center Across Selection in Excel
Center Across Selection in ExcelWhat is Center Across Selection? The Center Across Selection feature in Excel aligns text horizontally across multiple columns, without the need to merge cells.
-
CHOOSE Function
CHOOSE FunctionWhat is the Excel CHOOSE Function? The CHOOSE Function in Excel returns the value of a cell based on a specified position and range.
-
COUNTA Function
COUNTA FunctionWhat is the Excel COUNTA Function? The COUNTA Function in Excel counts the number of cells that are not blank, such as those containing numbers, text, dates, and other values.
-
COUNTIF Function
COUNTIF FunctionWhat is the Excel COUNTIF Function? The COUNTIF Function in Excel counts the number of cells that meet a specified criteria, i.e. a condition.
-
COUNTIFS Function
COUNTIFS FunctionWhat is the Excel COUNTIFS Function? The COUNTIFS Function in Excel counts the total number of cells that meets multiple, rather than one, criteria.
-
EDATE Function
EDATE FunctionWhat is the EDATE Function in Excel? The EDATE Function in Excel returns the end date given a specified number of months before or after a provided start date.
-
EOMONTH Function
EOMONTH FunctionWhat is the Excel EOMONTH Function? The EOMONTH Function in Excel returns the final calendar date of a month based on a specified date and a set monthly time interval.
-
Excel Drop-Down List
Excel Drop-Down ListWhat is the Excel Drop-Down List? The Excel Drop-Down List provides the user with a predefined set of options to select from, rather than via manual data entry.
-
Excel IFS Function
Excel IFS FunctionIn the video below, we will introduce you to the Excel 2016 IFS function - an exciting new features that makes writing nested IF statements much more efficient. Click here to download the Excel file u...
-
Excel LAMBDA Function
Excel LAMBDA FunctionWhat is so great about the Excel LAMBDA function? Microsoft announced the launch of the LAMBDA on December 3, 2020 and it is probably safe to say we've never seen this much excitement from the Excel M...
-
Excel Shortcuts “Cheat Sheet”
Excel Shortcuts “Cheat Sheet”Financial Modeling Keyboard Shortcuts in Excel Excel shortcuts are a fundamental component of efficient financial modeling. Quite simply, it's well worth the time to learn them. Here, Wall Street Prep...
-
FV Function
FV FunctionWhat is FV Function in Excel? The FV Function in Excel returns the future value of an investment based on a constant interest rate, i.e. the rate of return.
-
Goal Seek Function
Goal Seek FunctionWhat is the Goal Seek Function in Excel? The Goal Seek Function in Excel is a built-in feature that back-solves the value of an input to arrive at a pre-defined result.
-
Highlight Duplicate Values in Excel
Highlight Duplicate Values in ExcelHow to Highlight Duplicate Values in Excel The following tutorial demonstrates the process of how to highlight duplicate values in Excel using the built-in conditional formatting feature. This automat...
-
How to Protect a Worksheet in Excel
How to Protect a Worksheet in ExcelHow to Protect a Worksheet in Excel? The purpose of protecting Excel worksheets is to either prevent unauthorized users from accessing the file or to make only certain sheets/cells editable.
-
IFERROR Function
IFERROR FunctionWhat is the Excel IFERROR Function? The IFERROR Function in Excel is a built-in feature that returns a pre-determined value in the case of a calculation error, rather than an error message.
-
Index & Match
Index & MatchIn a prior post, I discussed scenario analysis using the OFFSET function. Today I would like to introduce you to two useful formulas, the “Index” and “Match” functions, which can actually be combined...
-
IPMT Function
IPMT FunctionWhat is the Excel IPMT Function? The IPMT Function in Excel determines the interest component of a loan payment, assuming a fixed interest rate throughout the borrowing period.
-
Loan Amortization Schedule
Loan Amortization ScheduleWhat is a Loan Amortization Schedule? A Loan Amortization Schedule outlines the interest and principal payments owed on a debt obligation and the outstanding balance remaining over time.
-
Macro Recorder in Excel VBA
Macro Recorder in Excel VBAWhat is Macro Recorder? Macro Recorder records step-by-step macros in Visual Basic for Applications (VBA) code, the underlying language behind Microsoft Office Suite, which includes Excel. If you work...
-
MIRR Function
MIRR FunctionWhat is MIRR? MIRR, or “modified internal rate of return” is an Excel function that accounts for the cost of capital and reinvestment rate of the cash flows from a project or company.
-
Nested (Two-Way) XLOOKUP vs Index Match
Nested (Two-Way) XLOOKUP vs Index MatchTwo-Way Nested XLOOKUP As we've discussed in a prior lesson, XLOOKUP is a game changer - replacing VLOOKUP and HLOOKUP and eliminating many use cases where more complicated INDEX MATCH functions neede...
-
OFFSET MATCH and Data Validation, Part 1
OFFSET MATCH and Data Validation, Part 1In this video, I'll show you how to integrate scenarios into financial models. We'll do this by building a drop down menu in Excel using data validation and connecting the drop down menu to the scenar...
-
OFFSET MATCH and Data Validation, Part 2
OFFSET MATCH and Data Validation, Part 2In this video, I'll show you how to integrate scenarios into financial models. We'll do this by building a drop down menu in Excel using data validation and connecting the drop down menu to the scenar...
-
PMT Function
PMT FunctionWhat is the Excel PMT Function? The PMT Function in Excel calculates the periodic payments owed on a loan, assuming a fixed interest rate.
-
PPMT Function
PPMT FunctionWhat is the Excel PPMT Function? The PPMT Function in Excel returns the periodic principal payments owed on a loan, assuming fixed interest rate pricing and consistent payments.
-
PV Function
PV FunctionWhat is the PV Function in Excel? The PV Function in Excel returns the present value of an investment, such as a loan, assuming a fixed interest rate.
-
RATE Function
RATE FunctionWhat is the Excel RATE Function? The RATE Function in Excel determines the implied interest rate, i.e. rate of return, on an investment across a specified period of time.
-
RIP INDEX MATCH? Example Where XLOOKUP Loses
RIP INDEX MATCH? Example Where XLOOKUP LosesXLOOKUP has been crowned the new king of Excel reference functions, even defeating the mighty index match. But it's not a complete victory. Here is an example of Index Match (more accurately - INDEX X...
-
RRI Function
RRI FunctionWhat is the Excel RRI Function? The RRI Function in Excel returns the equivalent interest rate on an investment, i.e. the annualized rate of return, over a specified time frame.
-
Scenario Analysis
Scenario AnalysisWhat is a Scenario Analysis? We would like to introduce you to an important concept in financial modeling: Scenario Analysis. This key concept takes your financial model to the next level by allowing...
-
Scenario Analysis Using XLOOKUP [VIDEO]
Scenario Analysis Using XLOOKUP [VIDEO]Scenario analysis using XLOOKUP XLOOKUP simplifies building a scenario analysis significantly. Why does this matter? In corporate finance, one of the most common use cases for index match was buildin...
-
Sensitivity Analysis (“What if” Analysis)
Sensitivity Analysis (“What if” Analysis)Sensitivity Analysis: "What if" Analysis A financial model is a great way to assess the performance of a business on both a historical and projected basis. It provides a way for the analyst to organiz...
-
SUMIF Function
SUMIF FunctionWhat is the Excel SUMIF Function? The SUMIF Function in Excel returns the sum of the values in a selected range that meet a specified criterion.
-
SUMIFS Function
SUMIFS FunctionWhat is the SUMIFS Function in Excel? The SUMIFS Function in Excel returns the sum of the values in a selected cell range that meet a specified set of criteria consisting of multiple conditions.
-
SUMPRODUCT Function
SUMPRODUCT FunctionWhat is the Excel SUMPRODUCT Function? The SUMPRODUCT Function in Excel is a two-fold calculation that first calculates the product of two cells in an array, followed by the sum of those values.
-
TODAY Function
TODAY FunctionWhat is the TODAY Function in Excel? The TODAY Function in Excel is a built-in feature that returns the calendar date on the present date.
-
Unhide Columns in Excel
Unhide Columns in ExcelHow to Unhide Columns in Excel The following tutorial demonstrates the step-by-step process of how to unhide columns in Excel using keyboard shortcuts. The option to hide columns is a built-in feature...
-
Using XLOOKUP to Generate Multiple Values
Using XLOOKUP to Generate Multiple ValuesUsing XLOOKUP to Generate Multiple Values Below is a short tutorial on using XLOOKUP to instantly generate multiple values with just 1 formula. Download the Excel file that goes with this lesson below...
-
XIRR Function
XIRR FunctionWhat is the Excel XIRR Function? The XIRR Function in Excel calculates the internal rate of return (IRR) for an irregular series of cash flows, i.e. received on non-periodic dates.
-
XLOOKUP in Excel
XLOOKUP in ExcelXLOOKUP Explained XLOOKUP is a new Excel function announced in 2019 and broadly released in 2020 that significantly improves some of the most common lookup and reference tasks Excel users encounter on...
-
XNPV Function
XNPV FunctionWhat is XNPV Function? The XNPV Function in Excel returns the net present value (NPV) of an investment with cash flows occurring at irregular intervals.
-
YEARFRAC Function
YEARFRAC FunctionWhat is the YEARFRAC Function in Excel? The YEARFRAC Function in Excel measures the fractional years between two specified dates, which is returned in the form of a decimal value.
-
YIELD Function
YIELD FunctionWhat is the Excel YIELD Function? The YIELD Function in Excel calculates the return earned on a security that issues periodic interest payments, such as a bond.