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 · 1312 articles
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.
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 •.
Unique Values in Excel and How to Find Them?
With unique values in Excel, you can automate tasks such as finding the outliers in your data. Here, we will show you how to find them.
How to Compare Loans with Different Durations in Excel
In this article, we're going to show you how to compare loans with different durations in Excel with PMT function.
How to Convert Excel Columns to Rows - Unpivoting
This article explains how to convert Excel columns to rows, also knows us unpivoting, using VLOOKUP formula.
How to Print Headings in Excel
In this article, we are going to show you how to print headings in Excel 2016, Excel 2013, Excel 2010 and Excel 2007.
Dynamic Arrays Functions in Excel
SpreadsheetWeb • Learn the dynamic array functions in Excel of populating a range of cells with values of an array.