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 · 1312 articles
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.
Why Insurance Companies should embrace Spreadsheets-as-a-Backend to transform the way they program business logic
These are only a few of the insurance organizations that we have helped utilize the Spreadsheets-as-a-Backend methodology.
Function: LOWER
The LOWER function converts a text into lowercase. In this guide, we’re going to show you how to use the this function using examples.
Function: UPPER
The UPPER function converts a text to uppercase. In this guide, we’re going to show you how to use the UPPER function.
How to delete named range Excel using VBA
Managing and removing named ranges in Excel can be challenging. Let's show you how to delete named range Excel using VBA with one click.
How to allow Excel uppercase characters only
Data validation can help streamline entry process. Let us show you how to allow Excel uppercase characters only, using Data Validation.
How to prevent Save As with VBA
Learn how to prevent Save As with VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
Function: IF
In this guide, we’re going to show you how to use the IF function along with some tips and error handling methods.