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 29 of 55 · 1312 articles
Function: XMATCH
In this guide, we’re going to show you how to use the XMATCH function and also go over some tips and error handling methods.
Function: XLOOKUP
In this guide, we’re going to show you how to use the XLOOKUP function and also go over some tips and error handling methods.
How to avoid formatting change in CSV files in Excel
In this article, we are going to show you how to avoid formatting change in CSV files in Microsoft 365, Excel 2019, 2016, 2013 and 2010.
What's New in 6.21: Artificial Intelligence Driven Application Building
To enhance the application development experience, we have launched an Artificial Intelligence (AI) based approach for our trial users.
SpreadsheetWeb 6.21 Features Artificial Intelligence (AI) Assistance
Pagos announces the release of SpreadsheetWeb 6.21 with the introduction of the new AI-driven application builder for trial accounts.
How to consolidate text with Pivot Table in Excel
Learn how to consolidate text with Pivot Table in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to consolidate text by a condition in Excel
Learn how to consolidate text by a condition in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a 3D Map in Excel
Learn how to create a 3D Map in Excel. This practical guide covers the required setup, step-by-step process, and useful Excel options.
2
Read a SpreadsheetWeb customer story about turning spreadsheet-driven work into a maintainable web application.
1
Read a SpreadsheetWeb customer story about turning spreadsheet-driven work into a maintainable web application.
Excel Mouse Tips & Tricks
In this article, we are going to show you 12 awesome mouse tips and tricks that will level up your productivity in Excel.
How to get a list of file names in Excel
In this article, we are going to show you how to get a list of file names from a specific folder and all its subfolders in Excel.
How to use the "Pick from drop-down list" feature in Excel
In this article, we are going to show you how to use pick from drop-down list feature in Excel, the fastest populated drop-down.
How to import XML files into Excel
In this article, we are going to show you how to import XML files into Excel. We will describe both direct method and Power Query approach.
How to find the last day of a month in Excel
Learn how to find the last day of a month in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to find the position of the minimum value in Excel
In this article, we are going to show you how to find the position of the minimum value in Excel with MATCH and MIN functions.
Adam Seiz
A focused overview of adam Seiz, explaining the main ideas, practical considerations, and relevant examples.
Shannon Ayers
A focused overview of shannon Ayers, explaining the main ideas, practical considerations, and relevant examples.
Caitlin Buglione
See how Caitlin Buglione used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
Alan McMillan
See how Alan McMillan used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
Andrew Reynolds
See how Andrew Reynolds used SpreadsheetWeb to turn spreadsheet-driven work into a web application and improve its business process.
How to find the position of the maximum value in Excel
In this article, we are going to show you how to find the position of the maximum value in Excel with 2 ways.
Function: LET
In this guide, we are going to show you how to use the LET function and go over some tips and error handling methods.
How to prevent future dates from being entered in Excel
In this article, we are going to show you how to prevent future dates in Excel by using Data Validations rules.