Get Bonus Downloads Here.url

   001 Course Introduction & Scope.mp4

   002 Download Excel Files HERE.mp4

   003 Cheat Sheets - Step by Step Guide to Create Powerful Excel Charts.html

   7111966-ExcelCharts-StepbyStepGuide-XelPlus.pdf

   001 Measuring Performance, doing Comparisons & predicting the Future.mp4

   002 Excel Column Chart Combinations.mp4

   003 Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines.mp4

   004 Variances With a Bar Chart - The Professional Method #1.mp4

   005 Variances With Two Bar Charts - Professional Method #2.mp4

   006 Measuring Performance - Bullet Charts Overview.mp4

   007 Vertical Bullet Chart with Percentages in Excel.mp4

   008 Vertical Bullet Chart with Absolute Values in Excel.mp4

   009 Horizontal Bullet Chart in Excel.mp4

   010 Horizontal Bullet Chart - The Easy Method.mp4

   011 Exercise - Effective Charts to Measure Actual to Budget Performance.html

   001 Use Symbols in Excel Charts - The Simple Method.mp4

   002 Use Symbols in Excel Charts - The Impressive Method.mp4

   003 Include a Reference Region.mp4

   004 Learn how to Create a Pin Chart for Variances.mp4

   005 Exercise - Effective Excel Chart to Compare Actual to Previous Year.html

   001 Use Continuous Line Series to show Outlook Development.mp4

   002 Great trick - Add a Divider to emphasise where Outlook Starts.mp4

   003 Exercise - Show Outlook Development.html

   001 Effective Chart Combinations - Overview.mp4

   002 Scatter & Bubble Charts.mp4

   003 KPI by Geography.mp4

   004 Comparing Distributions with Box Plots.mp4

   005 Parts-to-whole Chart - It's Not the Pie Chart.mp4

   006 Pareto Chart - 80-20 rule.mp4

   007 Panel Charts - Showing Many Variables at Once.mp4

   008 Sparklines for Compact Charts.mp4

   009 Quick & Simple Gantt Chart.mp4

   010 Fully Featured Gantt Chart (incl. % completion & comparison to plan).mp4

   011 Exercise - Effective Chart Combinations.html

   001 Waterfall Chart Overview.mp4

   002 Easiest Method for the Most Flexible Waterfall Chart in Excel.mp4

   003 Waterfall Chart in Excel - Step by Step.mp4

   004 Exercise - Waterfall Chart in Excel.html

   001 Final words.mp4

   002 __ Next Steps - BONUS.html

   001 Effective Presentation of Quantitative Data - Overview.mp4

   002 Table Design - Best Practices.mp4

   003 Excel Chart Design - Best Practices.mp4

   004 Understanding the Chart Tools Environment.mp4

   005 Simple Shortcuts to Save Time.mp4

   001 Never Manually update your Excel Charts again_.mp4

   002 Top Excel Functions that will save you time.mp4

   001 Excel Tables are a Time Saver.mp4

   002 When Tables fail Use this Function.mp4

   003 Excel Name Manager & OFFSET as a Great Team.mp4

   004 OFFSET without Name Manager to Update your Excel Chart.mp4

   005 Exercise - Dynamic Excel Charts.html

   001 Index and Match for an Interactive Chart that shows Different Views.mp4

   002 Index & Match - The Index Part.mp4

   003 Index & Match - The Match Part.mp4

   004 The Dream Team - INDEX & MATCH.mp4

   005 Mix it all for Major Time Saving - Yes it becomes a Dashboard_.mp4

   006 Exercise - Function for Interactive Charts.html

   001 Automatic Sorting of the Bars in an Excel Bar Chart - Overview.mp4

   002 Automatic Sorting in Excel - The RANK Function.mp4

   003 Automatic Sorting in Excel - Unique RANK.mp4

   004 Exercise - Automatic Sorting of Bars.html

   001 Perfect Positioning of Series Labels.mp4

   002 Excel Chart Series Label Positioning - Simple Line Series.mp4

   003 Excel Chart Series Label Positioning - Changing Line Series.mp4

   004 Excel Chart Series Label Positioning - Stacked Column Chart.mp4

   005 Exercise - Automatic Legend Positioning.html

   001 Highlight key Areas for Faster & Easier Readability.mp4

   002 Excel Conditional Format Column Colors for Best Impact.mp4

   003 Excel Conditional Format Bar Colors.mp4

   004 Conditionally Color Neg_Pos Columns & Data Labels.mp4

   005 Better Alternative for Variance Charts in Excel.mp4

   006 Vertical Lines to Create Dividers.mp4

   007 Error bars as Dividers.mp4

   008 Use Dynamic Annotations to Direct Reader Attention.mp4

   009 Exercise - Bring Attention to Key Chart Elements.html

   001 Conditional Formatting for Easy-to-Read Tables - Overview.mp4

   002 The Conditional-Formatting-Free method - Use Symbols.mp4

   003 Highlight Table Rows Based on Values.mp4

   004 Using Smart Color Coding in Tables.mp4

   005 Use Symbols or Bars for Easier Readability.mp4

   006 Exercise - Design Tables with Focus.html