Excel Pivot Tables and Dashboard: Simple & Quick Course!
Welcome to this easy 1-hour course on Excel Pivot charts and Dashboards
Office Productivity,Microsoft,Excel
Lectures -7
Resources -1
Duration -58 mins
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
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.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction and Preparatory tips
3 Lectures
- Introduction 00:46 00:46
- Preparatory Tips- Entries, Formatting and Tables 18:48 18:48
- Basic tips for Dashboards 07:48 07:48
Pivot Tables and Charts
2 Lectures
Dashboard
2 Lectures
Instructor Details
Praharsh Chaubey
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now