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 45 of 55 · 1319 articles
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.
College Savings Calculator
This college savings calculator will tell you exactly what amount you need to put aside when you enter your kid’s details.
Developing a Life Insurance Quoting Software with SpreadsheetWeb
Life Insurance Quoting Software development is challenging task. SpreadsheetWeb makes it easy by eliminating coding.
Inserting PandaDoc Electronic Signature into Word Documents Used in SpreadsheetWeb Applications
This tutorial explains how you can embed electronic signatures into those documents using PandaDoc electronic signature REST API.
Inserting Adobe Sign Electronic Signature into Word Documents Used in SpreadsheetWeb Applications
This tutorial explains how you can embed electronic signatures into those documents using Adobe Sign electronic signature REST API.
Inserting DocuSign Electronic Signature into Word Documents Used in SpreadsheetWeb Applications
This tutorial explains how you can embed electronic signatures into those documents using DocuSign electronic signature REST API.
Function: MID
In this guide, we’re going to show you how to use the Excel MID function and also go over some tips and error handling methods.
Excel Function: RIGHT
In this guide, we’re going to show you how to use the Excel RIGHT function and also go over some tips and error handling methods.
Function: LEFT in Excel
In this guide, we’re going to show you how to use the Excel LEFT function and also go over some tips and error handling methods.
How to delete all comments in Excel using VBA
Excel, just like other Office products, supports comments. Let us show you how to delete all comments in Excel using VBA.
Actuarial Models in Excel
Actuarial models one of the most common usages of Excel to build complex mathematical models and test them under various conditions.
Create an Excel Heat Map
In this guide, we’re going to show how you can create a dynamic Excel heat map with Conditional Formatting for better presentation.
How to delete Excel shapes (AutoShapes) using VBA
Excel, just like other Office products, supports AutoShapes. This article shows you how to delete Excel shapes (AutoShapes) using VBA.
Function: DATE
In this guide, we’re going to show you how to use the DATE function in Excel and also go over some tips and error handling methods.
How to make Excel delete all pictures
Deleting images can be time consuming in large workbooks. Let us show you how to make Excel delete all pictures automatically using VBA.
How to remove hyperlink in Excel quickly using VBA
Hyperlinks can often become nuisance. In this article, we're going to show you how to remove hyperlink in Excel quickly using VBA.
Function: DAY
In this guide, we’re going to show you how to use the DAY function in Excel and also include some tips and error handling methods.
How to make Excel update links using VBA
Excel doesn't automatically update any external links in your workbooks. Let's show you how to make Excel update links automatically.