Microsoft Office 2016

01: Intro (8:53)
02: Selecting and Navigating (7:55)
03: Keyboard Navigation and Basic Data Entry (9:18)
04: The Ribbon (5:23)
05: The Quick Access Toolbar (4:28)
06: Creating a New Spreadsheet (9:08)
07: Compatibility Issues (5:26)
08: Cell Data & Data Types (12:41)
09: Accessing Help (3:11)
10: Creating Worksheet Formulas (11:11)
11: Insert Functions (11:28)
12: Re-using Formulas and Functions (12:00)
13: Insert, Delete, & Adjust Columns & Rows (7:22)
14: Find and Replace (9:52)
15: Use Proofing and Research Tools (11:21)
16: Apply Text Formats (14:14)
17: Apply Number Formats (7:00)
18: Align Cell Contents (8:45)
19: Applying Styles and Themes (11:43)
20: Conditional Formatting (11:42)
21: Creating and Using Templates (6:13)
22: Preview and Print a Notebook (8:48)
23: Page Layout (15:44)
24: Configure Headers and Footers (12:37)
25: Managing Worksheets (6:32)
26: View Options (10:54)

27: Managing Workbook Properties (4:58)
28: Working with Named Ranges (11:40)
29: Using Named Ranges in Formulas (3:53)
30: Using Specialized Functions (14:13)
31: Working with Logical Functions (13:56)
32: Displaying Formulas (4:29)
33: Nesting Functions (5:29)
34: Date and Time Functions (3:38)
35: Text Functions (14:34)
36: Sorting Data (5:35)
37: Filtering Data (9:18)
38: Using Database Functions (7:49)
39: Using Subtotals (9:42)
40: Create and Modify Tables (8:16)
41: Manipulating Table Data (3:51)
42: Conditional Formatting Rules (3:52)
43: Using Logical Functions with Conditional Formatting (5:20)
44: Creating Charts (8:37)
45: Modifying and Formatting Charts (9:38)
46: Creating a Dual Axis Chart (7:21)
47: Chart Templates (2:59)
48: Formatting Shapes and Objects (7:05)
49: Creating a PivotTable (7:15)
50: Analyzing PivotTable Data (9:47)
51: Pivot Charts (6:26)

52: Slicers and Timelines (6:05)
53: Using Links and External References (10:16)
54: Using 3D References (8:58)
55: Consolidating Data (6:15)
56: Using Lookup Functions, Part 1 (12:01)
57: Using Lookup Functions, Part 2 (5:59)
58: Tracing Precedent and Dependent Cells (6:24)
59: Watching and Evaluating Formulas (5:30)
60: Comments and Track Changes (8:23)
61: Comparing and Merging Workbooks (4:48)
62: Accessibility Checker (4:20)
63: Protecting Worksheets and Workbooks (9:51)
64: Applying Data Validation (9:33)
65: Search for Invalid Data (6:41)
66: Working with Macros, Part 1 (11:27)
67: Working with Macros, Part 2 (7:21)
68: Creating Sparklines (4:42)
69: 3D Maps (6:32)
70: Data Tables (6:32)
71: Using Scenarios (4:55)
72: Goal Seek (2:42)
73: Forecasting Data Trends (3:00)
74: Changing Your Display (4:16)
75: Importing Delimited Text Files (3:42)
76: Data Forms and Form Controls (14:22)
77: Calculated Fields and Cube Functions (4:56)

01: Intro to Outlook (12:48)
02: Working with Email (9:29)
03: Outlook Help (2:42)
04: Add Message Recipients (4:41)
05: Check Spelling and Grammar (6:46)
06: Formatting Message Content (6:30)
07: Attach Files and Items (10:20)
08: Add Illustrations to Messages (3:53)
09: Message Styles (4:19)
10: Illustrations in Messages (8:01)
11: Automatic Message Content (10:24)
12: Customizing Reading Options (11:42)
13: Track Messages (7:09)
14: Recall and Resend (5:21)
15: Mark Messages (13:40)
16: Folders (4:27)
17: Contacts (11:37)
18: Manage Contacts (10:10)
19: View the Calendar (5:41)
20: Create Appointments (6:41)
21: Scheduling Meetings PT1 (11:29)
22: Scheduling Meetings PT2 (9:54)
23: Print the Calendar (3:33)
24: Create Tasks (10:13)
25: Notes (3:53)
26: Insert Advanced Characters and Objects (8:01)

27: Inserting Charts (4:21)
28: Modify Message Options (9:16)
29: Configure Global Outlook Options (6:12)
30: Customizing the Outlook Interface (6:49)
31: Group and Sort Messages (6:53)
32: Filters and Clutter (8:58)
33: Search Outlook Items (7:17)
34: Junk Email Filter (4:31)
35: Manage Your Mailbox (5:42)
36: Using Automatic Replies (5:50)
37: Conditional Formatting (4:16)
38: Using the Rules Wizard (9:04)
39: Quick Steps (6:29)
40: Advanced Calendar Options (6:37)
41: Managing Additional Calendars (9:06)
42: Manage Meeting Responses (12:03)
43: Import and Export Contacts (6:47)
44: Electronic Business Cards (8:11)
45: Forward Contacts (2:53)
46: Assign and Manage Tasks (10:38)
47: Delegate Access (13:50)
48: Sharing Calendars (4:26)
49: Sharing Contacts (2:45)
50: Archiving (7:29)
51: Outlook Data Files (3:32)
52: Data File Settings (2:25)

01: Intro to PowerPoint (9:41)
02: Views and Navigation (11:43)
03: Slideshow Options (4:30)
04: Create and Save (5:41)
05: Getting Help (6:11)
06: Select a Presentation Type (5:02)
07: Editing Text (14:27)
08: Arranging Slides (6:50)
09: Working with Themes (10:03)
10: Formatting Characters (7:53)
11: Lists (5:13)
12: Alignment and Spacing (6:03)
13: More Text Options (9:24)
14: Format Text Boxes (6:21)
15: Insert Images (8:23)
16: Creating Photo Albums (8:31)
17: Insert and Edit Shapes (9:17)
18: Edit Pictures, part 1 (11:55)
19: Edit Pictures, part 2 (6:03)
20: Group Objects (4:27)
21: Arrange Objects (9:06)
22: Animate Objects (13:43)
23: Add a Table (4:48)
24: Table Layout (7:53)

25: Table Design (6:41)
26: Insert a Table from Other Applications (4:32)
27: Creating a Chart (9:41)
28: Designing a Chart (4:13)
29: Formatting a Chart (10:11)
30: Inserting a Chart from Excel (3:16)
31: Review your Presentation (11:34)
32: Apply Transitions (5:55)
33: Printing your Presentation (3:22)
34: Delivering your Presentation
35: PowerPoint Online (6:04)
36: Viewing and Navigating Online (6:22)
37: Editing in PowerPoint Online (5:34)
38: Online Feature Review (4:23)
39: Customizing the User Interface (14:11)
40: Window Options (7:26)
41: Set PowerPoint Options (6:31)
42: Slide Masters Part 1 (10:25)
43: Slide Masters Part 2 (14:14)
44: Headers and Footers (6:26)
45: Notes Master and Handout Master (5:12)
46: SmartArt (4:52)
47: Modify SmartArt Graphics (11:54)

48: Write Math Equations (10:09)
49: Adding Audio to a Presentation (14:58)
50: Adding Video to a Presentation (9:27)
51: Adding Video to a Presentation Copy (7:54)
52: Customize Animations (12:39)
53: Animation with a Bookmark (3:59)
54: Timing Slide Transitions (2:43)
55: Sections (4:17)
56: Comments (8:28)
57: Compare and Merge Presentations (10:50)
58: Store and Share Presentations on the Web (12:02)
59: Annotate a Presentation (6:01)
60: Presenter View (13:00)
61: Setup Show (7:18)
62: Create a Custom Slide Show (5:12)
63: Adding Hyperlinks (4:26)
64: Action Buttons (10:56)
65: Zoom (11:25)
66: Record a Presentation (13:38)
67: Secure a Presentation (13:00)
68: Broadcast a Slideshow (8:25)
69: Create a Video (3:18)
70: Create a CD (3:52)

01: Overview and Navigation (6:37)
02: Create and Save Documents (6:43)
03: Save and Save As (3:38)
04: Manage Your Workspace (7:15)
05: Text Selection and Mini Toolbar (6:08)
06: Cut, Copy, and Paste (11:12)
07: Undo, Repeat, and Redo (5:18)
08: Preview and Print (5:55)
09: Customizing the Word Environment (7:48)
10: Applying Character Formatting (9:31)
11: Control Paragraph Layout (6:45)
12: Indents and Tabs (6:26)
13: Line and Paragraph Spacing (2:55)
14: Align Text Using Tabs (7:16)
15: Bullets and Numbered Lists (5:41)
16: Apply Borders and Shading (5:06)
17: Using Find and Replace (10:52)
18: Format Painter and Redo (6:27)
19: Intro to Styles (8:26)
20: Sorting a List (5:28)
21: Formatting a List (5:53)
22: Inserting a Table (7:31)
23: Modifying a Table (7:53)
24: Formatting a Table (5:44)
25: Converting Text to a Table (2:37)
26: Inserting Symbols & Special Characters (4:36)
27: Inserting Images (8:38)
28: Apply Page Border and Color (3:25)
29: Headers and Footers (5:18)
30: Controlling Page Layout (5:31)
31: Watermarks (3:25)

32: Spellcheck and Grammar (9:23)
33: Using Research Tools (5:03)
34: Checking Accessibility (5:07)
35: Saving a Document to Other Formats (4:17)
36: Sorting Table Data (6:25)
37: Cell Layout (6:25)
38: Calculations and Equations (8:22)
39: Create a Chart (8:56)
40: Add Excel Tables and Charts (11:25)
41: Text Styles (12:09)
42: Style Sets (6:47)
43 Custom List and Table Styles (7:51)
44: Apply Document Themes (5:08)
45: Inserting Building Blocks (8:35)
46: Create and Modify Building Blocks (6:16)
47: Insert Fields Using Quick Parts (6:28)
48: Creating a Document Using Templates (7:57)
49: Create a Template (5:56)
50: Modify Templates (2:54)
51: Template Organizer (4:57)
52: Control Paragraph Flow (3:34)
53: Insert Sections Breaks (9:29)
54: Insert Columns (4:06)
55: Link Text Boxes (6:04)
56: Insert Blank and Cover Pages (5:37)
57: Indexes and Concordances (8:30)
58: Insert a Table of Contents (7:16)
59: Ancillary Tables (3:24)
60: Table of Authorities (3:51)
61: Manage Outlines (7:22)
62: Master and Subdocuments (5:45)

63: Mail Merge (9:52)
64: Advanced Mail Merge (5:03)
65: Merge Labels (6:25)
66: Merge Envelopes (3:12)
67: Manipulating Images (8:41)
68: Adjust Image Appearance (7:27)
69: Insert Video and Screenshots (4:17)
70: Text Boxes and Pull Quotes (4:45)
71: WordArt and Text Effects (4:37)
72: Shapes (7:15)
73: SmartArt (6:21)
74: Sharing Documents (8:40)
75: Co-authoring (6:31)
76: Track Changes (4:25)
77: Review Markups (5:50)
78: Merge Changes from Other Documents (4:10)
79: Captions (4:32)
80: Cross-References (3:59)
81: Bookmarks (5:22)
82: Hyperlinks (4:58)
83: Footnotes an Endnotes (4:44)
84: Citations and Bibliography (6:10)
85: Suppressing Information (7:14)
86: Formatting and Editing Restrictions (7:00)
87: Restrict Document Access (3:02)
88: Digital Signatures (7:08)
89: Using Forms (12:10)
90: Modifying Forms (2:41)
91: Using Macros (6:48)
92: Creating Macros (14:59)