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 42 of 55 · 1312 articles
Pagos Has Released SpreadsheetWEB 6.8 Introducing Ability to Add Charts and Maps in Print Process
Pagos, Inc. today released SpreadsheetWEB version 6.8 which introduces the ability to add charts and maps in print processes.
Creating an Interactive Pricing Application using Excel’s New Dynamic Array Functions
A pricing application where you enter higher-level product details, then the specific item is a perfect example for using dynamic arrays.
Security Audit Forms Work More Efficiently as Web Applications
To ensure their vendors follow certain security measures, businesses request audit forms, but this workflow can work better on the web.
Excel UNIQUE Function: Spill Range Operator
The unique function in Excel is a tool for handling dynamic arrays and spill concepts. Also, it introduces the spill range operator(#).
All you need to know about Excel's new Spill feature
Excel formulas can now return (spill) an array of values into neighboring cells by starting with cell containing the formula.
Adding or Removing Data Columns in the Data Page
The data columns can be customized to display any system fields, or application fields that have been defined in the database module.
SINGLE Function
In this guide, we’re going to show you how to use the SINGLE function and also go over some tips and error handling methods.
Pivot Table Alternative Using Formulas
In this guide, we’re going to show you how to create data tables using formulas as Pivot Table alternative.
SEQUENCE Function
In this guide, we’re going to show you how to use the SEQUENCE function and also go over some tips and error handling methods.
How to Add Dynamic Images in Designer Applications
The versatile content fields of designer applications can host rich text, HTML tags, and even dynamic images.
Time Tracking Applications
A time tracking application created with SpreadsheetWEB comes with centralized data in a scalable, and easily accessible platform.
FILTER Function
In this guide, we’re going to show you how to use the Excel FILTER function and also go over some tips and error handling methods.
Creating Dynamic Lists in Designer Applications
A dynamic list is a set of options that change based on other parameters. With this, you can manage large list of items in smaller groups.
SORT Function
In this guide, we’re going to show you how to use the SORT function and also go over some tips and error handling methods.
UNIQUE Function
In this guide, we’re going to show you how to use the Excel UNIQUE function and also go over some tips and error handling methods.
How to delete blank rows and columns at the end of worksheets using VBA
Learn how to delete blank rows and columns at the end of worksheets using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
Area Chart in Excel
Learn how Area Chart in Excel works, including its structure, available chart types, and the steps for creating it in Excel.
Function: INDEX
In this guide, we’re going to show you how to use the Excel INDEX function and also go over some tips and error handling methods.
Save SpreadsheetWEB Applications as Home Screen Apps on iOS and Android
In this tutorial, we're going to show you how to create "app-like" tools for iOS and Android devices from your SpreadsheetWEB applications.
Activity App
A focused overview of activity App, explaining the main ideas, practical considerations, and relevant examples.
Configure, Price, Quote with Excel
Explore Configure, Price, Quote with Excel, with a focused look at what makes Excel a platform for CPQ, limitations of Excel as a CPQ platform, and transform CPQ spreadsheets to web applications.
IFS Function in Excel
In this guide, we’re going to show you how to use the function (Excel If Statement) and also go over some tips and error handling methods.
Excel SWITCH Function
In this guide, we’re going to show you how to use the Excel SWITCH function and also go over some tips and error handling methods.
Control Panel Language Tutorial
You can edit the language files on your server installation to customize the text fields displayed throughout the Control Panel.