Introduction
  • Be a Great Student!
  • DOWNLOAD: Excel Project Files & Course Study Tracker & Notes for New Students
  • Useful Keyboard Shortcuts and Tips
Chart Formatting & Customization
  • Making the Right Chart
  • Introduction to Excel Charts
  • Formatting Charts
  • Advanced Charting and Formatting Tips
  • Excel's Camera Tool
  • Learn Chart Axes in depth and add a Secondary Axis
  • Displaying Data - Custom Axis Labels and Gridlines
  • How to import data from word document into excel worksheet
Basic Chart Types
  • Pie or Donut Charts?
  • How to make a good Bar Chart
  • Line Chart: How to Graph Multiple Lines in Excel
  • TreeMap Chart
  • Sunburst Chart
  • Top 5 ways to create a Funnel Chart
  • Sparkline Chart
  • Sparklines and Win/Loss Charts
  • How to Make a Dynamic Chart with Drop-Down Lists and Filters
  • QUIZ 5: BASIC CHART TYPES
Data Visualization Charts & Graphs
  • How to create a People Graph in Excel 2019 - Excel Infographics
  • Excel Animated Chart using VBA Code
  • TOP and BOTTOM Ranking Chart
  • In-Cell Charts with REPT Function
  • In-Cell Charts & Comparisons with Conditional Formatting
  • How to Highlight Comparisons (Data Bars & Icon Sets)
  • Scroll and Sort Table with Formulas & Conditional Formatting
  • Rollover Method: Create a 5-star rating system with Dynamic On-Demand Charts
  • Chart Up and Down Arrow Symbols
  • Bar Chart with Upper and Lower Bounds
  • Dynamic Ranges for Chart Data
  • Dynamic Chart with Tables
  • Dynamic Chart with Data Filters
  • Heat Map with Conditional Formatting
  • Dynamic Heat Map using Scroll Bar Form Control
  • Small Multiples
Advanced Chart Types
  • Dot Plot & Dumbbell Chart
  • Panel Chart
  • Histogram ~ with Frequency Distribution
  • Waterfall or Bridge Chart ~ Use them and make awesome sales analysis
  • Speedometer (Gauge) Chart ~ learn how to create and use them in Dashboards
  • Gantt Chart ~ for project management applications
  • Burn Down Chart
  • Bullet Chart ~ a variation of a thermometer chart
  • Pareto Chart ~ the 80-20 chart for business analysis
  • Thermometer Chart ~ Ideal for Measuring Performance
  • Clustered Stacked Column Chart
  • KPI Bands Graph
  • POPULATION PYRAMID CHART
  • BI-DIRECTIONAL BAR CHART - Ideal for comparing data
  • TORNADO CHART - Ideal for Showing Financial Analysis
  • BOX AND WHISKER DIAGRAM
BONUS SECTION
  • Excel 2019 Tutorial for Beginners
  • Top 20 Excel Tips and Tricks
  • 3 unknown methods to select an Excel Data Range
  • My Final Thoughts & Thank you!
  • Amazing discount for my other courses!