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 27 of 55 · 1312 articles
NoCode in Insurance
The application of NoCode in insurance proves to be a great opportunity for automating various business processes, with its own challenges.
What's New in 6.22: CRM Integrations
We added embedded support for a couple of popular CRM platforms: SpreadsheetWeb is now available on the HubSpot and Pipedrive marketplaces!
SpreadsheetWeb 6.22 Featuring Integration with Major CRM Systems
Pagos today announced the release of SpreadsheetWeb 6.22, introducing integration with popular CRM systems like HubSpot and Pipedrive.
How to insert country flags in Excel
Learn how to insert country flags in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to replace pivot tables with dynamic array formulas in Excel
In this guide, we’re going to show you how to replace pivot tables with dynamic array formulas in Excel.
5 tips for VBA beginners in Excel
In this guide, discover five beginner-friendly productivity tips for using VBA in Excel to enhance your Excel automation skills efficient.
How to create index of sheets in Excel with hyperlinks
Learn how to create index of sheets in Excel with hyperlinks. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to make multiple selections in a dropdown list in Excel
In this guide, we're going to show you how to make multiple selections in a dropdown list in Excel as well as parsing example.
How to get quarter from a date in Excel
Learn how to get quarter from a date in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Function: CHISQ.TEST
In this guide, we’re going to show you how to use the CHISQ.TEST function and also go over some tips and error handling methods. (CHISQ TEST).
SpreadsheetWeb’s New Calculation Engine is Faster than Excel in 3 out of 4 Files
Explore SpreadsheetWeb’s New Calculation Engine is Faster than Excel in 3 out of 4 Files, with a focused look at methodology and results.
How to flip data in Excel
Learn how to flip data in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to split text with Power Query in Excel
In this guide, we're going to show you how to split text with Power Query in Excel.
How to disable protected view mode in Excel
In this guide, we're going to show you How to disable protected view mode the infamous yellow band above formula bar in Excel.
How to split text with VBA in Excel
In this guide, we're going to show you how to split text with VBA in Excel.
Turn Excel Spreadsheets into Powerful Web Applications
Discover how SpreadsheetWeb turns spreadsheet models into secure, interactive web applications without rebuilding their calculation logic.
Turn Excel Spreadsheets into Powerful Web Applications
Discover how SpreadsheetWeb turns spreadsheet models into secure, interactive web applications without rebuilding their calculation logic.
Turn Excel Spreadsheets into Powerful Web Applications
Discover how SpreadsheetWeb turns spreadsheet models into secure, interactive web applications without rebuilding their calculation logic.
Turn Excel Spreadsheets into Powerful Web Applications
Discover how SpreadsheetWeb turns spreadsheet models into secure, interactive web applications without rebuilding their calculation logic.
Turn Excel Spreadsheets into Powerful Web Applications
Discover how SpreadsheetWeb turns spreadsheet models into secure, interactive web applications without rebuilding their calculation logic.
Turn Excel Spreadsheets into Powerful Web Applications
Discover how SpreadsheetWeb turns spreadsheet models into secure, interactive web applications without rebuilding their calculation logic.
Turn Excel Spreadsheets into Powerful Web Applications
Discover how SpreadsheetWeb turns spreadsheet models into secure, interactive web applications without rebuilding their calculation logic.
How to split text with formulas in Excel
In this guide, we're going to show you how to split text with formulas in Excel.
How to count a specific character in a string in Excel
Learn how to count a specific character in a string in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.