Common Formula Errors in Excel

Common Formula Errors in Excel

Troubleshooting issues in Excel can be easier than you might think, if you know how to interpret error messages. Error messages almost always start with a hashtag, followed by the error code. We’ve prepared this guide to help you understand the way errors are handled...
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...
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...
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...
Formulas for Data Analysis

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

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