User Defined Functions in Excel

User Defined Functions in Excel

User Defined Functions (UDFs in short) are, as the name suggests, functions whose properties are custom defined by the user. They can be tailored to specific user needs and greatly improve productivity as they can help you do things built-in Excel features can’t. For...
Excel Database Functions

Excel Database Functions

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 model, each...
Forecasting in Excel

Forecasting in Excel

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 how to adjust...
All You Need to Know for Using Excel Iterative Calculation

All You Need to Know for Using Excel Iterative Calculation

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 getting...
How and Why of Running a Simulation in Excel

How and Why of Running a Simulation in Excel

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 respond in...
What’s New in SpreadsheetWEB 6.4

What’s New in SpreadsheetWEB 6.4

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 added a...

SpreadsheetWEB 6.4 Now Available

Cambridge, MA, September 24, 2018 –​ Pagos, Inc. today announced the release of SpreadsheetWEB 6.4 version, featuring form-based grids, and enhanced visualization capabilities through additions to the new dashboard module. The designer module that became part of the...
With Autofill Excel Shows Its Smarts and Saves You Time

With Autofill Excel Shows Its Smarts and Saves You Time

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 transferring...