Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 2 of 30 · 270 articles
FORMULATEXT Function in Excel
In this guide, we’re going to show you how to use FORMULATEXT function and also throw in some tips and error handling methods.
Excel NOT Function
We’re going to show you how to use the Excel NOT function and also go over some tips and error handling methods.
Present Value Formula in Excel: PV Function
In this guide, we’re going to show you how to use the Excel's present value formula and go over some tips and error handling methods.
Tax Calculations in Excel Using SUMPRODUCT Function
In this guide, you will learn how to do tax calculations in Excel using SUMPRODUCT function.
Excel Workday Function
We’re going to show you how to use the Excel WORKDAY function and also go over some tips and error handling methods.
Excel RATE Function
In this guide, we’re going to show you how to use the Excel RATE function and also go over some tips and error handling methods.
LAMBDA Function in Excel
In this guide, we’re going to show you how to use the LAMBDA function in Excel and also go over some tips and error handling methods.
COLUMN Function in Excel
In this guide, we’re going to show you how to use the COLUMN Function in Excel and also go over some tips and error handling methods.
IFERROR Function in Excel
In this guide, we’re going to show you how to use the IFERROR function and also go over some tips and error handling methods.