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 9 of 55 · 1312 articles
Effective Rate Calculator
With this template, you can calculate the effective rates annually based on the frequency of compounding, with the data visualized on charts.
INDEX and MATCH: A Better Way to Look Up Data
the powerful combination of INDEX and MATCH functions together provides enhanced flexibility when seeking specific data.
Protect Excel Files: How to Password Protect Spreasdsheets?
Protecting your Excel files is important, there are several reasons why you might want to password protect Excel workbooks.
How to strikethrough in Excel
Learn how to strikethrough in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to find largest value in array using a criteria
This article shows how to find the largest value in an excel array formula using LARGE and IF functions and array formulas.
Calculate Payment on the Principal Using Excel PPMT Function
In this guide, we’re going to show you how to use Excel PPMT function and also go over some tips and error handling methods.
How to Extract First and Last Names in Excel?
In this blog, we'll explore a simple yet effective method to automatically extract first and last names using Excel functions.
Historical Currency Exchange Rate Comparison Template
This historical exchange rates historical lookup template can help you compare and analyze up to 5 currencies side-by-side.
How to Enter in Excel and Change Its Behaviour
In this guide, we're going to show you how to change pressing Enter behavior in Excel. You can move in another direction or even disable it.
How to Sort Numbers by Using Excel Formulas
In this article we will show how to use Excel sort function using SMALL, ROW, SORT, and SORTBY functions.
HLOOKUP in Excel | SpreadsheetWeb
In this guide, we’re going to show you how to use the HLOOKUP function in Excel and also add some tips and error handling methods.
How to Highlight Empty Cells in Excel | SpreadsheetWeb
Highlighting the empty cells can help easily identify the outliers. Find out how to highlight empty cells using Conditional Formatting.
Show Formulas in Excel
In this guide, we're going to show how to find formulas in Excel with Go to Special and Show Formulas features.
Least Useful and Rare Formulas in Excel
Let's have a look at rare and uncommon Excel formulas which are CONCATENATE, ROMAN, BAHTTEXT and GETPIVOTDATA!
How to Spell Check in Excel
In this guide, we’re going to show you how to spell check step by step in Excel and how it differs from spell check in Word or PowerPoint.
Date in Excel: How to Enter Dates Only in the Current Week?
In this article, we are going to show you how to allow users to enter date values only for the current week in Excel.
Excel VLOOKUP Function with Formula Examples
In this guide, we’re going to show you how to use Excel VLOOKUP function and also cover some tips and error handling methods.
Excel HYPERLINK Formula
In this guide, we’re going to show you how to use the Excel HYPERLINK formula and also go over some tips and error handling methods.
Excel Month Function
In this guide, we’re going to show you how to use the Excel MONTH function and go over in some tips and error handling methods.
How to Multiply Numbers Using Excel PRODUCT Function - with Formula Examples
In this guide, we’re going to show you how to use Excel PRODUCT function and also throw in some tips and error handling methods.
FREQUENCY Function in Excel
In this guide, we’re going to show you how to use the FREQUENCY function and also go over some tips and error handling methods.
Insert Symbols in Excel Using UNICHAR Function
In this guide, we’re going to show you how to use insert symbols in Excel using UNICHAR function: check mark, @ symbol.
Excel NETWORKDAYS.INTL Function to Calculate Work Days
In this guide, we’re going to show you Excel NETWORKDAYS.INTL function to find the number of business days between two given dates.
How to Use LOOKUP Function in Excel with Formula Examples
In this guide, we’re going to show you how to use the Excel LOOKUP function and also go over some tips and error handling methods.