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 48 of 55 · 1312 articles
HubSpot Setup - Integrate SpreadsheetWeb applications with HubSpot
Your HubSpot instance can be accessed via RESTful web service calls.In this tutorial, we're going to show you hubspot setup.
What week of the year is it and how to get its start date
This method will help you answer the question - what week of the year is it, and give you the start date of each week.
3D References in Excel
Learn about 3D References in Excel in Excel, including the relevant formula or feature, setup steps, and practical usage.
Integrate SpreadsheetWeb with SalesForce
Follow the Integrate SpreadsheetWeb with SalesForce with a focused overview of the required setup, configuration steps, and expected result.
How to reduce file size of your Excel workbooks
In this article, we’re going to cover the most efficient ways to reduce file size of your Excel workbooks.
Count unique values Excel
This article shows How to count unique values by using SUMPRODUCT and COUNTIF functions.
How to get last match
Learn how to get last match. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to find closest match
Learn how to find closest match. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to sum every N rows
Adding certain cells in a table can be challenging. This article shows how to sum every n rows by using the SUM and the OFFSET functions.
How to calculate average by week number
This article focuses on to calculate average by week number with exact week number by using WEEKNUM and AVERAGEIFS functions.
How to count by week number
This article focuses on to count by week number with exact week number by using COUNTIFS and WEEKNUM functions.
How to create conditional Excel drop down lists
Learn how to create conditional Excel drop down lists. This practical guide covers the required setup, step-by-step process, and useful Excel options.
How to highlight values based on item lists
You can highlight the duplicate values in a data set to help identify the outliers. Let's see how to highlight values based on item lists.
How to replace character in Excel by position
This article shows how to replace character in Excel by position using REPLACE function. If you are looking to replace a specific character please refer to article How to replace a character.
Excel Case Statements: SWITCH Function Versus Nested IF
Excel case statements can be handled via the SWITCH function which can essentially do what nested IF functions can, using only one function.
How to replace characters in Excel
In this article we're going to show you how to replace a character in Excel using the SUBSTITUTE function.
Grouping Dates in Pivot Table
Learn about grouping Dates in Pivot Table in Excel, including the relevant formula or feature, setup steps, and practical usage.
How to sum by date in Excel without time
Excel has functions like the SUMIFS can't work if you have date-time values combined. This article shows How to sum by date in Excel without time.
How to calculate running totals in Excel Tables
Learn how to calculate running totals in Excel Tables. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a Quarter formula in Excel
Learn how to create a Quarter formula in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to generate Excel month names
Learn how to generate Excel month names. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Excel Named Ranges
In addition to allowing quick access to complex references, Excel named ranges can make your formulas a lot easier to read and maintain.
How to create a dynamic drop down list in Excel
Creating a dynamic Excel drop down list is useful If you have a list that is updated frequently. This article shows you how to create a dynamic drop down lists with the help of OFFSET and COUNTA functions.
How to get Excel cell address of a lookup result
Learn how to get Excel cell address of a lookup result. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.