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 8 of 55 · 1319 articles
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.
Hide Scroll Bar in Excel
SpreadsheetWeb • In this guide, we’re going to show you how to Hide Scroll Bar in Excel and how to unhide it.
Excel Workday Function
We’re going to show you how to use the Excel WORKDAY function and also go over some tips and error handling methods.
Excel RATE Function
In this guide, we’re going to show you how to use the Excel RATE function and also go over some tips and error handling methods.
LAMBDA Function in Excel
In this guide, we’re going to show you how to use the LAMBDA function in Excel and also go over some tips and error handling methods.
COLUMN Function in Excel
In this guide, we’re going to show you how to use the COLUMN Function in Excel and also go over some tips and error handling methods.
IFERROR Function in Excel
In this guide, we’re going to show you how to use the IFERROR function and also go over some tips and error handling methods.
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.
How to lock cells in Excel
In this article, we’re going to show you how to lock cells in Excel to protect them and prevent other users from editing.
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.
How to Generate Diceware Passwords in Excel
In this guide, we're going to show you how to generate Diceware passwords in Excel. The Diceware method is a password generation method.
How to hide formulas in Excel using the Number Formatting feature
You can number formatting to hide the value of a cell without changing it. Let us show you how to hide formulas in Excel using formatting.
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.
Highlighting the Top Values with the LARGE Function in Excel
In this article, you will learn how to use the LARGE function in Excel to highlight the top values on a data set.
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.