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 32 of 55 · 1312 articles
Robert P.
See how Robert P. used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
Salvatore C.
See how Salvatore C. used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
Angela Z.
See how Angela Z. used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
Kim B.
See how Kim B. used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
Caitlin B.
See how Caitlin B. used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
Asbjorn L.
See how Asbjorn L. used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
Alex C.
See how Alex C. used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
...
Read a SpreadsheetWeb customer story about turning spreadsheet-driven work into a maintainable web application.
What's New in 6.18: Formula Override and Advanced Data Filters
SpreadsheetWeb 6.18 version introduces new key features like Formula Override, Advanced Data Filters, and Google Sheets Connector.
Pagos Announces the Release of SpreadsheetWeb 6.18 with Formula Override and Advanced Data Filters
Version 6.18 introduces the ability to override formula-generated fields during runtime, enhanced filter options on the Data page.
Sunburst Chart in Excel
A sunburst chart is a type of visualization that works great for displaying hierarchical data. They are available in Excel 2016 or newer.
STANDARDIZE Function
In this guide, we’re going to show you how to use the STANDARDIZE Excel function and also go over some tips and error handling methods.
How to normalize data in Excel
Normalizing (or standardizing) is an essential step in analyzing large datasets. Let us show you how to normalize data in Excel.
Building a COVID-19 Dashboard in Excel
In this guide, we're going to show you tips of building a COVID-19 Dashboard in Excel to track and present the data more effectively.
Tracking COVID-19 Data in Excel using Power Query
In this guide, we're going to show you way of tracking COVID-19 Data in Excel using Power Query.
SpreadsheetWEB named one of the "5 Best Application Development Tools" by GetApp
We are thrilled to announce that SpreadsheetWEB was named one of “5 Best Application Development Tools” in GetApp's shortlist.
How to create an Excel map chart
A map chart help visualizing data in a map. In this article, we are going to show you how to insert a map chart in Excel.
How to embed Bing Maps in Excel
Did you know that you can embed maps in Excel to display location data? In this article, we are going to show you how to embed Bing maps.
How to disable Workbook_Open and Auto_Open in Excel
Either skip code for security or a programming decision, this article's going to show how to disable Workbook_Open and Auto_Open in Excel.
How to get Workbook Statistics in Excel
Workbook Statistics is a new feature for Excel 365. In this guide, we're going to show you how to get Workbook Statistics in Excel.
How to set an Excel expiration date
In this guide, we're going to show you how to set an Excel expiration date using VBA to prevent access to the workbook after expiration.
Create Online Quizzes with the Flexibility of Excel and Advanced Capabilities
A focused overview of create Online Quizzes with the Flexibility of Excel and Advanced Capabilities, explaining the main ideas, practical considerations, and relevant examples.
How to Remove a Line Break in Excel
In this guide, we’re going to show you how to Remove Line Breaks in Excel in 2 ways. Either using Find and Replace or Excel formulas.
What's New in SpredsheetWEB 6.17: Single Record per User
SpreadsheetWEB 6.17 features single record per user feature, database query trigger customization, and the new Google Sheets Connector.