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 39 of 55 · 1312 articles
How to monitor formulas using the Watch Window Excel feature
In this guide, we're going to show you how to monitor formulas with Watch Window.
How to Filter a Table in Excel
Data filters are essential for reporting and decision making. In this guide, we're going to show you tips about how to filter Excel Tables.
Function: EDATE
In this guide, we’re going to show you how to use the Excel EDATE function and also go over some tips and error handling methods.
Function: DATEDIF
In this guide, we’re going to show you how to use the DATEDIF function and also go over some tips and error handling methods.
How to add Total row in Excel Tables
You can add a dynamic row to your table to display aggregate data. Let us show you how to add a total row in Excel tables.
Function: RRI
In this guide, we’re going to show you how to use the RRI function and also go over some tips and error handling methods.
Slicers in Excel Tables
In this guide, we're going to show you tips about using slicers in Excel Tables.
How to Change Table Style in Excel
In this guide, we're going to show you how to apply styles in Excel tables.
Function: NPER
In this guide, we’re going to show you how to use the NPER function and also go over some tips and error handling methods.
Function: PMT
In this guide, we’re going to show you how to use the PMT function and also go over some tips and error handling methods.
5 Ways to Create an Excel Named Range
Using named ranges make formulas easier to read and maintain. We're going to show you 5 different ways to create an Excel named range.
Function: LOG10
In this guide, we’re going to show you how to use the LOG10 Excel function and also go over some tips and error handling methods.
Function: LOG
In this guide, we’re going to show you how to use the LOG function and also go over some tips and error handling methods.
Function: LN
In this guide, we’re going to show you how to use the Excel LN function and also go over some tips and error handling methods.
Function: EXP
In this guide, we’re going to show you how to use the Excel EXP function and also go over some tips and error handling methods.
How to create calculated columns in Excel tables
Excel Tables are useful in managing and analyzing data in tabular format. Let us show you how to create calculated columns in Excel tables.
Function: FACTDOUBLE in Excel
In this guide, we’re going to show you how to use the FACTDOUBLE function in Excel and also go over some tips and error handling methods.
Function: FACT
In this guide, we’re going to show you how to use Excel factorial (FACT) function and also go over some tips and error handling methods.
Function: LCM
In this guide, we’re going to show you how to use the Excel LCM function and also go over some tips and error handling methods.
Function: GCD
In this guide, we’re going to show you how to use the GCD function and also go over some tips and error handling methods.
What’s New in SpreadsheetWeb 6.10
Review What’s New in SpreadsheetWeb 6.10, including the product features, platform improvements, and workflow enhancements covered in this update.
Pagos Releases SpreadsheetWEB 6.10 with the New Queries Module to Create Database Queries without Any Coding
Introducing the ability to create database queries on the designer interface and pull data from other database tables with ease.
How to name multiple cells at once using the Create from Selection feature
Named ranges can be extremely useful in Excel models. Let us show you how to name multiple cells at once using Create from Selection feature.
Function: CEILING
In this guide, we’re going to show you how to use the Excel CEILING function and also go over some tips and error handling methods.