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 24 of 55 · 1319 articles
Integration of Custom Pricing Algorithms with CRM Systems
With SpreadsheetWeb CRM integrations, you can connect your Excel-based web applications into your CRM tools in just a few minutes.
How to create five-star rating chart in Excel
In this guide, we’re going to show you how to create five-star rating chart in Excel by using conditional formatting.
How to spell check using VBA in Excel
Excel's spell check does not run as you type. In this guide, we’re going to show you how to automate spell check using VBA in Excel.
How to calculate exponential moving average in Excel
In this guide, we’re going to show you how to calculate exponential moving average in Excel.
How to calculate weighted moving average in Excel
In this guide, we’re going to show you how to calculate weighted moving average in Excel.
How to calculate simple moving average in Excel
In this guide, we’re going to show you how to calculate simple moving average in Excel in three ways.
How to insert a picture into a note in Excel
In this guide, we’re going to refer legacy comments as Notes and show you how to insert a picture into a note in Excel.
How much money have Low-Code/No-Code vendors raised?
We analyzed Investments in Low-Code and No-Code raised by a list of 442 Low-Code/No-Code vendors, from public data sources.
How to create a stream graph in Excel
In this guide, we’re going to show you how to create a stream graph, or streamgraph in Excel.
Calculator Apps in No-Code
There are many No-Code platforms that can create calculator apps. You can use certain built-in functions to implement your calculation logic.
How many Low-Code/No-Code platforms are out there?
Explore How many Low-Code/No-Code platforms are out there, with a focused look at there are 442 Low Code/No-Code platforms.
How to show a message on Status Bar in Excel
Learn how to show a message on Status Bar in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to generate numbers without dragging the mouse in Excel
In this guide, we’re going to show you how to generate numbers without dragging mouse in Excel.
What’s New in SpreadsheetWeb 6.24: Goal Seek, Close, and Zoho
SpreadsheetWeb 6.24 version introduces the new Goal Seek Event, and integrations with Zoho and Close CRM platforms.
SpreadsheetWeb 6.24 Introduces Goal Seek Support
Version 6.24 of SpreadsheetWeb welcomes the addition of the new Goal Seek event, as well as the Zoho and Close CRM integrations.
How to Group Worksheets and How to Manage in Excel
In this guide, we’ll show you how to manage worksheets in Excel with tips and mouse and keyboard shortcuts and to group worksheets in excel.
How to use Data Table in Excel
In this guide, we’re going to show you how to use Data Table in Excel. Data Table is a What-If Analysis tool to test your based on variables.
How to calculate simple interest in Excel
Learn how to calculate simple interest in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to calculate compound interest in Excel
Excel is a powerhouse for financial calculations. In this guide, we’re going to show you how to calculate compound interest in Excel.
How to create a step chart in Excel
Although Excel does not have step chart support by default, in this guide, we’re going to show you how to create a step chart in Excel.
How Many Enterprises Use Low-Code/No-Code Platforms?
Penetration in the enterprise market is an important indicator for analyzing the overall success of Low-Code/No-Code platforms.
How to create slopegraphs in Excel
In this guide, we’re going to show you how to create slopegraphs, simple though effective elements of visual storytelling, in Excel.
How to convert string to number in Excel using VBA
In this guide, we’re going to show you how to convert string into number in Excel VBA.
How to use Scenario Manager in Excel
In this guide, we’re going to show you how to use Scenario Manager in Excel to keep set of input values for specific cells.