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 · 1312 articles
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.
How to find named ranges in Excel by highlighting them using VBA
Highlighting them on your worksheets can help you identify their properties easily. Let us show you how to find named ranges in Excel.
How to lock a cell in Excel formula using VBA
In this article, we're going to show you how to lock a cell in Excel formula using VBA and prevent your users from changing formulas or data.
How and Why of Running a Simulation in Excel
Excel is commonly used to create data models and simulations. Let's examine a simulation in Excel and the tools available for this purpose.
How to un-protect a protected worksheet and vice versa - the VBA method
In this article, we're going to show you how to 'un-protect' protected worksheets and how to protect un-protected worksheets using VBA.
How to alphabetize Excel tabs using VBA
In this article, we're going to show you how to alphabetize Excel worksheets in ascending or descending alphabetical order using VBA.
Create Tables and Manipulate Data in an Instant with Excel Flash Fill
You can use the Flash fill to manipulate data quickly. Let us show you how Excel Flash Fill can save you time and drudgery.
How to unhide sheets in Excel with VBA
Learn how to unhide sheets in Excel with VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.