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 30 of 55 · 1312 articles
Converter Template
This unit conversion template makes it easy to convert units, especially when dealing with some scientific units such as velocity, or energy.
Depreciation Calculator
This is a depreciation calculator template can give you the annual depreciation rates and book values using three methods.
Car Lease vs Purchase
This is an easy to use Excel tool that can help you decide between leasing or purchasing a car. Should you lease or purchase?
Cash Flow Projection
This template can be used for visualizing, tracking, and projecting cash flow of a business or individual over 12 months.
Box-and-Whisker Charts
In this guide, we’re going to show you how to create a box-and-whisker chart in Excel. These charts can be used for statistical plotting.
How to create a sequence of dates in Excel - Autofill
Learn how to create a sequence of dates in Excel - Autofill. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a dynamically changing calendar in Excel
Do you want a dynamic calendar in your worksheet? In this article, we are going to show you how to create a calendar in Excel.
How to change case in Excel
Learn how to change case in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Function: DEC2HEX
In this guide, we’re going to show you how to use the DEC2HEX function and also go over some tips and error handling methods.
Function: HEX2DEC
In this guide, we’re going to show you how to use the HEX2DEC function and also go over some tips and error handling methods.
How to use emojis in Excel
Doesn’t emojis in Excel work sound well? In this article, we are going to show you how to use emojis in Excel.
Net Worth Calculator
Net Worth Calculator provides a practical spreadsheet model. This overview explains what it calculates and how it can be used with SpreadsheetWeb.
Investment Model
This Excel template is a simple investment model that may be used for analyzing an investment and cashflows using various methods.
How to use symbols on charts in Excel
Do you ever want to use symbols on your chart? In this article, we are going to show you how to use symbols on charts in Excel.
Pagos Announces the Release of SpreadsheetWeb 6.20
SpreadsheetWeb 6.20, further empowering the nocode users in transforming their spreadsheet models into web applications with ease.
How to find nth closest match in Excel
Learn how to find nth closest match in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a Waterfall Chart in Excel
In this guide, we’re going to show you how to create a waterfall chart in Excel to visualize +ve or -ve values in a data series affect sequentially.
How to cut and paste transpose in Excel
Excel doesn’t support transpose paste after cutting. In this article, we are going to show you how to cut and paste transpose in Excel.
Safety Stock Inventory Template
Safety Stock Inventory Template provides a practical spreadsheet model. This overview explains what it calculates and how it can be used with SpreadsheetWeb.
Retirement Savings Calculator
Retirement Savings Calculator provides a practical spreadsheet model. This overview explains what it calculates and how it can be used with SpreadsheetWeb.
Mortgage Calculator
Mortgage Calculator provides a practical spreadsheet model. This overview explains what it calculates and how it can be used with SpreadsheetWeb.
How to find the first blank cell in a range in Excel
In this article, we are going to show you how to find the first blank cell in a range in Excel. You can create a hyperlink to that cell too.
How to find the first non-blank cell in a range in Excel
In this article, we are going to show you how to find the first non-blank cell in a range in Excel with MATCH and ISBLANK functions.
How to count the number of cells greater than the average in Excel
Learn how to count the number of cells greater than the average in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.