Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 24 of 30 · 270 articles
Function: RAND
In this guide, we’re going to show you how to use the Excel RAND function and also go over some tips and error handling methods.
Function: SUBTOTAL
In this guide, we’re going to show you how to use the Excel SUBTOTAL function and also go over some tips and error handling methods.
Function: COUNT
In this guide, we’re going to show you how to use the COUNT function and also go over some tips and error handling methods.
Function: MINIFS
In this guide, we’re going to show you how to use the Excel MINIFS function and also go over some tips and error handling methods.
Function: MAXIFS
In this guide, we’re going to show you how to use the MAXIFS Excel function and also go over some tips and error handling methods.
Excel UNIQUE Function: Spill Range Operator
The unique function in Excel is a tool for handling dynamic arrays and spill concepts. Also, it introduces the spill range operator(#).
SINGLE Function
In this guide, we’re going to show you how to use the SINGLE function and also go over some tips and error handling methods.
Pivot Table Alternative Using Formulas
In this guide, we’re going to show you how to create data tables using formulas as Pivot Table alternative.
SEQUENCE Function
In this guide, we’re going to show you how to use the SEQUENCE function and also go over some tips and error handling methods.