Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 3 of 30 · 270 articles

Excel CHAR Formula
In this guide, we’re going to show you how to use Excel CHAR function and also throw in some tips and error handling methods.

XOR Function in Excel
In this guide, we’re going to show you how to use the XOR function and also go over some tips and error handling methods.

Excel Text Functions: REPT
In this guide, we will show you how to use the REPT function - a text function- and also go over some tips and error-handling methods.

Excel DATEVALUE Function
In this guide, we’re going to show you how to use the Excel DATEVALUE function and also go over some tips and error handling methods.

ABS Function in Excel
In this guide, we’re going to show you how to use the absolute value function (ABS Function) with some tips and error handling methods.

Count Blank Cells in Excel using COUNTBLANK Function
In this guide, we’re going to show you how to use the Excel COUNTBLANK function and also go over some tips and error handling methods.
10 Most Useful Formulas in Financial Modeling
Financial Modeling in Excel is not that hard if you know these functions. In this article, we will learn how to use them.
Excel Floating Points Calculation Issues
In this article, you will learn about what is the concept of floating points in Excel and their calculation issues.
Calculate Your Loan Payments In No Time With Excel's PMT Function
SpreadsheetWeb • In this article, you will learn how to calculate your loan payments with Excel PMT Function •.
