Welcome to SpreadsheetWEB Blog

Database functions are designed to perform simple operations on data that is in a “database-like structure”. Database-like structure means that the data must be in a table structure that has organized records with labels and appropriate separation. In this...

What is Forecasting? Forecasting is a technique to establish relationships and trends which can be projected into the future, based on historical data and certain assumptions. This method can be utilized to better understand and make an educated guess on...

Iterative calculations can help find the solution to mathematical problems by running calculations over and over using previous results. This is made possible by computers that can run calculations repeatedly to find the likelihood of possible answers by...

A simulation is commonly defined as an imitation of a situation or process. This typically entails creating a mathematical model that represents the characteristics and other features of a system. The model then can be used to simulate how the system will...

Being able to create large data sets that follow a certain pattern in an instant truly is a miracle, that comes in the form of Autofill. Even without any in-depth knowledge of it, most Excel users benefit from it at some point during their tenures. Flash...

Input grids are inherently challenging to work with when it comes to web applications. Limited real estate on mobile device screens, and the lack of appropriate controls make it hard for users to enter data into large tables. In SpreadsheetWEB 6.4, we’ve...

Autofill is an essential feature that any Excel user must be constantly using as it saves tremendous amount of time when creating spreadsheets. The capabilities of this feature range from simple copy-paste tasks to automatically creating entire tables, or...

One of the most versatile features of Excel that is data validation can validate user entries based on rules set by you. With this feature, you can impose strict rules on cells where users can’t enter any invalid data, or display warning messages to make...

Sorting data in Excel is a crucial part of organizing it for analysis or presentation. What if you want to order data in a different way, say “New York” first, and then “California”, and another state?  One size may not always fit all as data can come in...