Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 22 of 30 · 270 articles
Function: TRUNC
In this guide, we’re going to show you how to use the Excel TRUNC function and also go over some tips and error handling methods.
How to get top values from a list or a table in Excel
In this article, we are going to show you how to get top values from a list or a table in Excel with using new SORT and SEQUENCE formulas.
Function: TRANSPOSE
In this guide, we’re going to show you how to use TRANSPOSE Excel function and also go over some tips and error handling methods.
Function: CONCATENATE
In this guide, we’re going to show you how to use the CONCATENATE Excel function and also go over some tips and error handling methods.
Function: TEXTJOIN
In this guide, we’re going to show you how to use the TEXTJOIN Excel function and also throw in some tips and error handling methods.
Excel Function: SUBSTITUTE
In this guide, we’re going to show you how to use the Excel SUBSTITUTE function and also go over some tips and error handling methods.
How to Use Excel SMALL Function
In this guide, we’re going to show you how to use the Excel SMALL function and also go over some tips and error handling methods.
How to filter by using a formula in Excel
In this guide, we’re going to show you how to filter by using a formula in Excel.
Excel TRIM Function
In this guide, we’re going to show you how to use the Excel TRIM function and also go over some tips and error handling methods.