Excel resources

Excel Formulas

Articles, examples, and practical guidance from the SpreadsheetWeb team.

Page 3 of 30 · 270 articles

excel char
Ilker · Jan 16, 2024

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-1
Ilker · Jan 16, 2024

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.

rept
Ilker · Jan 15, 2024

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.

Function: DATEVALUE
Ilker · Jan 15, 2024

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.

absolute value function
Ilker · Jan 15, 2024

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.

countblank
Ilker · Jan 15, 2024

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.

Adam · Jan 12, 2024

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.

Adam · Jan 12, 2024

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.

Adam · Jan 12, 2024

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 •.