Power Query 101 - Data Scrub and Analysis in Microsoft Excel

Power Query 101 - Data Scrub and Analysis in Microsoft Excel

Power Query, a dynamic and robust add-in for Excel, is a game-changer for business users dealing with data. As we all know, data can come in various forms and from diverse sources, making it challenging to manage and analyze. Moreover, reporting tools often have...
CONCATENATE Function in Excel with Examples

CONCATENATE Function in Excel with Examples

Data management within Excel spreadsheets often involves dealing with unorganized data that needs restructuring before it can be effectively used in reports or calculations. This is particularly evident when working with data from various sources or tools in different...
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...
Here is How You Can Crunch Data of Any Size with Excel Power Pivot

Here is How You Can Crunch Data of Any Size with Excel Power Pivot

What is Excel Power Pivot? Welcome to our easy-to-follow guide on Excel Power Pivot! This guide is perfect for anyone who wants to make the most out of Excel for business intelligence and data analysis. Power Pivot is an incredible tool in Excel that helps you work...
What's New in Version 6.0

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,...
A New Dimension Building Excel Models: Array Formulas

A New Dimension Building Excel Models: Array Formulas

Excel's array formulas are a fascinating feature that can revolutionize your spreadsheet calculations. While many users may not have explored these formulas, they offer powerful capabilities, replacing multiple formulas in certain scenarios. Array formulas operate on...