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 31 of 55 · 1312 articles
How to count the number of cells less than the average in Excel
Learn how to count the number of cells less than the average in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Function: CELL
In this guide, we’re going to show you how to use the CELL function and also go over some tips and error handling methods.
How to create a pizza chart in Excel
In this article, we are going to show you how to create a pizza chart in Excel. You can give your charts a fancy look.
How to create a worksheet selection popup in Excel
In this article, we are going to show you how to create a worksheet selection popup in Excel by using VBA.
How to calculate the percent of completed month
In this article, we are going to show you how to calculate the percent of completed month in Excel. The article uses DAY and EOMONTH.
Function: YEARFRAC
In this guide, we’re going to show you how to use the YEARFRAC function and also go over some tips and error handling methods.
How to calculate the percent of completed year
In this article, you'll learn how to calculate the percent of completed year in Excel. Formula is using YEARFRAC, DATE and YEAR functions.
How to create a thermometer chart in Excel
A thermometer chart is a way of comparing two values. In this article, we are going to show you how to create a thermometer chart in Excel.
How to modify a Comment Box in Excel
The default comment box style in Excel is fairly outdated. In this article, we are going to show you how to modify a Comment Box in Excel.
What's New in 6.19: Offline Application Capabilities
Using the Import from Excel file feature, you can create a new record with the uploaded data or overwrite the data in an existing record.
How to use Clipboard in Excel
Clipboard feature lists the items you copied and allow you to paste. In this article, we are going to show you how to use Clipboard in Excel.
SpreadsheetWeb 6.19 Features Offline Application Capabilities
Version 6.19 welcomes the “Import from Excel file” feature that allows offline usage and update records by uploading an Excel file.
How to copy sheet in Excel with VBA
In this guide, we're going to show you how to copy sheet in Excel with VBA. You can can copy any sheet into any position.
How to customize ribbon in Excel
The Excel ribbon displays commands as icons in a strip. In this article, we are going to show you how to customize ribbon in Excel.
Building Customer-Facing NoCode Portals with SpreadsheetWeb
The purpose of customer-facing nocode portals is to automate a specific business function by providing the customers with a web and/or mobile presence to submit their information, and get results without having to interact with customer representatives.
How to select a random item from a list in Excel
In this article, we are going to show you how to select a random Item from a list in Excel in two ways with examples.
How to sort birthdays in Excel
Excel lacks of sorting dates by month and day. In this article, we are going to show you how to sort birthdays in Excel.
Formula Override Feature in Designer Applications
Formula Override feature in Designer allows the users to override the value of a formula-generated output control during runtime.
How to sort dates by month in Excel
Sorting is an important process in organizing a data. In this article, we are going to show you how to sort dates by month in Excel.
How to create a Funnel chart in Excel without Microsoft 365
Learn how to create a Funnel chart in Excel without Microsoft 365. This practical guide covers the required setup, step-by-step process, and useful Excel options.
Funnel Chart in Excel
A funnel chart visualizes progress through different stages of a process. This guide going to show you to create a funnel chart in Excel.
.
Read a SpreadsheetWeb customer story about turning spreadsheet-driven work into a maintainable web application.
..
Read a SpreadsheetWeb customer story about turning spreadsheet-driven work into a maintainable web application.
Matt G.
See how Matt G. used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.