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 13 of 55 · 1312 articles
How to Find Errors in Excel List?
This article shows how to find errors in an excel list using ISERROR and MATCH functions in an array formula.
Excel Statistics: ERFC Function and How to Use it
In this guide, we’re going to show you how to use the ERFC function and also go over some tips and error handling methods.
How to Calculate Sum in Excel with intersecting tables
This article shows how to calculate sum with intersecting tables using SUM function and intersect operator, the space character (" ").
15 Must Know Excel Functions
SpreadsheetWeb • Keep expanding your knowledge and practice with 15 must-know Excel functions to master spreadsheets.
An Excel Statistics Function: ERFC.PRECISE
In this guide, we will show you how to use the ERFC.PRECISE (ERFC PRECISE) function in Excel statistical analysis.
How to compare two columns in Excel using VBA
Comparing columns of data manually can be tedious when working with large data. Let's show you how to compare two columns in Excel using VBA.
Excel Formulas for Beginners
Formulas are the backbone of Excel. Knowing how to use them effectively means that you’re going to be able to quickly analyze data and make sense of it.
"@" Excel Operator: Bridging the Gap Between Dynamic Arrays and Legacy Formulas
Discover the latest in Excel innovation with Microsoft's introduction of the SINGLE function and the new @ operator—an excel operator designed for backward compatibility.
How to Use COUNTIF to Count the Number of Cells by an Equal Criteria
In this article, we will show you how to count the number of cells by an equal criteria with COUNTIF and COUNTIFS.
Proper Function in Excel
In this guide, we’re going to show you how to use the PROPER function and also go over some tips and error handling methods.
Highlight duplicate values in a data set dynamically with COUNTIF
In this post, we will show how to highlight duplicate values in a data set dynamically with COUNTIF in Excel.
How to Use Excel Round Function
In this guide, we’re going to show you how to use the ROUND function and also throw in some tips and error handling methods.
How to Calculate Tax Rate with VLOOKUP
The tax brackets can be confusing to work with. Different ‘levels’ of your income needs to be multiplied with a different percentage to find the total.
10 Excel Tricks to Increase Productivity in Excel
In this guide, we’re going to show you 10 tips to increase your productivity and effieciency on Microsoft Excel spreadsheets.
How to Fix a Formula in Excel
In this guide, we cover recommended methods for creating formulas, and how to handle errors, should you encounter them when using Excel.
How to VLOOKUP in Excel: A Step by Step Guide to Searching for Data in Excel
VLOOKUP allows you to identify and index information extremely easy and, contrary to popular belief, is not hard to implement.
MIN function in Excel
In this guide, we’re going to show you how to use the Excel MIN function and also go over some tips and error handling methods.
How to Calculate Totals in Excel
Excel Tips & Tricks • This article shows how to calculate totals in Excel.
How to Remove Duplicates in Excel
This article shows to remove duplicates in Excel by using Remove Duplicates feature under DATA tab of Excel.
How to Create a Hyperlink to the Current Workbook Folder in Excel
In this article, we are going to show you how to create a hyperlink to the current workbook folder in Excel.
Basic Excel Financial Formulas to Do Your Personal Finances
We’ve compiled a list of basic Excel financial formulas that are useful when doing personal finances in Excel. Click to learn now!
Developing Applications with Tabular Data
Working with tables on web applications can be far more challenging than it is in Excel, the primary reason being the lack of real estate.
Merge Two Columns in Excel
Traditional Copy+Paste might do all you want, but when working with large tables that are constantly updated, it's a tedious task to merge multiple columns of data. Using this formula combination instead will save you time and prevent errors.
How to Add Double Quotes in Excel
Excel uses double-quote characters to identify text. Add double quotes in Excel in two ways: with and without a function.