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 …
Course: How to Use Microsoft Excel for Data Analysis
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 …
