| Week 1 OneDrive | | | | 0100 |
| | 1. Sign In 2-26 | 2. Navigate the Interface 5-30 | 3. One Drive App 2-9 | 0110 |
| | 4. Upload Files 2-40 | 5. Upload Files Using App 3-42 | 6. Organize Files 4-22 | 0115 |
| | 7. Manage Files 4-15 | 8. Search Files 2-31 | 9. Office and OneDrive | 0120 |
| | 10 Create Documents 3-5 | 11. OneDrive and Desktop 2-45 | 12. Share Files with Link 4-39 | 0125 |
| | 13. Share with People 4-2 | 14. Collaboration 2-18 | 15. Next Step 0-14 | 0130 |
| Week 2 Excel | | | | 0200 |
| | 1. Simple Formulas 7-11 | 2. Copying Formulas 3-48 | 3. Year-to-Date Totals 3-49 | 0210 |
| | 4. Percentage Change 7-37 | 5. Absolute References 5-32 | 6. Sum and Average 5-18 | 0220 |
| | 7. Common Functions 7-44 | 8. If functions 5-26 | | 0230 |
| Week 3 | | | | 0300 |
| | 9. Vlookup 7-07 | 10. Vlookup Exact 7-58 | 11. Countif 4-46 | 0310 |
| | 12. Goal Seek 7-14 | 13. Solver 7-03 | 14. Scenario Manager 7-38 | 0320 |
| Recommended | Unlock and Protect 8-2 | Protect Workbooks 5-50 | Assigning Passwords 2-52 | 0330 |
| | Sharing Workbooks 3-57 | Tracking Changes 5-17 | | 0340 |
| Week 4 | | | | 0400 |
| | 15. Data Tables 6-19 | 16. Pivot Table 12-25 | 17. Pivot Table Data 11-27 | 0410 |
| | 18. Group by Date 10-50 | 19. Other Groupings 4-40 | 20. Slicers 7-10 | 0420 |
| | 21. Using Pivot Charts 4-42 | | | 0430 |
| Recommended | Sorting 9-44 | Inserting Subtotals 8-39 | Using Filters 6-40 | 0435 |
| | Splitting Data 8-26 | Combining and Flash Fill 6-40 | Duplicate Records 2-23 | 0440 |
| | Using Validation Tools 10-45 | | | 0445 |
| | Exploring Marcros 6-14 | Creating a Macro 10-20 | Running a Macro 13-46 | 0450 |
| Week 5 Midterm 1 | | | | 0500 |
| Week 6 Access | | | | 0600 |
| | 1. Creating Tables 5-16 | 2. Importing Data 5-37 | 3. Creating Relationships 6-15 | 0620 |
| | 4. Editing Table Structure 4-25 | 5. Input Masks 6-09 | 4. Default Values 2-35 | 0630 |
| | 7. Validation Rules 4-06 | 8. Lookup Fields 3-51 | 9. Another Table 5-50 | 0640 |
| Week 7 | | | | 0700 |
| | 1. Understand Queries 3-10 | 2. Query Wizard 3-58 | 3. Design View 9-23 | 0710 |
| | 4. Using Constraints 5-28 | 5. Using Wildcards 9-23 | 6. Multiple Criteria 5-28 | 0720 |
| | 7. Math Comparison 3-41 | 8. Parameter Queries 5-07 | 9. Building Expressions 7-26 | 0730 |
| | 10. Summary Statistics 7-3 | | | 0735 |
| Week 8 | | | | 0800 |
| | 11. Generating Forms 4-37 | 12. Adjusting the Layout 5-29 | 13. Form Wizard 4-35 | 0810 |
| | 14. Designing Forms 4-29 | 15. Form Properties 4-55 | 16. Data Sources 6-8 | 0815 |
| | 17. Form Control 11-28 | 18. Input Boxes 5-24 | 19. Record Navigation 4-2 | 0820 |
| | 20. Adding Buttons 4-21 | | | 0825 |
| Recommended | Using Report Wizard 4-53 | Designing a Report 4-38 | Editing the Layout 7-51 | 0830 |
| | Grouping and Sorting 7-7 | Calculated Totals 3-52 | Conditional Formatting 7-36 | 0835 |
| | Creating Labels 5-21 | Print Settings 4-6 | | 0840 |
| Week 9 Power BI | | | | 0900 |
| | 1. Getting Data 4-0 | 2. Power BI Desktop 9-0 | 3. Data Sources 8-0 | 0910 |
| | 4. Transform 8-0 | 5. Advanced Data Sources 8-0 | 6. Cleaning Data 8-0 | 0915 |
| Recommended | Publishing 2-0 | Publish from Desktop 2-0 | Print and Export 4-0 | 0920 |
| | Republishing 5-0 | Power BI Mobile 7-0 | Groups in Power BI 5-0 | 0925 |
| | Create Content Pack 5-0 | Connect to Content Pack 7-0 | Edit Content Pack 4-0 | 0930 |
| Week 10 Midterm 2 | | | | 1000 |
| Week 11 | | | | 1100 |
| | 7. Modelling 3-0 | 8. Data Relationships | 9. Calculated Columns | 1110 |
| | 10. Optimize Data Models 8-0 | 11. Time-based Functions | 12. Calculated Tables | 1115 |
| | 13. Time-Based Data 6-0 | | | 1120 |
| Recommended | Visualizations 2-0 | Customize Visualizations 8-0 | Combination Charts | 1125 |
| | Format Slicers 7-0 | Map Visualizations 11-0 | Tables and Matrixes 8-0 | 1130 |
| | Scatter Charts 9-0 | Waterfall and Funnel 5-0 | Gauges and Cards 7-0 | 1135 |
| Week 12 SharePoint | | | | 1200 |
| | 1. Team Sites Basics 5-6 | 2. Navigate a Site 8-58 | 3. Site Content 5-38 | 1210 |
| | 4. Saving a Document 6-46 | 5. Sharing 15-47 | 6. Add an App 7-22 | 1215 |
| | 7. Use A List 6-31 | 8. Custom List 6-14 | 9. Metadata 5-39 | 1220 |
| | 10. Site: The Basics 4-8 | 11. Team Site 9-52 | 12. Modify Navigation 5-4 | 1230 |
| | 13. Project Site 8-51 | 14. Site Template 3-13 | 15. Using Custom Template 1-48 | 1235 |
| Week 13 Visio | | | | 1300 |
| | 1. Use Smartshapes 3-51 | 2. Arrange SmartShapes 1-56 | 3. Connect Shapes 2-36 | 1310 |
| | 4. Insert and Delete Shapes 2-23 | 5. Organize SmartShapes 2-43 | 6. Rearrange Layout 3-56 | 1315 |
| | 7. Insert Text Objects 5-43 | 8. Insert Pages | 9. Insert Graphics | 1320 |
| | 10. Insert Containers 4-38 | 11. Insert Hyperlinks 6-47 | 12. Show-Hide Rulers 6-30 | 1325 |
| | 13. Using Visual Aids 8-53 | 14. Task Panes 5-29 | 15. Working with Windows 4-9 | 1330 |
| | 16. Print Diagrams 4-13 | 17. Publish in PDF 2-6 | 18. SmartShapes and Layers 3-55 | 1335 |
| | 19. Create Layers 5-5 | 20. Manage Layers 9-42 | | 1340 |
| Week 14-15 Project Presentations | | | | 1400 |
| | | | | 1410 |
| Week 16 Final Exam | | | | 1600 |
| | | | | 1610 |
| References | | | | 2000 |
| | 1. Downloading Tableau 2-21 | 2. Installing Tableau Drivers 1-32 | 3. Tableau File Types 1-31 | 2010 |
