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 10 of 55 · 1312 articles
How to Use FORECAST Function in Excel with Formula Examples
In this guide, we’re going to show you how to use the FORECAST function and go over some tips and error handling methods.
LEN Function to Count Characters in Excel
In this guide, we’re going to show you how to use the Excel LEN function and also go over some tips and error handling methods.
Distinguish Between Odd and Even Numbers Using ISODD Function in Excel
In this guide, we’re going to show you how to use the ISODD function to distinguish between odd and even numbers in Excel.
How to Use ISNUMBER Function in Excel
In this guide, we’re going to show you how to use the Excel ISNUMBER function and also go over some tips and error handling methods.
Count Non-blank Cells in Excel Using COUNTA Function
In this guide, we’re going to show you how to use the Excel COUNTA function and also go over some tips and error handling methods.
How to Use the ISNONTEXT Function in Microsoft Excel
In this guide, we’re going to show you how to use the Excel ISNONTEXT function and also go over some tips and error handling methods.
Excel Forms: A VBA-Free Approach to Data Entry
In this guide, we’re going to show you how to enter data by using Excel Forms. You can use Forms to enter data without any knowledge in VBA.
How to Use Excel Sparklines for Better Looking Tables
Excel sparklines are the perfect tool for visualizing tabular data with the idea of placing the visualizations ‘in-line with other data’.
Scatter Chart in Excel
A scatter chart is a graphic representation of data by placing a collection of points on Cartesian Coordinates.
Basics of Financial Modeling in Excel
This article outlines the basic principles of financial modeling in Excel. Following these principles will ensure that your financial model is easier to maintain and will ultimately reduce the potential for errors.
Using the NOW Function in Excel to Display Current Date and Time
In this guide, we’re going to show you how to use the NOW function in Excel and also throw in some tips and error handling methods.
INDEX-MATCH Combination and Multi-Dimensional Excel Lookups
In this article, we're going to show you how to do a multi-level Excel lookup using INDEX and MATCH functions.
ROW Function in Excel
In this guide, we’re going to show you how to use the ROW function and also go over some tips and error handling methods.
How to Calculate MEDIAN Function in Excel with Formula Examples
In this guide, we’re going to show you how to use the MEDIAN Excel function and also go over some tips and error handling methods.
How to sum by week number
To sum by week number is a bit different than How to sum by month. Instead of finding start and end dates of date range, we focus on exact week number by using WEEKNUM function.
Easily Count Characters in Excel Spreadsheets with the LEN Function
To count the characters in a cell, you can employ the LEN function, a straightforward handy function in various Excel tasks.
ISBLANK Function in Excel
In this guide, we’re going to show you how to use the Excel ISBLANK function and also go over some tips and error handling methods.
How to shorten VBA code in Excel
In this guide, we're going to show you how to shorten VBA code in Excel. Shorter codes are easy to write and read.
How to customize AutoCorrect
Autocorrect can also sometimes do things in a way that doesn't fit your needs. Fortunately, Excel autocorrect rules can be customized!
How to Use SUMIFS Function in Excel with Formula Examples
In this guide, we’re going to show you how to use the SUMIFS function in Excel and also throw in some tips and error handling methods.
COUNTIFS Function in Excel
In this guide, we’re going to show you how to use the COUNTIFS function and also throw in some tips and error handling methods.
SUMIF Function in Excel
In this guide, we’re going to show you how to use the SUMIF function and also go over some tips and error handling methods.
How to highlight quartiles in Excel
In this article, we will explain how to find quartiles in Excel and highlight them dynamically with conditional formatting.
How to make Excel turn off sounds
Do you find Excel's "ding" frustrating? Worry not! In this guide, we're going to show you how to make turn off sounds in Excel.