by Adam | Jan 23, 2018 | Blog
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...
by Adam | Jan 5, 2018 | Blog
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...
by Adam | Dec 15, 2017 | Blog
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...
by Adam | Dec 4, 2017 | Blog
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...
by Adam | Nov 20, 2017 | Blog
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...
by Adam | Nov 7, 2017 | Blog
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,...
by Adam | Nov 3, 2017 | Blog
Excel’s array formulas are indeed a fascinating subject. Although they can be very useful by making it possible to solve some complex calculations, and replace hundreds of formulas in certain situations, most Excel users have probably never used these formulas before...
by Adam | Sep 7, 2017 | Blog
A good grasp on Excel functions can enhance your ability to perform day to day business tasks. Although there are hundreds of formulas in Microsoft Excel’s repertoire, most users only ever use a handful of them and you probably won’t ever need to use most of them. We...
by Adam | Aug 16, 2017 | Blog
Advanced Excel users often utilize external links or workbook connections to save data or referencing. External links can be hard to detect in a complicated spreadsheet, or a workbook you’re not familiar with. Finding these connections manually one by one can be a...
