## Comparing Year-Over-Year Values Using the SUMIFS Function

Now that you’re familiar with the comparison of data using the pivot table, let’s look at the SUMIFS function in Excel and how it can be used to compare year-over-year …

## Comparing Year Over Year Values Using the Pivot Table

In the previous section, we experimented with calculated columns and conditional formatting as a way to analyse data and find anomalies in the data. Although the Pivot is a useful …

## Profitability Analysis and Finding Anomalies

Up to now, we have mostly explored ways to use Excel to present data. Excel is also a useful tool for analysing data. When using calculated fields in pivot tables …

## Basic Dashboarding Using Pivot Tables and Pivot Charts

In the previous step, you experimented with pivot tables by summarising data from your Excel table, and you’ve learned that pivot tables are great for summarising large quantities of data. …

## Creating Dashboards with Slicers

Last week, we discovered how to organise our data in dashboards. In this step, we return to dashboards and explore additional features for building dashboards. Filtering Dashboards At times you …

## Advanced Capabilities of Pivot Tables and Slicers

Now that you have the basics covered in how to manage your data using pivot tables, it is time to kick it up a notch and explore some of the …

## Excel Tables and Features

In this article, you’ll explore Excel tables and their associated features. Excel tables An Excel table is not just any range of data with headings. It is a specific object …

## Introduction to Basic Pivot Tables

When you’re dealing with a large quantity of data that needs summarising, you can make use of the pivot table feature in Microsoft Excel. Let’s start with a simple definition. …

## Reporting Data in Excel

Microsoft Excel has a vast number of features and is a valuable spreadsheet programme for many businesses. Microsoft Excel is a powerful reporting tool that allows you to do mass …

## How to Import Data from Different Sources

In this video step, you will discover how to import data from different sources and how to integrate the imported data with the excel data using data models and functions …

## Reporting Hierarchical Data

In previous sections, we looked at pivot tables and created dashboards using our pivot tables. We even used our pivot tables to compare and summarise our data. What we have …