Reducing Formula Errors in Excel

Reducing Formula Errors in Excel

Following certain guidelines when working in Excel can save you the headache of dealing with errors. And if something does go wrong with a formula, there are things you can still do. Let’s take a look at some recommended methods for creating formulas, and how to...
Improvements in Workbook Loading Times in Version 6.0

Improvements in Workbook Loading Times in Version 6.0

The first time that a SpreadsheetWEB application is invoked in a user session, the underlying workbook is loaded into memory on the server . This will affect the response time of the first calculation in proportion to the complexity of the workbook. Larger and more...
Performance Improvements in Version 6.0

Performance Improvements in Version 6.0

One of our primary undertakings for the SpreadsheetWEB 6.0 release was a major dedicated effort to improve the performance of our core spreadsheet calculation engine. The calculation engine was written in C++ and is optimized for server-side processing, focusing...
10 Most Useful Shortcuts in Excel

10 Most Useful Shortcuts in Excel

Although the computer mouse is an essential tool in desktop navigation, Excel power users rarely use it to interact with their workbooks. This gives them an edge to do everything far more rapidly, as there is a shortcut pretty much every action in Excel. You might be...
Excel Formulas for Beginners

Excel Formulas for Beginners

Excel is more than a grid system labeled with coordinates. Sure, it can be used as a database or a simple calculator on your desktop, but its main advantage is the ability to create complex calculation models with little effort. Formulas are the core component of...
Subscription-based Licensing of SpreadsheetWEB

Subscription-based Licensing of SpreadsheetWEB

We are happy to announce that subscription based licensing of SpreadsheetWEB server will be replacing the traditional perpetual licensing model as of February 5th, 2018. This is applicable to on-premise or server deployment scenarios – our public and private...
Power Query 101

Power Query 101

Excel is the primary data tool for many business users. However, we all know that data often comes in different forms, from different sources, and your reporting tools can be demanding as to what you can feed them. Reshaping data is often necessary for a clean...