Tutorialspoint

Excel Pivot Tables and Dashboard. Simple & Quick tutorial!

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

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!

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.
Show More

Curriculum

  • Introduction
    00:46
    Preview
  • Preparatory Tips- Entries, Formatting and Tables
    18:48
  • Basic tips for Dashboards
    07:48
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Excel Pivot Tables and Dashboard. Simple & Quick tutorial!
This Course Includes
  • 58 mins
  • 7 Lectures
  • 1 Resources
  • Completion Certificate
  • Lifetime Access
  • 30-Days Money Back Guarantee

Sample Certificate

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

We have 30 Million registgered users and counting who have advanced their careers with us.

X

Sample Certificate