Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 1 of 60 · 540 articles
Modulo Operation in Excel: Getting the Remainder of the Division
In this guide, we’re going to show you how to get division remainders from a division operation in Excel by using the MOD function.
Linear Regression in Excel
Site title: In this guide, we will show you how to do linear regression in Excel by using trendlines on scatter charts.
Using VBA SpecialCells as an Excel Formula Checker
Finding cells with errors can be tricky. Let us show you how to display cell formulas in Excel that contain errors using VBA SpecialCells.
Use Day Info from Excel Date Data
SpreadsheetWeb • Use Day Info from Excel Date Data In this article, you will learn to add or subtract days using simple formulas.
CLEAN Function in Excel
In this guide, we’re going to show you how to use the Excel CLEAN function and also go over some tips and error handling methods.
How to Prevent Duplicate Data Entry in Excel
How to Prevent Duplicate Data Entry in Excel. We are going to show how to combine COUNTIF function with Data Validation feature.
How to find the nth root of a number using POWER Formula in Excel
SpreadsheetWeb • In this article, you will learn how to find the nth root of a number using the Excel POWER formula.
Nested IF Functions in Excel
This article will guide you through constructing a nested IF function and discuss alternative methods to using nested statements.
Add Excel Comments and How to Highlight Them Using VBA?
Finding comments inside a workbook can be challenging if you don't know where to look. Let's show you how to highlight Excel comments.