Excel resources

Excel Formulas

Articles, examples, and practical guidance from the SpreadsheetWeb team.

Page 25 of 30 · 270 articles

Excel FILTER formula
Ilker · Feb 18, 2019

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
Ilker · Feb 15, 2019

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
Ilker · Feb 14, 2019

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
Ilker · Feb 12, 2019

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
Ilker · Feb 5, 2019

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.

SWITCH
Ilker · Feb 5, 2019

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.

mirr excel
Ilker · Jan 30, 2019

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
Ilker · Jan 30, 2019

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.

XNPV Function
Ilker · Jan 29, 2019

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.