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 44 of 55 · 1312 articles
Function: TODAY
In this guide, we’re going to show you how to use the TODAY function and also throw in some tips and error handling methods.
How to add a custom button to Excel Ribbon
This article shows how to add a custom button to Excel Ribbon in 2010 or newer versions.
Function: N
In this guide, we’re going to show you how to use the N function and also throw in some tips and error handling methods.
Function: OR
In this guide, we’re going to show you how to use the Excel OR function and also go over some tips and error handling methods.
Function: AND
In this guide, we’re going to show you how to use the Excel AND function and also go over some tips and error handling methods.
How to show named ranges that were made hidden using VBA
Hidden named ranges can be tricky to find and work with. Let us walk you through how you can show named ranges that were hidden using VBA.
Function: AVERAGEIF
In this guide, we’re going to show you how to use the AVERAGEIF function and also throw in some tips and error handling methods.
Function: COUNTIF
In this guide, we’re going to show you how to use the COUNTIF function and also go over some tips and error handling methods.
How to insert a degree symbol in Excel
Standard keyboards don’t have a button for this useful symbol.Let us show you 4 different ways on how to insert a degree symbol in Excel.
How to insert a check mark in Excel
A check mark is the universal character for confirmation. In this article we listed 5 methods you can use to to insert a check mark in Excel.
Rent vs Buy Calculator
Rent vs Buy Calculator provides a practical spreadsheet model. This overview explains what it calculates and how it can be used with SpreadsheetWeb.
Column Chart in Excel: Everything You Need to Know
Excel, being the go-to software for all data tasks supports all kinds of bar and column charts with extensive customization options.
How to format numbers in Excel with millions separators
In this article, we're going to show you how to format numbers in Excel with million separators without changing the actual values.
How to format numbers in thousands in Excel
In this article, we're going to show you how to format numbers in Excel with thousands separators without changing actual values.
Function: SEARCH
In this guide, we’re going to show you how to use the SEARCH function and also throw in some tips and error handling methods.
Function: FIND
In this guide, we’re going to show you how to use Excel FIND function and go over some tips and error handling methods.
What’s New in SpreadsheetWeb 6.6
This update brought many new features for helping our users do more with their designer and dashboard applications, and in the control panel.
Pagos Has Just Released SpreadsheetWEB 6.6 Bringing New Features to the Designer and Dashboard Applications
Pagos, Inc. has today announced the release of the SpreadsheetWEB 6.6 version with new additions to the dashboard and designer modules.
Multi-Level Header Support for Designer Applications
Follow the Multi-Level Header Support for Designer Applications with a focused overview of the required setup, configuration steps, and expected result.
Print Process in Designer Applications
This tutorial walks you through the entire print process in the designer which can generate PDF or Word exports from templates.
How to make Excel delete rows with value of your choosing using VBA
In this article, we're going to show you how to make Excel delete rows with value of your choosing using VBA.
Life Savings (or Losses) by Changing Product Brands
This life savings calculator will open your eyes to how much of a difference can buying cheaper or more expensive products can make.
Use Excel for Regression Analysis to Make Better Predictions
Excel can solve linear regression analysis problems using the least squares method. Linear regression assumes a linear correlation.
Mortgage Calculator
This mortgage calculator can help you easily compare rates from various lenders, or just get a better idea about what you can buy.