Charts and Graphs: Learn Excel 365
Transform data into clear, engaging visuals in Excel 365 with professional chart creation and customization skills.
Charts and Graphs: Learn Excel 365
Charts and Graphs: Learn Excel 365 teaches you how to turn raw data into engaging, professional visuals that communicate your message. You will learn to create various chart types, from basic column and pie charts to advanced options like radar, surface, bubble, and candlestick charts. This course walks you through selecting the right data, choosing the most effective chart type, and customizing designs to enhance clarity and storytelling.
You’ll explore practical techniques such as linking chart titles to worksheet data for automatic updates, ensuring your visuals always reflect the most current information. The course also covers enhancing charts with illustrations, icons, arrows, and text boxes to highlight key insights.
Through step-by-step guidance, you’ll see how to use area charts to track trends, radar charts to compare multiple categories, and surface charts to visualize smaller datasets with precision. You’ll also gain skills in building bubble plots to show relationships between three variables and candlestick charts to analyze stock market data.
By the end of the course, you’ll be able to select the best chart type for your data, customize it for maximum impact, and present it in a way that engages and informs your audience. These skills will help you create impactful reports, data-driven presentations, and clear visual narratives that improve understanding and decision-making.
In this course, you will learn how to:
- Create Excel charts from diverse datasets.
- Customize Excel charts using design tools.
- Dynamically link Excel chart titles to data.
- Interpret and create effective area charts.
- Build and format professional surface charts.
- Generate insightful radar charts for comparison.
- Create effective bubble charts for data analysis.
- Build dynamic candlestick charts for stock data.
- Improve data visualization for better storytelling.
- Add graphics and text to enhance the chart's impact.
- Analyze trends using area and candlestick
charts.
Course Format
- This is a video-led course. You can preview some videos below.
- This course includes practice exercises.
- This course is aimed at PC Excel users.
Course Certificate Included
This course includes an optional online quiz that will generate a course certificate upon completion.
14-Day Guarantee
We offer an unconditional, 14-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your Stream Skill purchase. If you don’t learn, you don’t pay.
Why Trust Us?
Stream Skill is part of the Simon Sez IT family and has been in business 14+ years and taught over 1 million students in that time. We’ve created over 130 software training courses, 8,000+ video tutorials, and we’ve helped thousands of people across the world learn how to use Microsoft Office. We’ve now created Microsoft Excel courses for the last five versions and continue to help people get to grips with this essential tool.
Your Instructor
Course Curriculum
-
Free PreviewCourse Introduction (1:36)
-
StartDOWNLOAD ME: Course Files
-
StartDOWNLOAD ME: Exercise Files
-
Free PreviewCreating Simple Charts (12:14)
-
Free PreviewUsing Graphics to Enhance Charts (3:17)
-
StartLinking Chart Titles (1:51)
-
StartSimple Charts Exercise (2:09)
-
StartCreating Area Charts (4:03)
-
StartCreating Surface Charts (8:50)
-
StartCreating Radar Charts (4:36)
-
StartCreating Bubble Charts (7:58)
-
StartCreating Stock Charts (5:45)
-
StartAdvanced Excel Charts Exercise (2:32)
-
StartCourse Conclusion (1:36)