Excel Charts & Graphs: Master Class Excel Charts & Graphs

Name: Excel Charts & Graphs: Master Class Excel Charts & Graphs
Rating: 4.1 (105 reviews)

Microsoft Excel Chart & Graphs Masterclass, Create Impressive Graphs, Infographics and reports.

Created byClick Learning

Last updated 5/2024

English

English [Auto],

What you'll learn

Understanding Chart Types
Advanced Charting Techniques
Visualizing Statistical Data
Interactive Dashboards
Adding slicers, timelines, and form controls for interactivity
Design principles for building effective dashboards
Visualizing statistical data with histograms and box plots
Implementing conditional formatting with charts

Course content

5 sections • 17 lectures • 1h 47m total length

Overview of Excel's charting tools and capabilities.5:51
Master Excel's charting tools, from column charts to pivot charts, scatter plots, and maps. Learn to customize styles, labels, and trend lines for dynamic data visualization.
Creating basic charts (column, bar, line, pie) from sample data5:01
Create basic charts in Excel from a simple dataset, including column, bar, line, and pie charts, by selecting data and using the insert tab.
Formatting chart elements (titles, axes, labels) for clarity5:56
Format chart elements such as titles, axes, and labels to improve clarity, customize data labels and grid lines, and tailor axis titles for easy interpretation of sales data.

Exploring advanced chart types (scatter, bubble, radar, etc7:56
Explore advanced Excel chart types, including scatter, bubble, radar, and waterfall charts, and learn to create, customize, and interpret these visuals for data-driven insights.
Adding trendlines, error bars, and annotations to charts5:18
Enhance charts by adding trendlines, error bars, and annotations. Learn to choose trend line types: linear, moving average, exponential, and apply standard deviations for error bars, with animations.
Working with multiple data series and axis scaling7:06
Explore creating line charts to visualize multiple product sales over time, customize data series colors, and adjust axis scaling, including using a secondary axis for clearer trends.

Applying colors, gradients, and 3D effects to charts6:07
Apply colors, gradients, and 3d effects to Excel charts to create vibrant, attention-grabbing visuals. Learn to customize charts with color fills, gradients, bevel, and shadows for polished presentations.
Using shapes and images as chart elements.6:44
Explore using shapes and images as chart elements in Excel to spice up charts. Insert shapes or logos, format data series, adjust colors and transparency.
Implementing conditional formatting with charts5:03
Explore conditional formatting with charts in Excel to dynamically highlight data based on thresholds, turning sales figures into visually informative graphics.

Visualizing statistical data with histograms and box plots4:34
Master statistical visualizations in Excel by creating histograms and box plots to understand distributions, import data, customize charts, and clearly communicate findings.
Utilizing Pivot Charts for dynamic data analysis.5:24
Master pivot charts in Excel to create dynamic data visualizations, customize fields, legend, and values, and refresh or filter data with slicers for fast, actionable insights.
Performing trend analysis and forecasting with Excel charts7:14
Explore trend analysis and forecasting with Excel charts by creating scatter plots and adding trend lines. Forecast future periods and format charts for clarity, then interpret results and update analyses.
Creating combination charts and dual-axis representations5:07
Create compelling data visuals by building combination charts with cluster column and line series, then apply a dual axis representation to clearly compare monthly product A and B sales.

Design principles for building effective dashboards7:29
Apply design principles for building effective dashboards in Excel to create simple, consistent, accessible visuals with interactive filters and clear insight.
Integrating multiple charts into a dashboard layout8:19
Learn to build a data-driven dashboard in Excel by combining bar, line, and pie charts, organizing data with named ranges, and adding slicers for interactive filtering.
Adding slicers, timelines, and form controls for interactivity7:34
Creating dynamic charts that respond to user input6:24
Create dynamic, interactive charts in excel that respond to user input via drop-down menus and data validation. Learn to set up data, insert line charts, and update charts automatically.

Requirements

You will need Microsoft Office installed on your computer

Description

Unlock the power of Excel Charts & Graphs Master Class. In today's data driven world, the ability to effectively communicate insights through compelling visualizations is a crucial skill for professionals across various industries. This course is designed to equip you with the knowledge and skills needed to create dynamic and insightful charts and graphs using Microsoft Excel.

Whether you're a novice Excel user looking to enhance your data visualization skills or an experienced professional seeking to take your charts and graphs to the next level, this course is for you. Through a combination of comprehensive lessons and real world examples, you'll learn how to transform raw data into visually stunning and impactful charts and graphs.

Topics covered in this course include:

Understanding Chart Types: Gain a deep understanding of different chart types available in Excel and learn when to use each one to effectively convey your message.
Advanced Charting Techniques: Dive into advanced techniques for customizing and fine-tuning your charts and graphs, including formatting options, axis manipulation, and trendline analysis.
Interactive Dashboards: Learn how to create interactive dashboards that allow users to explore data dynamically and gain actionable insights.
Visualizing Trends and Patterns: Discover how to use Excel's powerful data analysis tools to identify trends, patterns, and outliers in your data and visualize them effectively.
Presenting Your Insights: Master the art of presenting your insights with confidence, whether it's in a boardroom presentation, a report, or a client meeting.

By the end of this course, you'll have the skills and confidence to create professional quality charts and graphs that enhance your data driven decision making processes and effectively communicate your insights to stakeholders. Whether you're a business analyst, marketer, financial professional, or educator, Excel Charts & Graphs Master Class will empower you to unlock the full potential of Excel as a data visualization tool.

Join us and take your Excel skills to new heights!

Who this course is for:

Anyone interested in data visualization
Anyone starting out to work with Excel

Excel Charts & Graphs: Master Class Excel Charts & Graphs

What you'll learn

Explore related topics

Course content

Introduction to Excel Charts3 lectures • 17min

Intermediate Charting Techniques3 lectures • 20min

Customizing and Enhancing Charts3 lectures • 18min

Advanced Data Analysis with Charts4 lectures • 22min

Dashboard Design and Interactive Visualizations4 lectures • 30min

Requirements

Description

Who this course is for: