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 46 of 55 · 1319 articles
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.
How to create an Excel histogram
A histogram is a visual representation of numerical data distribution, giving you the big picture. Let's see how an Excel histogram works.
Creating Interactive Content for Marketing
Interactive calculators are one of the most effective way of generating traffic and leads to your website Most businesses create interactive calculators in Excel.
What’s New in SpreadsheetWeb 6.5
We had introduced a brand-new reporting and analysis tool. Now, the new Dashboard is leaving Beta to consolidate dashboards.
SpreadsheetWEB 6.5 Consolidates Dashboard Tools
Pagos today announced the release of SpreadsheetWEB 6.5 version, featuring new capabilities for the dashboard and designer applications.
Creating a Complex Questionnaire with Calculations
SpreadsheetWEB can help you tap into your Excel expertise and transform a complicated questionnaire into web applications in no time.
How to find in Excel if cell is blank using VBA
In this article we're going to show to find in Excel if cell is blank using VBA and automate this process.
User Defined Functions in Excel
User Defined Functions (UDFs in short) are functions whose properties are custom defined and can be tailored to specific user needs.
How to line up decimals in Excel using Number Formatting
Finance setting requires displaying numbers in a certain way. Let us show you how to line up decimals in Excel using Number Formatting.
Excel Database Functions
For data that is 'database' structure, you can use Excel database functions to manipulate and manage your tables much more efficiently.
How to make Excel capitalize first letter using VBA
To save time or for the sake of laziness, you find data in uppercase or lowercase. Let's show you how to make Excel capitalize first letter.
How to convert selection to Excel lowercase using VBA
Learn how to convert selection to Excel lowercase using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
Forecasting in Excel
Forecasting in Excel can help you establish relationships and trends which can be projected into the future.
How to make Excel change case to uppercase using VBA
Changing lowercase characters into uppercase is a tedious task to do manually. Let's show you how to make Excel change case to uppercase.
How to remove characters in Excel using VBA
Although you can replace characters with Find & Replace, we will show you how to remove characters in Excel using VBA to automate it.
How to have Excel convert formula to value using VBA
In this article, we're going to show you how to have Excel convert formula to value using VBA, to protect your formulas.
All You Need to Know for Using Excel Iterative Calculation
You can reference a cell that contains a formula and use its result again. A better way to do this is using Excel iterative calculation.
How to compare two rows in Excel using VBA
Learn how to compare two rows in Excel using VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.