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 · 1312 articles
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.
How to create waffle charts in Excel
In this guide, we’re going to show you how to create waffle charts in Excel.
How to visualize percentage progress in Excel
In this guide, we’re going to show you How to visualize percentage progress in Excel with Conditional Formatting.
How to close all workbooks in Excel with VBA
In this guide, we’re going to show you how to close all workbooks with or without saving in Excel with VBA.
Creating A Work Order Template with SpreadsheetWeb Using Excel
With its built-in tools and simple interface, SpreadsheetWEB provides a complete solution to the process of creating work order templates.
How to calculate depreciation in Excel
In this guide, we’re going to show you How to calculate depreciation in Excel by 7 built-in functions.
How to calculate units of production depreciation in Excel
In this guide, we’re going to show you How to calculate units of production depreciation in Excel.
Excel AMORLINC Function
In this guide, we’re going to show you how to use the AMORLINC function and go over some tips and error handling methods.