Slaying Excel Dragons - Complete Lessons on Excel Charts

Overview

Dive into a comprehensive 46-minute video tutorial on Excel charts, covering 26 different examples. Master the art of data visualization by learning why charts are essential, how to avoid chart junk, and compare various chart types. Explore categories and series, create pie charts, link chart titles to cells, and format chart elements. Discover keyboard shortcuts, chart styles, printing techniques, and how to save chart templates. Progress through column, bar, stacked, and histogram charts, adding labels and adjusting gap widths. Delve into line charts, X-Y scatter plots with trendlines, and break-even analysis charts. Learn to select and edit source data, combine chart types, and utilize Sparklines for cell-based visualizations. Perfect for Excel beginners to intermediate users, this tutorial provides a thorough foundation in chart creation and manipulation.

Syllabus

1. Why Charts? min mark
2. Chart Junk min mark
3. Compare and Contrast Chart Types min mark
4. Categories and Series min mark
5. Pie Chart min mark
6. Linking Chart Title to Cells min mark
7. Format Chart Elements min mark
8. Keyboard: Ctrl + 1 min mark
9. Chart Style min mark
10. Printing min mark
11. Saving Chart Templates min mark
12. Setting Default Charts min mark
13. Keyboard Shortcuts To Create Complete Chart min mark
14. Column Charts min mark
15. Copying Charts min mark
16. Bar Charts min mark
17. Stacked Bar or Column Charts min mark
18. Histograms min mark
19. Formula For Histogram min mark
20. Change Gap Width min mark
21. Adding Chart Labels min mark
22. Line Charts min mark
23. X-Y Scatter Charts min mark
24. Trendlines For X-Y Scatter min mark
25. Break Even Analysis Chart min mark
26. Selecting and Editing Source Data For Chart min mark
27. Select Data Source Dialog Box min mark
28. Two Chart Types In One min mark
29. Sparklines Cell Charts min mark