Skip main navigation

£199.99 £139.99 for one year of Unlimited learning. Offer ends on 28 February 2023 at 23:59 (UTC). T&Cs apply

Find out more

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 …

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 …