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 34 of 55 · 1312 articles
What's New in SpreadsheetWEB 6.15
With the 6.15 version, SpreadsheetWEB now features server-side caching, and record locking capabilities, paving the way for new features.
Server-side Caching and Record Locking in SpreadsheetWEB 6.15
Pagos, announces the release of SpreadsheetWEB 6.15, now featuring record locking, and a major rework in the form of server-side caching.
How to Make Excel Change Scope of Named Range
In this guide, we're going to show you how to make Excel change scope of named range across the workbooks and worksheets, with examples.
How to Pay Off Debt and Create Your Own Debt Payoff Calculator
When buying a house or car that you could only afford years from today, creating a budget for college expenses, or simply taking on credit cards due to unexpected events; debt can be a very powerful tool when used correctly.
How to apply named ranges to existing formulas in Excel
What if named ranges are created after formulas. In this guide, we're going to show you how to apply named ranges to existing formulas.
How to use Wildcard criteria in Excel formulas
Wildcard represents one or more other characters. In this guide, we're going to show you how to use Wildcard criteria in Excel formulas.
How to simplify Nested IF statements
Nested IF formulas can get messy when dealing with too many conditions. In this guide we're going to see how to simplify Nested IF statements.
How to Make Excel Remove Named Range Containing Errors
In this guide, we’re going to show you how to make Excel remove named range containing errors. You will learn about Name Manager as well.
Excel TEXTJOIN and CONCAT
Forget the CONCATENATE function! In this guide, we're going to show you how to use the Excel TEXTJOIN and CONCAT functions to merge texts.
CONCAT vs CONCATENATE
In this guide, we are going to focus on the CONCAT function and look at some of the differences between the CONCAT vs CONCATENATE functions.
How to create dynamic images in Excel without VBA
In this guide, we're going to show you how to create dynamic images in Excel. The methods in this article don't involve any VBA or coding.
How to find duplicates in Excel and remove or consolidate them
In this guide, we're going to show you how to find duplicates in Excel and also remove or consolidate them using various methods.
How to prevent a #REF error in Excel
A #REF error in Excel indicates an invalid reference. In this guide, we're going to show you how to prevent a #REF error in Excel.
How to use Text to Columns in Excel
In this article, we are going to show you how to use the Excel Text to Columns. This way, you can split text in a cell into multiple columns.
How to make Excel calculate faster
Complex files can slow your workbook and impact calculation time. In this guide we're going to show you how to make Excel calculate faster.
RANK.AVG (RANK AVG) Function in Excel
In this guide, we’re going to show you how to use the RANK.AVG (RANK AVG) function and also go over some tips and error handling methods.
RANK EQ Excel Function (RANK.EQ)
In this guide, we’re going to show you how to use the RANK.EQ (RANK EQ Excel) function and also go over some tips and error handling methods.
AVERAGEA in Excel
In this guide, we’re going to show you how to use AVERAGEA in Excel and also go over some tips and error handling methods.
All You Need to Know on How to Create a VBA loop in Excel
A loop is an essential concept for programming. In this guide, we're going to show you how to create a VBA loop in Excel.
Connected Workbooks: SpreadsheetWeb Supports External References (Links) in Excel
External reference connects a cell or range on a worksheet to another Excel workbook.
Control Shift Enter Excel Shortcut (CSE) and Array Formulas
In this guide, we're going to explain you Control Shift Enter Excel shortcut (CSE) and how to apply array formulas in Excel.
10 Things You Need to Know About the VLOOKUP Excel Function
In this guide we're going to list 10 things you should know about VLOOKUP Excel function. These tips also work for the HLOOKUP function.
What’s New in SpreadsheetWeb 6.14
The SpreadsheetWEB Connector works like external references in Excel, but with everything inside the SpreadsheetWEB ecosystem.
Version 6.14 Introduces the New SpreadsheetWEB Connector
Pagos, Inc. has just announced the release of version 6.14, introducing the new SpreadsheetWEB Connector and enhanced headers support in grid controls.