Скачать или смотреть Week 8 - SAM Case Demo (Required)

This video provides a step by step demonstration of every step in the Week 8 SAM Case, with a submission upon completion of the case showing that the Steps demonstrated in the video will earn you 100%. See timestamps below for video chapters:

00:00 - Introduction to Video, Downloading, Renaming Start File, Opening Case Files, Continued Commentary on Knowing WHERE YOUR FILES ARE!
02:09 - Starting Case, Introduction to Excel Tables, Steps 1 & 2
08:58 - Step 3, Filters
11:06 - Step 4, Freezing Panes
13:11 - Step 5, Sorting & Total Row with Averages
20:14 - Step 6, Subtotals
25:12 - Steps 7 & 8, Reformatting & Using Other Table Tools
27:33 - Steps 9-13, FINAL WORKSHEET: Adding a Column, Using Structured References in Tables for Formulas, Adding Slicers for Filtering
45:25 - Saving File and Submitting for 100% + Video Conclusion