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 20 of 55 · 1312 articles
Excel TEXTSPLIT Function
In this guide, we’re going to show you how to use the TEXTSPLIT function and go over some tips and error handling methods.
How to convert European date to US date in Excel with formula
In this guide, we’re going to show you How to convert European date to US date in Excel with formula.
Excel VALUE Function
In this guide, we’re going to show you how to use the VALUE function and go over some tips and error handling methods.
How to convert European date to US date in Excel
In this guide, we’re going to show you How to convert European date to US date in Excel and vice versa.
Connect Your Spreadsheet Models to Thousands of Services using Zapier
Explore Connect Your Spreadsheet Models to Thousands of Services using Zapier, with a focused look at connecting an Online Calculator to a CRM System and embedding Pricing Calculations into a CRM System.
How to swap two cells in Excel
In this article, we are going to show how to swap two cells in Excel for several scenarios.
How to generate Descriptive Statistics in Excel
In this article, we are going to show how to generate Descriptive Statistics in Excel.
Converting an Insurance Rating Spreadsheet into a No-Code API
converting insurance rating spreadsheets into no-code APIs.
How to use subtotal feature in Excel
In this article, we are going to show how to use subtotal feature in Excel to aggregate a data set by certain sections.
How to calculate as-the-crow-flies distance between two cities in Excel
In this article, we are going to show how to calculate as-the-crow-flies distance between two cities in Excel.
Building Scored Questionnaires with SpreadsheetWeb Hub
A focused overview of building Scored Questionnaires with SpreadsheetWeb Hub, explaining the main ideas, practical considerations, and relevant examples.
A Use Case of Excel's LAMBDA Function in SpreadsheetWeb: Splitting Text by delimiter with LAMBDA Function
In this article, we will split text by delimiter with LAMBDA Function and convert our Excel model to a web application.
Building Timesheet Applications with SpreadsheetWeb Hub
A focused overview of building Timesheet Applications with SpreadsheetWeb Hub, explaining the main ideas, practical considerations, and relevant examples.
Excel DEGREES Function
In this guide, we’re going to show you how to use the DEGREES function and go over some tips and error handling methods.
Building an Insurance Quoting Application with SpreadsheetWeb Hub
A focused overview of building an Insurance Quoting Application with SpreadsheetWeb Hub, explaining the main ideas, practical considerations, and relevant examples.
Excel RADIANS Function
In this guide, we’re going to show you how to use the RADIANS function and go over some tips and error handling methods.
A Use Case of Excel's LAMBDA Function in SpreadsheetWeb: Calculating Distance by Latitude and Longitude
In this article, we are going to show calculating distance by longitude and latitude with LAMBDA Function.
The SpreadsheetWeb Hub is Here!
Explore The SpreadsheetWeb Hub is Here, with a focused look at welcome to Workspaces, strike up a Conversation with Your Users, and tag Everything.
How to use table reference within a data validation list in Excel
In this guide, we’re going to show you How to use table reference within a data validation list in Excel.
How to display negative numbers as zero in Excel
Learn how to display negative numbers as zero in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to Create Charts with Formula in Excel
This guide demonstrates a straightforward method for creating charts with formulas in Excel. Join us as we explore this simple approach.
How to Mark a Workbook as Final in Excel - Mark as Final
In this guide, we’re going to show you How to mark a workbook as final in Excel.
Excel TREND Function
In this guide, we’re going to show you how to use the TREND function and go over some tips and error handling methods.
Spreadsheets Can be Effective Estimation Software for Many Construction Companies.
Explore Spreadsheets Can be Effective Estimation Software for Many Construction Companies, with a focused look at what is Estimation, the Importance of the Accuracy of Estimates, and what Information is Used to Create an Estimate.