Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 25 of 30 · 270 articles

FILTER Function
In this guide, we’re going to show you how to use the Excel FILTER function and also go over some tips and error handling methods.

SORT Function
In this guide, we’re going to show you how to use the SORT function and also go over some tips and error handling methods.

UNIQUE Function
In this guide, we’re going to show you how to use the Excel UNIQUE function and also go over some tips and error handling methods.

Function: INDEX
In this guide, we’re going to show you how to use the Excel INDEX function and also go over some tips and error handling methods.

IFS Function in Excel
In this guide, we’re going to show you how to use the function (Excel If Statement) and also go over some tips and error handling methods.

Excel SWITCH Function
In this guide, we’re going to show you how to use the Excel SWITCH function and also go over some tips and error handling methods.

Function: MIRR
In this guide, we’re going to show you how to use the MIRR Excel function and also go over some tips and error handling methods.

Function: IRR in Excel
In this guide, we’re going to show you how to use the IRR Excel function and also go over some tips and error handling methods.

Function: XNPV
In this guide, we’re going to show you how to use the XNPV function and also go over some tips and error handling methods.
