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 21 of 55 · 1319 articles
The SpreadsheetWeb Hub is Here!
Explore The SpreadsheetWeb Hub is Here, with a focused look at welcome to Workspaces, strike up a Conversation with Your Users, and tag Everything.
How to use table reference within a data validation list in Excel
In this guide, we’re going to show you How to use table reference within a data validation list in Excel.
How to display negative numbers as zero in Excel
Learn how to display negative numbers as zero in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to Create Charts with Formula in Excel
This guide demonstrates a straightforward method for creating charts with formulas in Excel. Join us as we explore this simple approach.
How to Mark a Workbook as Final in Excel - Mark as Final
In this guide, we’re going to show you How to mark a workbook as final in Excel.
Excel TREND Function
In this guide, we’re going to show you how to use the TREND function and go over some tips and error handling methods.
Spreadsheets Can be Effective Estimation Software for Many Construction Companies.
Explore Spreadsheets Can be Effective Estimation Software for Many Construction Companies, with a focused look at what is Estimation, the Importance of the Accuracy of Estimates, and what Information is Used to Create an Estimate.
How to Perform Trend Analysis in Excel
In this guide, we’re going to show you How to perform trend analysis in Excel.
How to Perform Trend Analysis with Charts in Excel
In this guide, we’re going to show you How to perform trend analysis with charts in Excel.
How to Calculate Selected Cells Only in Excel
In this guide, we’re going to show you How to calculate selected cells only in Excel.
How to create ridgeline plot (joy plot) in Excel
In this guide, we’re going to show you How to create ridgeline plot (joy plot) in Excel.
How to Store User Defined Function in Excel
In this guide, we’re going to show you How to store user defined function in Excel.
How to Create Tornado Charts in Excel
In this guide, we’re going to show you How to create tornado charts in Excel.
Creating Engineering Applications from Spreadsheet Models
Creating Engineering Applications from Spreadsheet Models.
How to make words plural in Excel
In this guide, we’re going to show you How to make words plural in Excel.
How to seasonal forecast with formulas in Excel
In this guide, we’re going to show you How to seasonal forecast with formulas in Excel.
Excel FORECAST.ETS.STAT Function
In this guide, we’re going to show you how to use the FORECAST ETS STAT function and go over some tips and error handling methods.
Excel FORECAST.ETS.CONFINT Function
In this guide, we’re going to show you how to use the FORECAST ETS CONFINT function and go over some tips and error handling methods.
FORECAST.ETS.SEASONALITY
In this guide, we’re going to show you how to use the FORECAST ETS SEASONALITY function and go over some tips and error handling methods.
Excel FORECAST.ETS Function
In this guide, we’re going to show you how to use the FORECAST ETS function and go over some tips and error handling methods.
Excel FORECAST.LINEAR Function
In this guide, we’re going to show you how to use the FORECAST LINEAR function and go over some tips and error handling methods.
Versioning Excel Files
Learn how Excel's FILES function works, including its syntax, arguments, and practical usage.
How to change CSV delimiter in Excel
In this guide, we’re going to show you how to change CSV delimiter in Excel.
How to hide used items in dropdown lists in Excel
In this guide, we’re going to show you How to hide used items in dropdown lists in Excel.