Build a Business Dashboard using Excel Pivot Tables

Course

Online

£ 10 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

As a Business user, you might often feel overwhelmed by the number of requests you can handle at a time. Sometimes you wished there were more hours in a day to work them out correctly and at the same time provide insights.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

In this Pivot Table series for Power Business users, you will learn smart tips and tricks to get to a solution quickly using Excel Pivot tables and semi-automate your reporting to answer same questions faster in the future repeatedly. Also, obviously we will learn how to build Dashboards which are easy to build and simple to use

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Using excel
  • Excel

Course programme

Introduction 1 lecture 01:09 Let's get started Course overview to get you started. Introduction 1 lecture 01:09 Let's get started Course overview to get you started. Let's get started Course overview to get you started. Let's get started Course overview to get you started. Let's get started Course overview to get you started. Let's get started Course overview to get you started. Course overview to get you started. Course overview to get you started. Warming up your basics 4 lectures 27:50 Manual Grouping preview Time Series Data Dynamically Update Pivot Tables Create Histogram Warming up your basics 4 lectures 27:50 Manual Grouping preview Time Series Data Dynamically Update Pivot Tables Create Histogram Manual Grouping preview Manual Grouping preview Manual Grouping preview Manual Grouping preview Time Series Data Time Series Data Time Series Data Time Series Data Dynamically Update Pivot Tables Dynamically Update Pivot Tables Dynamically Update Pivot Tables Dynamically Update Pivot Tables Create Histogram Create Histogram Create Histogram Create Histogram Moving up to useful tricks 2 lectures 23:57 Calculated Fields Calculated Items Moving up to useful tricks 2 lectures 23:57 Calculated Fields Calculated Items Calculated Fields Calculated Fields Calculated Fields Calculated Fields Calculated Items Calculated Items Calculated Items Calculated Items Moving on to Dashboard Stuff 2 lectures 17:26 Create Month/Year and Add Slicers Build Dashboard on COVID Data Moving on to Dashboard Stuff 2 lectures 17:26 Create Month/Year and Add Slicers Build Dashboard on COVID Data Create Month/Year and Add Slicers Create Month/Year and Add Slicers Create Month/Year and Add Slicers Create Month/Year and Add Slicers Build Dashboard on COVID Data Build Dashboard on COVID Data Build Dashboard on COVID Data Build Dashboard on COVID Data Finish 1 lecture 00:45 Congratulations on Making your Dashboard Finish 1 lecture 00:45 Congratulations on Making your Dashboard Congratulations on Making your Dashboard Congratulations on Making your Dashboard Congratulations on Making your Dashboard Congratulations on Making your Dashboard

Additional information

For this session, you need to know how to use Function on Excel and should know about where the the options to insert Pivot tables is placed. Rest all you will learn during the session

Build a Business Dashboard using Excel Pivot Tables

£ 10 + VAT