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 40 of 55 · 1312 articles
Function: FLOOR
In this guide, we’re going to show you how to use the Excel FLOOR function and also go over some tips and error handling methods.
Function: CEILING.MATH
In this guide, we’re going to show you how to use the CEILING MATH (CEILING.MATH) function and go over some tips and error handling methods.
How to Get Excel Stock Quotes
In this article, we are going to show how to get Excel stock quotes, along with tips and tricks about the new Data Types feature.
Function: FLOOR.MATH
In this guide, we’re going to show you how to use the FLOOR MATH (FLOOR.MATH) function and also go over some tips and error handling methods.
Function: INT
In this guide, we’re going to show you how to use the INT function and also go over some tips and error handling methods.
Function: TRUNC
In this guide, we’re going to show you how to use the Excel TRUNC function and also go over some tips and error handling methods.
How to get top values from a list or a table in Excel
In this article, we are going to show you how to get top values from a list or a table in Excel with using new SORT and SEQUENCE formulas.
How to Generate a General Ledger (GL) List using SEQUENCE
Preparing a general ledger (GL) table can be a daunting task, especially when dealing with lots of category codes.
How to generate a date list using the SEQUENCE function
In this guide, we’re going to show you how to generate various date list for days, months, and years using the SEQUENCE function.
Function: TRANSPOSE
In this guide, we’re going to show you how to use TRANSPOSE Excel function and also go over some tips and error handling methods.
Stock Charts (Candlestick) in Excel
Learn about stock Charts (Candlestick) in Excel in Excel, including the relevant formula or feature, setup steps, and practical usage.
Function: CONCATENATE
In this guide, we’re going to show you how to use the CONCATENATE Excel function and also go over some tips and error handling methods.
Function: TEXTJOIN
In this guide, we’re going to show you how to use the TEXTJOIN Excel function and also throw in some tips and error handling methods.
Surface Chart in Excel
Learn how Surface Chart in Excel works, including its structure, available chart types, and the steps for creating it in Excel.
Excel Function: SUBSTITUTE
In this guide, we’re going to show you how to use the Excel SUBSTITUTE function and also go over some tips and error handling methods.
How to Use Excel SMALL Function
In this guide, we’re going to show you how to use the Excel SMALL function and also go over some tips and error handling methods.
How to Add Secondary Axis in Excel and Create a Combination Chart
A combination chart can visualize mutliple data fields in a single chart area. Let us show you how to add a secondary axis in Excel.
How to filter by using a formula in Excel
In this guide, we’re going to show you how to filter by using a formula in Excel.
Excel TRIM Function
In this guide, we’re going to show you how to use the Excel TRIM function and also go over some tips and error handling methods.
Radar Chart in Excel
Learn how Radar Chart in Excel works, including its structure, available chart types, and the steps for creating it in Excel.
How To Use Random Number Generator in Excel
In this guide, we’re going to show you how to use random number generator in Excel with RAND, RANDBETWEEN and RANDARRAY functions.
What’s New in SpreadsheetWeb 6.9
In this update, we focused on giving our users a more transparent platform, and added support for dynamic array formulas.
Pagos Announces the Release of SpreadsheetWEB 6.9 Introducing Support for Dynamic Array Formulas
SpreadsheetWEB version 6.9 is now supporting dynamic array formulas and allowing users to download their information with one click.
Function: CODE
In this guide, we’re going to show you how to use CODE function and also throw in some tips and error handling methods.