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 52 of 55 · 1312 articles
401k Calculator
This 401k calculator template evaluates your 401k plan position and simulates future contributions by you and your employer.
How to calculate running totals with SUM
Learn how to calculate running totals with SUM. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to Use Logic Statements in Excel: IF – AND – OR – NOT
The beauty of Excel lies in its flexibility to create any data model with little effort. Logic gates can be established within any spreadsheet element.
Working with Large Data Grids in SpreadsheetWEB Applications
Although used widely in many data models, submitting tables with significant amount of data have always been a problem in web application projects.
Crunch Data Even Faster with Excel SUMIFS Function
In this guide, we’re going to show you how to use Excel SUMIFS function and also throw in some tips and error handling methods.
Comparing the Performance of SpreadsheetWEB's Calculation Engine with Excel
Explore Comparing the Performance of SpreadsheetWEB's Calculation Engine with Excel, with a focused look at testing Methodology, testing Setup, and test Results.
Improvements in Workbook Loading Times in Version 6.0
In version 6.0, we have included significant improvements to our core engine to facilitate significantly faster initial workbook loading times.
Performance Improvements in Version 6.0
Review Performance Improvements in Version 6.0, including the product features, platform improvements, and workflow enhancements covered in this update.
Transforming a Complex Pricing List into a Quoting Tool in Excel – Part 2
In this guide, we’re going to transform a pricing list into a full blown web application that can be published and shared with other users.
Transforming a Complex Pricing List into a Quoting Tool in Excel – Part 1
In this two-part guide, we’re going to show you how you can convert that huge table into an interactive quoting tool using Excel.
Subscription-based Licensing of SpreadsheetWEB
subscription based licensing of SpreadsheetWEB server will be replacing the traditional perpetual licensing model as of February 5th, 2018.
Power Query 101 - Data Scrub and Analysis in Microsoft Excel
Power Query 101 - Data Scrub and Analysis in Microsoft Excel • This article covers an introduction on transforming data with Power Query.
CONCATENATE Function in Excel with Examples
The CONCATENATE function is used for merging multiple strings. It can take up to 255 arguments to merge them in a single cell.
Formulas for Data Analysis
We’ve compiled the most common formulas used in data analysis tasks and created this guide to give you examples as how you can use them.
How to Handle Circular References in Excel
Circular Reference means that your formula is trying to calculate the origin cell. Typically, this is considered an error, but it can actually be useful.
Here is How You Can Crunch Data of Any Size with Excel Power Pivot
Excel Power Pivot is a very powerful tool that can handle a vast amount of data, while allowing you to manage connections and manipulate data.
How to Show Formulas in Excel: A Comprehensive Guide To Maximize Formula Efficiency:
Everyone can write formulas in Excel, however it doesn't automatically translate to the ability to show 'efficient' formulas in Excel.
What's New in Version 6.0
We believe that SpreadsheetWEB has taken another big step with the designer allowing our users to easily publish and share their spreadsheets.
Pagos Announces the Release of SpreadsheetWEB 6.0 - Introducing the Designer Module
SpreadsheetWEB 6.0 was released. Introducing the all new designer module, this is one of the biggest updates the software has ever seen.
A New Dimension Building Excel Models: Array Formulas
Excel array formulas can be a bit tricky, but once you get a hang of it, you’ll to be surprised how you never heard of this powerful feature.
Dealing with Links or External References in Excel
External references can be elusive in a complicated spreadsheet, or a workbook you’re not familiar with. Finding these connections can be a daunting task.
Extract Data Quickly From Tables with Excel's SUMIF Function
Learn about extract Data Quickly From Tables with Excel's SUMIF Function in Excel, including the relevant formula or feature, setup steps, and practical usage.
Get Quick Results and Optimize Your Models With Excel Goal Seek
Goal Seek in Excel is extremely easy to use and you can compare different scenarios or analyze your model within a very short amount of time.
Handle With Care: Volatile Functions in Excel
It is recommended to use Excel's volatile function with caution if you’re not an advanced user, because they can slow down complex models!