Dashboard Syllabus Sales
 |
 |
||
| Total Course | 3:58:55 | 2:59:25 | |
| Session 1 | Introduction | 0:08:47 | |
| Session 2 | Getting Your Data Ready | 0:05:20 | |
| Session 3 | Design Principles | 0:06:07 | |
| Session 4 | Display Principles | 1:33:29 | |
| 4.01 | Charts & Tricks for Trending | 0:13:24 | |
| 4.02 | Secondary Axis | 0:01:09 | |
| 4.03 | Smoothing Data | 0:03:24 | |
| 4.04 | Sparklines | 0:15:34 | |
| 4.05 | Formatting Tricks | 0:02:27 | |
| 4.06 | Ranking Tricks | 0:05:13 | |
| 4.07 | Top & Bottom Ranking | 0:06:38 | |
| 4.08 | Frequency Distribution | 0:04:00 | |
| 4.09 | Target vs Variance Charts | 0:03:45 | |
| 4.10 | Performance Against Target Range | 0:03:12 | |
| 4.11 | Bullet Graphs | 0:12:47 | |
| 4.12 | Win/Loss/Draw Conditional Format | 0:05:40 | |
| 4.13 | Dynamic Data Range | 0:06:03 | |
| 4.14 | Dynamic Labels | 0:01:45 | |
| 4.15 | Text Formulas | 0:03:17 | |
| 4.16 | Symbols in Formulas and Charts | 0:04:01 | |
| 4.17 | Charts Referencing Non-contiguous Ranges | 0:01:10 | |
| Related | Excel Session 9: Conditional Formatting | 0:12:29 | |
| Related | Excel Session 19: Adding Graphics | 0:26:57 | |
| Session 5 | Interactive Controls | 0:35:03 | |
| 5.01 | Form Controls Introduction | 0:02:00 | |
| 5.02 | Check Boxes | 0:03:53 | |
| 5.03 | List Boxes | 0:05:08 | |
| 5.04 | Option Buttons | 0:09:07 | |
| 5.05 | Group Boxes | 0:02:30 | |
| 5.06 | Scroll Bar | 0:03:44 | |
| 5.07 | Buttons | 0:02:32 | |
| 5.08 | Combo Box with Macro | 0:06:09 | |
| Session 6 | Analysing the Data | 0:08:35 | |
| 6.01 | PivotCharts | 0:03:31 | |
| 6.02 | Slicers – Excel 2010 Only | 0:05:04 | |
| Related | Excel Session 10: Tables | 0:14:24 | |
| Related | Excel Session 14: Lookup Functions | 0:35:49 | |
| Related | Excel Session 15: Conditional Logic | 0:43:58 | |
| Related | Excel Session 21: PivotTables | 0:15:52 | |
| Session 7 | Automating your Dashboard | 0:08:17 | |
| 7.01 | Linking to Access | 0:08:17 | |
| Related | Excel Session 26: Macros | 0:18:28 | |
| Session 8 | Distributing your Dashboard | 0:03:52 | |
| Related | Excel Session 22: Protecting Data | 0:11:28 | |
| Session 9 | Putting It All Together | 0:56:38 | |
| 9.01 | Quick Re-cap | 0:01:41 | |
| 9.02 | New Dashboard Tour | 0:03:47 | |
| 9.03 | Pyramid Chart | 0:08:34 | |
| 9.04 | Array Formula Alternative to SUMIFS | 0:10:09 | |
| 9.05 | LARGE and SMALL Array and DAVERAGE | 0:06:51 | |
| 9.06 | Rank Values with PivotTable | 0:03:53 | |
| 9.07 | Scatter Chart | 0:08:43 | |
| 9.08 | DMAX, DMIN, DAVERAGE | 0:06:01 | |
| 9.09 | Formatting Quickly | 0:06:59 | |
| Bonus | INDIRECT Function | 0:12:47 | |
| Click here to download INDIRECT File | |||
| Homework | Your Final Challenge | ||
| Examples | Click here to download 3 Example Files | ||
| Index | Click here to download Index File | ||
| Thank you | Congratulations! You’re Finished |