|
|
001 Automatic Sorting of the Bars in an Excel Bar Chart - Overview.mp4
|
MP4
|
8 MB
|
|
|
001 Automatic Sorting of the Bars in an Excel Bar Chart - Overview_en.srt
|
SRT
|
1.6 KB
|
|
|
001 Conditional Formatting for Easy-to-Read Tables - Overview.mp4
|
MP4
|
32.2 MB
|
|
|
001 Conditional Formatting for Easy-to-Read Tables - Overview_en.srt
|
SRT
|
2.8 KB
|
|
|
001 Course Introduction & Scope.mp4
|
MP4
|
116 MB
|
|
|
001 Course Introduction & Scope_en.srt
|
SRT
|
8.1 KB
|
|
|
001 Effective Chart Combinations - Overview.mp4
|
MP4
|
6.1 MB
|
|
|
001 Effective Chart Combinations - Overview_en.srt
|
SRT
|
1.8 KB
|
|
|
001 Effective Presentation of Quantitative Data - Overview.mp4
|
MP4
|
11.4 MB
|
|
|
001 Effective Presentation of Quantitative Data - Overview_en.srt
|
SRT
|
2.2 KB
|
|
|
001 Excel Tables are a Time Saver.mp4
|
MP4
|
82.1 MB
|
|
|
001 Excel Tables are a Time Saver_en.srt
|
SRT
|
9 KB
|
|
|
001 Final words.mp4
|
MP4
|
5.8 MB
|
|
|
001 Final words_en.srt
|
SRT
|
1.2 KB
|
|
|
001 Highlight key Areas for Faster & Easier Readability.mp4
|
MP4
|
56.7 MB
|
|
|
001 Highlight key Areas for Faster & Easier Readability_en.srt
|
SRT
|
4 KB
|
|
|
001 Index and Match for an Interactive Chart that shows Different Views.mp4
|
MP4
|
46.4 MB
|
|
|
001 Index and Match for an Interactive Chart that shows Different Views_en.srt
|
SRT
|
2.8 KB
|
|
|
001 Measuring Performance, doing Comparisons & predicting the Future.mp4
|
MP4
|
51.9 MB
|
|
|
001 Measuring Performance, doing Comparisons & predicting the Future_en.srt
|
SRT
|
3.2 KB
|
|
|
001 Never Manually update your Excel Charts again_.mp4
|
MP4
|
14 MB
|
|
|
001 Never Manually update your Excel Charts again__en.srt
|
SRT
|
4.9 KB
|
|
|
001 Perfect Positioning of Series Labels.mp4
|
MP4
|
12.6 MB
|
|
|
001 Perfect Positioning of Series Labels_en.srt
|
SRT
|
2.6 KB
|
|
|
001 Use Continuous Line Series to show Outlook Development.mp4
|
MP4
|
14.8 MB
|
|
|
001 Use Continuous Line Series to show Outlook Development_en.srt
|
SRT
|
2.4 KB
|
|
|
001 Use Symbols in Excel Charts - The Simple Method.mp4
|
MP4
|
56.5 MB
|
|
|
001 Use Symbols in Excel Charts - The Simple Method_en.srt
|
SRT
|
8.3 KB
|
|
|
001 Waterfall Chart Overview.mp4
|
MP4
|
7.5 MB
|
|
|
001 Waterfall Chart Overview_en.srt
|
SRT
|
2.2 KB
|
|
|
002 Automatic Sorting in Excel - The RANK Function.mp4
|
MP4
|
40.4 MB
|
|
|
002 Automatic Sorting in Excel - The RANK Function_en.srt
|
SRT
|
6.2 KB
|
|
|
002 Download Excel Files HERE.mp4
|
MP4
|
7.6 MB
|
|
|
002 Download Excel Files HERE_en.srt
|
SRT
|
1.5 KB
|
|
|
002 Easiest Method for the Most Flexible Waterfall Chart in Excel.mp4
|
MP4
|
56 MB
|
|
|
002 Easiest Method for the Most Flexible Waterfall Chart in Excel_en.srt
|
SRT
|
9.8 KB
|
|
|
002 Excel Chart Series Label Positioning - Simple Line Series.mp4
|
MP4
|
31.3 MB
|
|
|
002 Excel Chart Series Label Positioning - Simple Line Series_en.srt
|
SRT
|
8.2 KB
|
|
|
002 Excel Column Chart Combinations.mp4
|
MP4
|
32.3 MB
|
|
|
002 Excel Column Chart Combinations_en.srt
|
SRT
|
8.4 KB
|
|
|
002 Excel Conditional Format Column Colors for Best Impact.mp4
|
MP4
|
38.4 MB
|
|
|
002 Excel Conditional Format Column Colors for Best Impact_en.srt
|
SRT
|
9.6 KB
|
|
|
002 Great trick - Add a Divider to emphasise where Outlook Starts.mp4
|
MP4
|
30.4 MB
|
|
|
002 Great trick - Add a Divider to emphasise where Outlook Starts_en.srt
|
SRT
|
8 KB
|
|
|
002 Index & Match - The Index Part.mp4
|
MP4
|
22.1 MB
|
|
|
002 Index & Match - The Index Part_en.srt
|
SRT
|
5.3 KB
|
|
|
002 Scatter & Bubble Charts.mp4
|
MP4
|
39.8 MB
|
|
|
002 Scatter & Bubble Charts_en.srt
|
SRT
|
6.8 KB
|
|
|
002 Table Design - Best Practices.mp4
|
MP4
|
19.4 MB
|
|
|
002 Table Design - Best Practices_en.srt
|
SRT
|
3.4 KB
|
|
|
002 The Conditional-Formatting-Free method - Use Symbols.mp4
|
MP4
|
46.2 MB
|
|
|
002 The Conditional-Formatting-Free method - Use Symbols_en.srt
|
SRT
|
8.5 KB
|
|
|
002 Top Excel Functions that will save you time.mp4
|
MP4
|
6 MB
|
|
|
002 Top Excel Functions that will save you time_en.srt
|
SRT
|
1.8 KB
|
|
|
002 Use Symbols in Excel Charts - The Impressive Method.mp4
|
MP4
|
47.3 MB
|
|
|
002 Use Symbols in Excel Charts - The Impressive Method_en.srt
|
SRT
|
6.4 KB
|
|
|
002 When Tables fail Use this Function.mp4
|
MP4
|
79 MB
|
|
|
002 When Tables fail Use this Function_en.srt
|
SRT
|
12.3 KB
|
|
|
002 __ Next Steps - BONUS.html
|
HTML
|
5.2 KB
|
|
|
003 Automatic Sorting in Excel - Unique RANK.mp4
|
MP4
|
17.3 MB
|
|
|
003 Automatic Sorting in Excel - Unique RANK_en.srt
|
SRT
|
5.2 KB
|
|
|
003 Cheat Sheets - Step by Step Guide to Create Powerful Excel Charts.html
|
HTML
|
1.2 KB
|
|
|
003 Excel Chart Design - Best Practices.mp4
|
MP4
|
23.1 MB
|
|
|
003 Excel Chart Design - Best Practices_en.srt
|
SRT
|
6 KB
|
|
|
003 Excel Chart Series Label Positioning - Changing Line Series.mp4
|
MP4
|
43.9 MB
|
|
|
003 Excel Chart Series Label Positioning - Changing Line Series_en.srt
|
SRT
|
6.6 KB
|
|
|
003 Excel Conditional Format Bar Colors.mp4
|
MP4
|
19.2 MB
|
|
|
003 Excel Conditional Format Bar Colors_en.srt
|
SRT
|
3.3 KB
|
|
|
003 Excel Name Manager & OFFSET as a Great Team.mp4
|
MP4
|
65.5 MB
|
|
|
003 Excel Name Manager & OFFSET as a Great Team_en.srt
|
SRT
|
10 KB
|
|
|
003 Exercise - Show Outlook Development.html
|
HTML
|
716.8 B
|
|
|
003 Highlight Table Rows Based on Values.mp4
|
MP4
|
18.2 MB
|
|
|
003 Highlight Table Rows Based on Values_en.srt
|
SRT
|
7.9 KB
|
|
|
003 Include a Reference Region.mp4
|
MP4
|
41.4 MB
|
|
|
003 Include a Reference Region_en.srt
|
SRT
|
9.3 KB
|
|
|
003 Index & Match - The Match Part.mp4
|
MP4
|
11.7 MB
|
|
|
003 Index & Match - The Match Part_en.srt
|
SRT
|
3.3 KB
|
|
|
003 KPI by Geography.mp4
|
MP4
|
26.1 MB
|
|
|
003 KPI by Geography_en.srt
|
SRT
|
9.1 KB
|
|
|
003 Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines.mp4
|
MP4
|
49.2 MB
|
|
|
003 Using Line Series in Excel - Make Sure you do this to Avoid Crashing Lines_en.srt
|
SRT
|
8.9 KB
|
|
|
003 Waterfall Chart in Excel - Step by Step.mp4
|
MP4
|
59.6 MB
|
|
|
003 Waterfall Chart in Excel - Step by Step_en.srt
|
SRT
|
12.2 KB
|
|
|
004 Comparing Distributions with Box Plots.mp4
|
MP4
|
65.1 MB
|
|
|
004 Comparing Distributions with Box Plots_en.srt
|
SRT
|
11.1 KB
|
|
|
004 Conditionally Color Neg_Pos Columns & Data Labels.mp4
|
MP4
|
55.2 MB
|
|
|
004 Conditionally Color Neg_Pos Columns & Data Labels_en.srt
|
SRT
|
15.4 KB
|
|
|
004 Excel Chart Series Label Positioning - Stacked Column Chart.mp4
|
MP4
|
55.6 MB
|
|
|
004 Excel Chart Series Label Positioning - Stacked Column Chart_en.srt
|
SRT
|
9.8 KB
|
|
|
004 Exercise - Automatic Sorting of Bars.html
|
HTML
|
716.8 B
|
|
|
004 Exercise - Waterfall Chart in Excel.html
|
HTML
|
716.8 B
|
|
|
004 Learn how to Create a Pin Chart for Variances.mp4
|
MP4
|
67 MB
|
|
|
004 Learn how to Create a Pin Chart for Variances_en.srt
|
SRT
|
8.5 KB
|
|
|
004 OFFSET without Name Manager to Update your Excel Chart.mp4
|
MP4
|
41.8 MB
|
|
|
004 OFFSET without Name Manager to Update your Excel Chart_en.srt
|
SRT
|
9.6 KB
|
|
|
004 The Dream Team - INDEX & MATCH.mp4
|
MP4
|
44.4 MB
|
|
|
004 The Dream Team - INDEX & MATCH_en.srt
|
SRT
|
7.9 KB
|
|
|
004 Understanding the Chart Tools Environment.mp4
|
MP4
|
114 MB
|
|
|
004 Understanding the Chart Tools Environment_en.srt
|
SRT
|
20.7 KB
|
|
|
004 Using Smart Color Coding in Tables.mp4
|
MP4
|
19.5 MB
|
|
|
004 Using Smart Color Coding in Tables_en.srt
|
SRT
|
4.2 KB
|
|
|
004 Variances With a Bar Chart - The Professional Method #1.mp4
|
MP4
|
81.6 MB
|
|
|
004 Variances With a Bar Chart - The Professional Method #1_en.srt
|
SRT
|
17.7 KB
|
|
|
005 Better Alternative for Variance Charts in Excel.mp4
|
MP4
|
37.1 MB
|
|
|
005 Better Alternative for Variance Charts in Excel_en.srt
|
SRT
|
14.8 KB
|
|
|
005 Exercise - Automatic Legend Positioning.html
|
HTML
|
716.8 B
|
|
|
005 Exercise - Dynamic Excel Charts.html
|
HTML
|
716.8 B
|
|
|
005 Exercise - Effective Excel Chart to Compare Actual to Previous Year.html
|
HTML
|
716.8 B
|
|
|
005 Mix it all for Major Time Saving - Yes it becomes a Dashboard_.mp4
|
MP4
|
110.5 MB
|
|
|
005 Mix it all for Major Time Saving - Yes it becomes a Dashboard__en.srt
|
SRT
|
13.1 KB
|
|
|
005 Parts-to-whole Chart - It's Not the Pie Chart.mp4
|
MP4
|
74.7 MB
|
|
|
005 Parts-to-whole Chart - It's Not the Pie Chart_en.srt
|
SRT
|
11.2 KB
|
|
|
005 Simple Shortcuts to Save Time.mp4
|
MP4
|
51.5 MB
|
|
|
005 Simple Shortcuts to Save Time_en.srt
|
SRT
|
9.5 KB
|
|
|
005 Use Symbols or Bars for Easier Readability.mp4
|
MP4
|
30.5 MB
|
|
|
005 Use Symbols or Bars for Easier Readability_en.srt
|
SRT
|
5.8 KB
|
|
|
005 Variances With Two Bar Charts - Professional Method #2.mp4
|
MP4
|
144.1 MB
|
|
|
005 Variances With Two Bar Charts - Professional Method #2_en.srt
|
SRT
|
19.1 KB
|
|
|
006 Exercise - Design Tables with Focus.html
|
HTML
|
716.8 B
|
|
|
006 Exercise - Function for Interactive Charts.html
|
HTML
|
716.8 B
|
|
|
006 Measuring Performance - Bullet Charts Overview.mp4
|
MP4
|
11 MB
|
|
|
006 Measuring Performance - Bullet Charts Overview_en.srt
|
SRT
|
2.1 KB
|
|
|
006 Pareto Chart - 80-20 rule.mp4
|
MP4
|
12.8 MB
|
|
|
006 Pareto Chart - 80-20 rule_en.srt
|
SRT
|
3.1 KB
|
|
|
006 Vertical Lines to Create Dividers.mp4
|
MP4
|
55 MB
|
|
|
006 Vertical Lines to Create Dividers_en.srt
|
SRT
|
9.4 KB
|
|
|
007 Error bars as Dividers.mp4
|
MP4
|
32.7 MB
|
|
|
007 Error bars as Dividers_en.srt
|
SRT
|
7.9 KB
|
|
|
007 Panel Charts - Showing Many Variables at Once.mp4
|
MP4
|
97.1 MB
|
|
|
007 Panel Charts - Showing Many Variables at Once_en.srt
|
SRT
|
11.5 KB
|
|
|
007 Vertical Bullet Chart with Percentages in Excel.mp4
|
MP4
|
35.3 MB
|
|
|
007 Vertical Bullet Chart with Percentages in Excel_en.srt
|
SRT
|
10.3 KB
|
|
|
008 Sparklines for Compact Charts.mp4
|
MP4
|
29.8 MB
|
|
|
008 Sparklines for Compact Charts_en.srt
|
SRT
|
5.5 KB
|
|
|
008 Use Dynamic Annotations to Direct Reader Attention.mp4
|
MP4
|
79.2 MB
|
|
|
008 Use Dynamic Annotations to Direct Reader Attention_en.srt
|
SRT
|
20 KB
|
|
|
008 Vertical Bullet Chart with Absolute Values in Excel.mp4
|
MP4
|
21.4 MB
|
|
|
008 Vertical Bullet Chart with Absolute Values in Excel_en.srt
|
SRT
|
5.7 KB
|
|
|
009 Exercise - Bring Attention to Key Chart Elements.html
|
HTML
|
716.8 B
|
|
|
009 Horizontal Bullet Chart in Excel.mp4
|
MP4
|
45.3 MB
|
|
|
009 Horizontal Bullet Chart in Excel_en.srt
|
SRT
|
11.6 KB
|
|
|
009 Quick & Simple Gantt Chart.mp4
|
MP4
|
45.6 MB
|
|
|
009 Quick & Simple Gantt Chart_en.srt
|
SRT
|
11.8 KB
|
|
|
010 Fully Featured Gantt Chart (incl. % completion & comparison to plan).mp4
|
MP4
|
69.9 MB
|
|
|
010 Fully Featured Gantt Chart (incl. % completion & comparison to plan)_en.srt
|
SRT
|
20.2 KB
|
|
|
010 Horizontal Bullet Chart - The Easy Method.mp4
|
MP4
|
9.1 MB
|
|
|
010 Horizontal Bullet Chart - The Easy Method_en.srt
|
SRT
|
3.7 KB
|
|
|
011 Exercise - Effective Chart Combinations.html
|
HTML
|
716.8 B
|
|
|
011 Exercise - Effective Charts to Measure Actual to Budget Performance.html
|
HTML
|
716.8 B
|
|
|
24705552-Excel-Visualization-ExerciseBook.xlsx
|
XLSX
|
957.3 KB
|
|
|
7111966-ExcelCharts-StepbyStepGuide-XelPlus.pdf
|
PDF
|
6.5 MB
|
|
|
9368982-Excel-Visualization-Demo.xlsx
|
XLSX
|
681.6 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
