Tutorialspoint

This Black Friday, Get lowest Price Ever! Use: BFS8

Excel Pivot Tables and Dashboard: Simple & Quick Course!

person icon Praharsh Chaubey

4.4

Excel Pivot Tables and Dashboard: Simple & Quick Course!

Welcome to this easy 1-hour course on Excel Pivot charts and Dashboards

updated on icon Updated on Sep, 2024

language icon Language - English

person icon Praharsh Chaubey

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -7

Resources -1

Duration -58 mins

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Are you confused about where to start with Excel? Does it seem too vast and tough to understand? Or maybe you can't find enough time to make sense of it? 

Welcome to this easy 1-hour course on Excel Pivot charts and Dashboards. 

Today data is everywhere and its effective analysis is in prime demand. This is where MS Excel comes in and I don't want you to be left out! So here's a quick and simple course to get you going with Pivot analysis and Dashboards. 

I will cover data entry, basic math, making and using data tables, basic conditional formatting and its use with checkboxes, and finally dashboards. 

So find the data table I will use in the resources section of the first introduction lecture and practice along with me. Any version of Excel since 2010 will suffice.

Note that these will give you a quick idea, enabling you to do impressive visual data analysis with Microsoft Excel in a short time. Also, Pivot charts are not only interesting and help in easy data analysis, but specifically in high demand and are surely here to stay. 

So whether you are a beginner or looking to polish your visual data analysis skills, this course will help you. But there's a lot more in Excel that I'll cover in further courses. So keep learning and practicing further to learn useful advanced features but this course will surely give you a shortcut to effective data analysis with Excel.

Remember to give a good rating if you like it. Also, give me any suggestions and ask me any questions related to this course. I will make improvements/replies soon. So what's the delay?

Enroll now and let's get into this!

Goals

  • Excel pivot charts and tables
  • Excel dashboards
  • Basic data analysis reports with Excel

Prerequisites

  • Basic knowledge of computers and MS Excel 2010 or beyond is all that you need for the entire course.
Excel Pivot Tables and Dashboard: Simple & Quick Course!

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction and Preparatory tips
3 Lectures
  • play icon Introduction 00:46 00:46
  • play icon Preparatory Tips- Entries, Formatting and Tables 18:48 18:48
  • play icon Basic tips for Dashboards 07:48 07:48
Pivot Tables and Charts
2 Lectures
Tutorialspoint
Dashboard
2 Lectures
Tutorialspoint

Instructor Details

Praharsh Chaubey

Praharsh Chaubey

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515