How to use DAX Functions in Pivot Tables

Microsoft's data analysis tools PowerPivot, Power BI Desktop, and SQL Server Analysis Services (SSAS) Tabular models empower Excel users by allowing them better manage and transform their data. Data Analysis Expressions (DAX) is essentially a formula and query...

Utilizing Web Services in Excel Using Formulas

Excel is typically where data ends up being collected. User inputs, data exports, and even web services can provide such data. There are various tools and even some built-in Excel features that can help with this sort of operations, but nothing beats a good old...

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...
HubSpot Setup - Integrate SpreadsheetWeb applications with HubSpot

HubSpot Setup - Integrate SpreadsheetWeb applications with HubSpot

Create your HubSpot account Your HubSpot instance can be accessed via RESTful web service calls. In order to utilize HubSpot’s API, you will need to create a developer account or utilize one of the sample accounts offered to developers. In this example, we’re going to...

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

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