Microsoft Excel: Pivot Tables to Dashboard- Beginner's Guide

Learn how to use Microsoft Excel Pivot Tables in simple step-by-step tutorials that will take you from zero to creating
4.74 (25 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Microsoft Excel: Pivot Tables to Dashboard- Beginner's Guide
105
students
6 hours
content
Jun 2022
last update
$19.99
regular price

What you will learn

The course gives you a comprehensive understanding of Excel Pivot Tables, Excel Pivot Charts and interactive Excel Dashboards.

How to use Pivot Tables to quickly and easily analyze large sets of Data.

Clear simple step by step tutorials, delivered in a bite sized lectures for easy reference later.

Create valuable insights for your company through reports and charts.

Improve your data analytical skills, even if you are starting from a zero level.

Lifetime access to course material .

Understand the anatomy of Pivot Tables.

How to use Slicers and Timelines to create interactive Excel reports.

Efficiently handling continuous updates to your source Data.

Customizing your Pivot Tables to reflect your Company's brand.

How to sort, filter and group Data with Pivot Tables.

How to visualize your data through Pivot Charts

How to create calculated fields and calculated Items.

How to use one of the powerful tools in Microsoft Excel - Conditional formatting.

How to construct interactive Dashboard that are user friendly.

A lot of Pivot Tables tips and tricks that you can show off at work.

Download all the data files used through out the course, so you can practice what you learn on the spot.

Screenshots

Microsoft Excel: Pivot Tables to Dashboard- Beginner's Guide - Screenshot_01Microsoft Excel: Pivot Tables to Dashboard- Beginner's Guide - Screenshot_02Microsoft Excel: Pivot Tables to Dashboard- Beginner's Guide - Screenshot_03Microsoft Excel: Pivot Tables to Dashboard- Beginner's Guide - Screenshot_04
Related Topics
4142120
udemy ID
6/23/2021
course created date
6/15/2022
course indexed date
Bot
course submited by