SpreadsheetWeb blog
Practical thinking for spreadsheet-powered teams
Deep guides on Excel, Google Sheets, web applications, product workflows, and the quiet technical traps worth knowing about.
Page 7 of 55 · 1312 articles
Excel FV Function
In this guide, we’re going to show you how to use the Excel FV function and also go over some tips and error handling methods.
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.
Common Formula Errors in Excel and How to Fix Them
We’ve prepared this guide to help you understand how formula errors are handled in Excel and suggest solutions to fix them.
Nested IF Functions in Excel
This article will guide you through constructing a nested IF function and discuss alternative methods to using nested statements.
Excel TIME Function
In this guide, we’re going to show you how to use the Excel TIME function and also go over some tips and error handling methods.
How to Sum Data by Date without Pivot Table
how to sum data by date using SUMPRODUCT function and without pivot table.
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.
Using Excel INDIRECT and ISREF Functions for Worksheet Verification
Learn how to use the Excel INDIRECT and ISREF Functions for Worksheet Verification to find out whether a worksheet exists.
How to Create a Macro in Excel
Macros are great for automating most repetitive tasks. In this article, we are going to show you how to create a macro in Excel.
How to split cells in Excel Using Text to Column
The whole point behind using spreadsheets is to be able to manipulate and analyze data easily. Let us show you how to split cells in Excel.
Insert Image in Excel
SpreadsheetWeb • Insert Image in Excel In this guide, we will show you how to insert an image into a cell in Excel.
Hidden Commands in Excel: Quick Access Toolbar
In this article, we are going to show you how to add hidden commands that you can add Quick Access Toolbar in Excel.
Excel Variance Function: VAR
In this guide, we explore the Excel variance formula in Excel, a fundamental tool for statistical analysis that calculates the variance of a given sample.
FORMULATEXT Function in Excel
In this guide, we’re going to show you how to use FORMULATEXT function and also throw in some tips and error handling methods.
How to calculate Option Pricing using Monte Carlo Simulation in Excel
In this guide, we're going to show you how to calculate Option Pricing using Monte Carlo Simulation in Excel.
String Searching with Search and Find Functions in Excel
SpreadsheetWeb SEARCH and FIND in Excel is a formula version of the same feature with the same name and can work wonders in large data sets.
How to Sort a Table in Excel
An Excel Table provides the data in a special structure. In this guide, we’re going to show you how to sort tables in Excel.
Excel NOT Function
We’re going to show you how to use the Excel NOT function and also go over some tips and error handling methods.
Present Value Formula in Excel: PV Function
In this guide, we’re going to show you how to use the Excel's present value formula and go over some tips and error handling methods.
How to Create a Time Calculator in Excel
SpreadsheetWeb • In this article, we will show you how to calculate shift time calculator in Excel using IF function.
Tax Calculations in Excel Using SUMPRODUCT Function
In this guide, you will learn how to do tax calculations in Excel using SUMPRODUCT function.
How to calculate percentage in Excel
In this article, we’re going to show you how to calculate percentage in Excel with samples and also go over some tips and examples.
Add a New Line in Excel Cell
SpreadsheetWeb • Excel Tips & Tricks In this guide, you will learn how to add a new line in Excel cell just in minutes.
How to Add Header and Footer in Excel
In this guide, we’re going to show you how to add header and footer in Excel with screenshots and examples.