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 · 1312 articles

Adam · Sep 1, 2021

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.

Ilker · Aug 27, 2021

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.

Adam · Aug 23, 2021

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.

Ugur · Aug 19, 2021

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 message on Status Bar in Excel
Ilker · Aug 19, 2021

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 mouse in Excel
Ilker · Aug 17, 2021

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.

Adam · Aug 11, 2021

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.

Adam · Aug 11, 2021

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 manage worksheets in Excel
Ilker · Aug 11, 2021

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
Ilker · Aug 10, 2021

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
Ilker · Aug 9, 2021

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
Ilker · Aug 9, 2021

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
Ilker · Aug 5, 2021

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.

80% of DJIA companies use Low-Code/No-Code platforms
Ugur · Aug 4, 2021

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.

Ilker · Aug 4, 2021

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 VBA 01
Ilker · Jul 30, 2021

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
Ilker · Jul 29, 2021

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.

How to print header row and column in Excel
Ilker · Jul 29, 2021

How to print header row and column in Excel

In this guide, we’re going to show you how to print header row and column in Excel.

How to Insert a Combo Box in Excel
Ilker · Jul 28, 2021

How to Insert a Combo Box in Excel

In this guide, we’re going to show you how to insert a combo box in Excel.

How to insert a spin button in Excel
Ilker · Jul 28, 2021

How to insert a spin button in Excel

In this guide, we’re going to show you how to insert a spin button in Excel.

How to show a closing message in Excel
Ilker · Jul 28, 2021

How to show a closing message in Excel

Learn how to show a closing message in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.

How to insert a slider in Excel 00-min
Ilker · Jul 26, 2021

How to insert a Slider in Excel

A slider is a control to select a numeric value from a range. In this guide, we’re going to show you how to insert a slider in Excel.

How to insert a button in Excel
Ilker · Jul 26, 2021

How to insert a button in Excel

Learn how to insert a button in Excel. This practical guide covers the required setup, step-by-step process, and useful Excel options.

Excel QUOTIENT Function
Ilker · Jul 15, 2021

Function: QUOTIENT

In this guide, we’re going to show you how to use the QUOTIENT function and also throw in some tips and error handling methods.