Excel Pivot Tables and Dashboard. Simple & Quick tutorial!

person icon Praharsh Chaubey

Excel Pivot Tables and Dashboard. Simple & Quick tutorial!

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

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Praharsh Chaubey

architecture icon Office Productivity,Excel Pivot


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

Are you confused where to start with Excel? Does it seem too vast and tough to understand? Or maybe you can't find enough time for making 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 wether 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/reply soon. So what's the delay?

Enroll now and let's get into this!


What will you learn in this course:

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


What are the prerequisites for this course?

  • 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 tutorial!


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
2 Lectures

Instructor Details

Praharsh Chaubey

Praharsh Chaubey

Professional content writer and marketer with MBA in IT.

I am a professional content writer and digital marketer with the qualification of PGDM in Information Technology. I'm here to share my knowledge and experience with the world with high quality online courses...

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

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
People having fun around a laptop

Online Certifications

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

Explore Now
People having fun around a laptop

Talk to us