Watch the following Excel videos and follow along with the DIS Excel Workbook or pause the video and then attempt the skill yourself. In the workbook, we’ve provided the timing of when each skill appears in the videos should you choose to skip a skill you are very familiar with.
You can pause, rewind, turn on captioning, and watch the videos in full-screen mode. Watch and re-watch a skill as much as you need until you feel comfortable with it. After completing the Data Informed Supervisor training, you may come back to this page to review the videos. You may want to bookmark this page.
1. Introductory Excel Skills
2. Using Excel for Analysis
3. Presenting Excel Data
Pivot Table Videos
As you follow along with the video and complete the PivotTable activity, please reference the Using Pivot Tables for Child Welfare Data Analysis.pdf handout as well which provides step-by-step screenshots and explanations.