What’s New in SpreadsheetWeb 6.3

What’s New in SpreadsheetWeb 6.3

Dashboards have always been an integral part of SpreadsheetWEB. The software ships with its own built-in data visualization platform. Visualizing the data you collect with your web applications, then creating reports has always been an appealing bonus. We then...
3D References in Excel

3D References in Excel

3D references are special use of Excel ranges that refer to the same cell or range through multiple sheets. The third dimension, being across sheets, can be seen like a z-axis. 3D references are great for consolidating data from similarly built sheets. For example,...
Integrate SpreadsheetWeb with SalesForce

Integrate SpreadsheetWeb with SalesForce

This tutorial demonstrates how to integrate SpreadsheetWEB with SalesForce API to push data into SalesForce database. Create your Salesforce Account To build a Salesforce application, the first thing you’re going to need is a Salesforce account. If you don’t have one...
How to reduce file size of your Excel workbooks

How to reduce file size of your Excel workbooks

In addition to transportation disadvantages, a large Excel file is typically the culprit for performance drops when you’re opening, calculating, or saving a spreadsheet. If your file suddenly increased from KBs to MBs, it might be a good idea to troubleshoot for...
Excel Case Statements: SWITCH Function Versus Nested IF

Excel Case Statements: SWITCH Function Versus Nested IF

Excel case statements can be handled with either SWITCH function or nested IF statements. A popular use for the IF function is creating nested formulas that can check for various criteria. However, nested IF statements can get pretty complicated and cumbersome when...
Excel Named Ranges

Excel Named Ranges

Users of all levels have different feelings about Excel named ranges. Some find them cumbersome, while others use them religiously. In addition to allowing quick access to complex references, named ranges can make your formulas a lot easier to read and maintain. Once...