Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 13 of 30 · 270 articles
Function: HEX2DEC
In this guide, we’re going to show you how to use the HEX2DEC function and also go over some tips and error handling methods.
Function: CELL
In this guide, we’re going to show you how to use the CELL function and also go over some tips and error handling methods.
Function: YEARFRAC
In this guide, we’re going to show you how to use the YEARFRAC function and also go over some tips and error handling methods.
How to select a random item from a list in Excel
In this article, we are going to show you how to select a random Item from a list in Excel in two ways with examples.
STANDARDIZE Function
In this guide, we’re going to show you how to use the STANDARDIZE Excel function and also go over some tips and error handling methods.
RANK.AVG (RANK AVG) Function in Excel
In this guide, we’re going to show you how to use the RANK.AVG (RANK AVG) function and also go over some tips and error handling methods.
RANK EQ Excel Function (RANK.EQ)
In this guide, we’re going to show you how to use the RANK.EQ (RANK EQ Excel) function and also go over some tips and error handling methods.
AVERAGEA in Excel
In this guide, we’re going to show you how to use AVERAGEA in Excel and also go over some tips and error handling methods.
Excel SIGN Function
In this guide, we’re going to show you how to use the Excel SIGN function and also go over some tips and error handling methods.