Bootcamp Syllabus

For anyone brand new to computers — what a computer actually is, before touching any software.

1. What is a Computer?
2. External Hardware Parts
3. Inside a Computer
4. Operating Systems
5. Understanding Applications

The essentials of navigating a Windows 10 desktop.

1. Getting Started with Windows 10
2. Desktop & Taskbar Basics
3. Working with Files & Folders
4. Finding Files on Your Computer
5. New Features in Windows 10

The deepest course in the program — a full walkthrough of every major Windows 11 surface, organized into six units:

• Desktop, Start Menu & Navigation — Start menu, taskbar, Snap Layouts, multiple desktops, sign-in options, widgets (lessons 1–19)
• File Explorer & File Management — folders, sorting, copy/cut/paste, Quick Access, OneDrive, zip files (20–37)
• Settings Deep Dive — System, Bluetooth & Devices, Network & Internet, Personalization, Apps, Accounts, Time & Language, Gaming, Accessibility, Privacy & Security, Windows Update (38–144)
• System Tools & Utilities — Control Panel, File History, System Restore, Recycle Bin, taskbar pinning, OneDrive settings (145–155)
• WordPad & Paint — creating, formatting, saving, and printing in both built-in apps (156–167)
• Internet & Microsoft Edge — browsing, favorites, history, downloads, printing and sharing web pages (168–183)

Document creation through advanced formatting, mail merge, and macros.

1. Getting Started with Word
2. Understanding OneDrive
3. Creating and Opening Documents
4. Saving and Sharing Documents
5. Text Basics
6. Formatting Text
7. Using Find and Replace
8. Indents and Tabs
9. Line and Paragraph Spacing
10. Lists
11. Hyperlinks
12. Page Layout
13. Printing Documents
14. Breaks
15. Columns
16. Headers and Footers
17. Page Numbers
18. Pictures and Text Wrapping
19. Formatting Pictures
20. Shapes
21. Text Boxes
22. Aligning, Ordering, & Grouping
23. Tables
24. Charts
25. Checking Spelling and Grammar
26. Track Changes and Comments
27. Inspecting and Protecting
28. SmartArt Graphics
29. Applying and Modifying Styles
30. Mail Merge
31. Document Templates
32. Formatting Marks
33. Shortcuts for Formatting
34. Advanced Find and Replace
35. Customizing the Ribbon
36. Table of Contents
37. Footnotes and Endnotes
38. Citations and Bibliography
39. Document Comparison
40. Restricting Editing
41. Building Blocks & Quick Parts
42. Forms Creation
43. Macros Overview

Spreadsheet fundamentals through formulas, PivotTables, and everyday power-user shortcuts.

1. Getting Started
2. Creating and Opening Workbooks
3. Saving and Sharing
4. Cell Basics
5. Modifying Columns, Rows, and Cells
6. Formatting Cells
7. Understanding Number Formats
8. Working with Multiple Worksheets
9. Using Find and Replace
10. Page Layout and Printing
11. Intro to Formulas
12. How to Create Complex Formulas
13. Relative and Absolute Cell References
14. Functions
15. Solving Real-Life Problems
16. Freeze Panes and View Options
17. Sorting Data
18. Filtering Data
19. Groups and Subtotals
20. Tables
21. Charts
22. Conditional Formatting
23. Comments and Co-authoring
24. Inspecting and Protecting Workbooks
25. Intro to PivotTables
26. Doing More with PivotTables
27. What-if Analysis
28. Quick Tip: Add Current Date to a Cell
29. Quick Tip: Faster Way to Use Fill Handle
30. Quick Tip: Two Ways to Use Format Painter
31. Quick Tip: A Shortcut to AutoSum
32. Quick Tip: Quick Access Toolbar Shortcuts
33. Quick Tip: Quickly Duplicate a Sheet
34. Quick Tip: Jump to Sheet with Shortcut
35. Quick Tip: Select Entire Row or Column
36. Quick Tip: Find Sum Without Formula
37. Quick Tip: Avoid Merging Cells
38. Quick Tip: Quick Analysis Tool
39. Quick Tip: Charts Auto Update
40. Quick Tip: Use Transpose to Flip Data
41. Quick Tip: Absolute References (F4)
42. Quick Tip: Add New Row Shortcut
43. Quick Tip: Column as Cell Range
44. Quick Tip: What are Named Ranges?
45. Quick Tip: Finding Inconsistent Data

Slide design, animation, and presenting — from a blank deck to a polished, rehearsed presentation.

1. New Course: PowerPoint 2016
2. Getting Started
3. Creating & Opening Presentations
4. Saving and Sharing
5. Slide Basics
6. Text Basics
7. Applying Themes
8. Applying Transitions
9. Managing Slides
10. Using Find & Replace
11. Printing
12. Presenting Your Slide Show
13. Lists
14. Indents and Line Spacing
15. Inserting Pictures
16. Formatting Pictures
17. Shapes
18. Aligning, Ordering & Grouping
19. Animating Text and Objects
20. Inserting Videos
21. Inserting Audio
22. Tables
23. Charts
24. SmartArt Graphics
25. Checking Spelling and Grammar
26. Reviewing Presentations
27. Inspecting & Protecting
28. Modifying Themes
29. Slide Master View
30. Links
31. Action Buttons
32. Rehearsing & Recording
33. Sharing Presentations Online
34. Quick Tip: Crop Images Into Custom Shapes
35. Quick Tip: Duplicate Your Animations
36. Quick Tip: Play Audio Across Slideshow
37. Quick Tip: Customize Quick Access Toolbar
38. Quick Tip: Keep Objects Aligned Moving
39. Quick Tip: Line Up Slide With Guides
40. Quick Tip: Open File in Slide Show Mode
41. Quick Tip: Temporarily Hide Presentation

Email, calendar, and everyday productivity, organized into three units:

• Email Management — accounts, inbox views, folders, rules, attachments, signatures, automatic replies (lessons 1–52)
• Calendar & Scheduling — creating and editing events, recurring meetings, sharing calendars, invitations (53–81)
• Settings, Preferences & Productivity Tools — storage, language, keyboard shortcuts, notifications, read receipts, and Immersive Reader (82–113)