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