Welcome to SpreadsheetWEB Blog
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 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
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
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...
Formulas for Data Analysis
Excel is typically one of the go to tool for business professionals when it comes to analyzing data and visualizing it. Conveniently, it supports hundreds of formulas, some of which are daily drivers for most people, and others, you may not even heard of. We’ve...
How to Handle Circular References in Excel
In Excel, you typically type in formulas to get results and it’s pretty common to reference other cells in the process. However, what happens if you reference the cell itself, either directly or indirectly? This means an infinite loop of calculations! Luckily, Excel...
Here is How You Can Crunch Data of Any Size with Excel's PowerPivot
What is it? Microsoft came up with a series of tools all have names starting with “Power”. PowerQuery and PowerBI are just two examples. PowerPivot is one of the oldest in this series and although not many people may know about it, it’s actually one of the most...
Writing Efficient Formulas
The glorified calculator that is Excel can help you build financial calculators, automate your processes, or solve complicated problems. It is safe to say that pretty much all business professionals are familiar with Excel. Although everyone can write formulas, not...
What's New in Version 6.0
Where do we even start? The software has shown tremendous expansion since its launch over a decade ago. Along with several technical enhancements, we also added a completely new way to create web applications. Enter the designer. In one of its biggest updates to date,...