Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 9 of 30 · 270 articles
Excel Function: VARPA
In this guide, we’re going to show you how to use the VARPA function and also go over some tips and error handling methods.
INDIRECT Function in Excel
In this guide, we’re going to show you how to use the Excel INDIRECT function and also go over some tips and error handling methods.
How to Unpivot Data with New Excel Functions
Learn how to unpivot Data with New Excel Functions. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
RANDARRAY Function in Excel
In this guide, we’re going to show you how to use the RANDARRAY function and also go over some tips and error handling methods.
Excel TEXTAFTER Function
In this guide, we’re going to show you how to use the TEXTAFTER function and go over some tips and error handling methods.
Excel TEXTBEFORE Function
In this guide, we’re going to show you how to use the TEXTBEFORE function and go over some tips and error handling methods.
Excel TEXTSPLIT Function
In this guide, we’re going to show you how to use the TEXTSPLIT function and go over some tips and error handling methods.
Excel VALUE Function
In this guide, we’re going to show you how to use the VALUE function and go over some tips and error handling methods.
Excel DEGREES Function
In this guide, we’re going to show you how to use the DEGREES function and go over some tips and error handling methods.