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 38 of 55 · 1312 articles
How to perform reverse lookup with CHOOSE function
In this guide, we are going to show you how to perform an Excel reverse lookup using the CHOOSE function, instead of the traditional VLOOKUP.
Treemap Excel Charts: The Perfect Tool for Displaying Hierarchical Data
On a treemap visualization, each item is represented by a rectangular shape, where smaller rectangles represent the sub-groups.
Function: CHOOSE
In this guide, we’re going to show you how to use the Excel CHOOSE function and also go over some tips and error handling methods.
How to create a dynamic drop down list Excel using the UNIQUE and FILTER functions
In this article, we are going to show you how to create a dynamic drop down list Excel using the dynamic array functions UNIQUE and FILTER.
Comparing the Performance of SpreadsheetWeb 6.11 with Google Sheets and the Microsoft Office 365 Excel API
A focused overview of comparing the Performance of SpreadsheetWeb 6.11 with Google Sheets and the Microsoft Office 365 Excel API, explaining the main ideas, practical considerations, and relevant examples.
How to create an Excel dynamic list or a table without helper columns using SEQUENCE
Let us show you how to create an Excel dynamic list or table using the Excel auto generate number sequence function: SEQUENCE.
Function: ISEVEN
In this guide, we’re going to show you how to use the Excel ISEVEN function and also go over some tips and error handling methods.
Function: ISREF
In this guide, we’re going to show you how to use the Excel ISREF function and also go over some tips and error handling methods.
Function: ISTEXT
In this guide, we’re going to show you how to use the ISTEXT Excel function and also go over some tips and error handling methods.
What's New in SpreadsheetWEB 6.11
This version welcomes the addition of the new Connectors module, that can easily connect your applications and other third-party services.
How to random sort in Excel using dynamic array functions
In this article, we are going to show you how to random sort in Excel using the RANDARRAY, SORTBY, and dynamic array functions.
Pagos Releases SpreadsheetWEB 6.11 with the New Connectors Module
SpreadsheetWEB 6.11 was just released, featuring a new Connectors module to connect external services like payment, notifications, and more.
Function: ISLOGICAL
In this guide, we’re going to show you how to use the Excel ISLOGICAL function and also go over some tips and error handling methods.
How to display the Excel Developer tab for using advanced features
Excel hides the Developer tab by default to simplify the software interface. Let us show you how to display the Excel Developer tab.
Function: ISERROR
In this guide, we’re going to show you how to use the ISERROR Excel function and also go over some tips and error handling methods.
Function: ISERR
In this guide, we’re going to show you how to use the ISERR function and also go over some tips and error handling methods.
Function: CONVERT
In this guide, we’re going to show you how to use the Excel CONVERT function and also go over some tips and error handling methods.
How to refresh stock data in Excel
In this article, we are going to show how to refresh stock data in Excel in 4 different ways, from doing this with a shortcut to a VBA macro.
Function: NETWORKDAYS
In this guide, we’re going to show you how to use the NETWORKDAYS function to find the number of work days between dates.
Function: DAYS360
In this guide, we’re going to show you how to use the Excel DAYS360 function and also go over some tips and error handling methods.
Function: WEEKNUM
In this guide, we’re going to show you how to use the WEEKNUM function that can find the week index number of a given date.
Function: WEEKDAY
In this guide, we’re going to show you how to use the Excel WEEKDAY function and also go over some tips and error handling methods.
Function: EOMONTH
In this guide, we’re going to show you how to use the EOMONTH Excel function and also go over some tips and error handling methods.
Function: DAYS
Learn how Excel's DAYS function works, including its syntax, arguments, and practical usage.