Master Excel Charts and Pivot Tables

Name: Master Excel Charts and Pivot Tables
Rating: 4.6 (27 reviews)

Excel Like a Pro: Become a Charting and Pivot Table Expert in No Time

Created byAnimesh Pandey

Last updated 5/2023

English

English [Auto],

What you'll learn

Participants will be able to create and format a range of chart types in Excel, including line, bar, pie, scatter, and combination charts.
Participants will be able to use pivot tables to summarize and analyze large datasets in Excel. They will learn how to create pivot tables from scratch.
Participants will be able to effectively communicate insights and trends from data using Excel charts and pivot tables.
Participants will be able to manipulate data using Pivot tables and also customize Pivot tables per their needs

Course content

13 sections • 36 lectures • 8h 6m total length

Introduction to data set17:33
The file -"Excel-Charts' contains the demo files used for explaining several charts but not all. The demo files used for other excel charts have been enclosed in the relevant chapters

Revamp Your Charts: Must-Know Formatting Tips1:28
Effortless Excel Chart Formatting: Learn with Video15:23
Learn to format Excel charts by managing category and value axes, selecting 2D and 3D chart types, and adding axis titles, data labels, a data table, grid lines, and legends.
Chart Design and Format Axis: What You Need to Know0:55
Excel Charts Demystified: Watch and Learn22:00
Explore how to refine Excel charts with quick layouts, data labels, and design options, switch rows and columns, adjust data selection, chart types, and axis formatting.
Excel Format Axis: Mastering the Art (Continued)24:51
Learn to format excel axes and manage multi-series charts by adding a secondary axis, adjusting range and major/minor units, inserting tick marks, and tuning gap width to reduce overlap.

Charting the Course: Essential Takeaways on Pie and Doughnut Charts in Excel0:34
Learn Excel Pie Charts with Engaging Video Lessons19:43
Master Excel charts and pivot tables by learning to create and interpret pie charts in Excel, visualize relative proportions, and use pie of pie for two-level data analysis.
Visualize Data Like a Pro with Expert Video Lessons on Pie and Doughnut Charts9:31
Explore Excel charts by visualizing data with pie charts, pie of pie variants, and donut charts; learn to adjust angle, explosion, hole size, and data labels for clear visualization.
"Slice and Analyze: Excel Pie and Doughnut Chart Assignment with Guided Answers

Essential Takeaways for Treemap and Sunburst Charts0:31
Unleash the Power of Treemap, Sunburst, and Combo Charts with Video lesson21:01
Learn to build and compare combo charts in Excel 2016 and visualize hierarchical data with treemap and sunburst charts, using mutual funds asset under management as examples.
Mastering the Art of Combo Charts in Excel0:56
Unleash Your Creativity with assignments on Treemap and Sunburst charts

Mastering Box and Whisker Charts: Critical Considerations for Excel Users0:33
Transform Your Data with our Box and Whisker Chart Video Tutorial9:41
Master Excel box and whisker charts to visualize temperature distributions across weekdays, interpreting quartiles, mean, median, and min–max values with inclusive or exclusive median options.
Unleashing Insights: Mastering Box and Whisker Charts for Data Analysis

From Scatter to Bubble: Excel Charting Essentials0:32
Become a Scatter Plot Pro with Video Lesson19:14
Explore scatter plots to reveal the relationship between sales and expenses, highlighting patterns and outliers. Learn to add a linear trend line and r-squared value in Excel to gauge correlation.
Bubble into Excel Charts: Learn with Captivating Video Lesson26:16
Explore bubble charts in Excel to analyze how market capitalization (bubble size) influences the relationship between sales and expenses, using data labels, axis formatting, and trend lines.
Applying Knowledge from Video Lessons

Excel Charts That Wow: Discover the Secrets of Waterfall, Funnel, and Sparklines2:01
Master charts with engaging video lessons on Waterfall, Funnel, and Sparklines25:01
Explore waterfall, funnel, and sparklines to visualize sales, expenses, and income flows. Learn how to construct and interpret these charts, set totals, and compare trends across datasets.
Chart Your Course: Waterfall and Funnel Insights
Sparkline Challenge: Apply Your Excel Skills

Requirements

Basic knowledge of Microsoft Excel: Participants should have a basic understanding of Microsoft Excel, including how to create and edit worksheets, use formulas and functions, and format data.
Access to Microsoft Excel: Participants should have access to a version of Microsoft Excel that supports chart and pivot table features, such as Excel 2016 or later for Windows or Excel 2016 or later for Mac.

Description

Welcome to the comprehensive course on Excel Charts and Pivot Tables! This course is designed to equip you with the skills and knowledge necessary to create dynamic and visually appealing charts and pivot tables in Excel 2016.

With video lessons, demo files, and assignments covering all Excel features in these areas, this course provides a hands-on learning experience that is sure to enhance your Excel proficiency. Whether you are a beginner or an advanced user, this course will help you develop the skills you need to create impressive charts and pivot tables that can effectively convey your data.

It is important to note that this course has been specifically created using Excel 2016. While the principles and concepts taught in this course are applicable to other versions of Excel, there may be some differences in the user interface and functionality. However, this course will provide a solid foundation in Excel charting and pivot table creation that can be easily applied to other versions of Excel.

In this course, you will learn how to create a variety of chart types including bar charts, line charts, scatter plots, and more. You will also learn how to customize your charts to suit your specific needs, including formatting and adding data labels. Additionally, this course will cover pivot tables in depth, including how to create them, manipulate them, and use them to analyze data.

By the end of this course, you will have the skills and knowledge necessary to confidently create dynamic charts and pivot tables in Excel 2016. So, whether you are looking to enhance your Excel skills for personal or professional development, this course is the perfect choice for you.

Who this course is for:

Business analysts and data analysts who need to summarize and analyze large datasets and communicate insights to stakeholders
Managers and executives who need to make data-driven decisions and understand trends and patterns in business data
Researchers and academics who need to analyze and visualize research data in Excel.
Financial professionals who need to create financial reports and analyze financial data in Excel.
Marketing professionals who need to analyze marketing data and create marketing reports
Students and educators who need to analyze data for research, projects, or assignments
Any individual who wants to improve their Excel skills and learn how to create effective charts and pivot tables to visualize and communicate data

Master Excel Charts and Pivot Tables

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 18min

Column and Bar charts2 lectures • 29min

Chart design and formatting5 lectures • 1hr 5min

Line And Area Charts2 lectures • 24min

Pie and Doughnut charts3 lectures • 30min

Treemap and sunburst charts3 lectures • 22min

Histogram and Pareto Charts2 lectures • 27min

Box and Whisker Charts2 lectures • 10min

Scatter Plot and Bubble Charts3 lectures • 46min

Waterfall Charts Funnel Charts and Sparklines2 lectures • 27min

Requirements

Description

Who this course is for: