17.2 Creating Formulas By Calculating Across Worksheets, Manually

Computer Skills for The Real World (IL.21-22.09.13)

Welcome & Getting Started

Welcome & Program Overview (18:29)
How To Get The Most Out Of This Class (18:12)
Course Outline
Class Schedule
Toolbox (Course Handouts & More)

Module 1: Toolbox

Toolbox
Link To The 9/13/21 Live Online Instructor-led Class (10:00 AM Central)

Module 1: History of Computers & Internet

1.1 Recorded Instructor-led Class (38:10)
1.2 History of Computers (14:39)
1.3 History of The Internet (28:54)
Module 2 Preparations

Module 1: Study Guide Answers

Module 1: Study Guide Answers

Module 2: Toolbox

Module 2: Toolbox
Link To The 9/20/21 Live Online Instructor-led Class (10:00 AM Central)

Module 2: Social Media & Email Etiquette

2.1 Recorded Online Instructor-led Class Session (10:06)
2.2 Email Do's (14:30)
2.3 Email Don'ts (7:10)
2.4 Additional Email Best Practices (3:13)

Module 2: Study Guide Answers

Module 2: Study Guide Answers

Modules 1 & 2 Knowledge Assessment (Quiz)

Modules 1 & 2 Knowledge (Quiz)

Module 3: Toolbox

Toolbox
Link To The 9/27/21 Live Online Instructor-led Class (10:00 AM Central)

Module 3: Computer Basics: Files, Folders, Drives, & File Explorer

3.1 Recorded Online Instructor-led Class Session (33:11)
3.2 Computer Drives, Folders, & Files (6:11)
3.3 Creating, Naming, Renaming, & Deleting Folders (6:57)
3.4 Selecting Folders (3:09)
3.5 Moving Folders (9:02)
3.6 Copying Folders (7:35)
3.7 Working with Files (8:04)

Module 3: Study Guide Answers

Module 3: Study Guide Answers

Module 4: Toolbox

Toolbox
Link To The 10/4/21 Live Online Instructor-led Class (10:00 AM Central)

Module 4: Outlook Basics

4.1 Recorded Online Instructor-led Class Session (22:32)
4.2 Creating The Class Desktop Files (3:56)
4.3 Creating An Email Message (1:43)
4.4 Parts of The Email Message (5:29)
4.5 Opening & Previewing Email Messages (5:29)
4.6 Responding to Email Messages (Reply, Reply All, & Forward) (7:57)
4.7 Deleting Email Messages (4:08)
4.8 Working With Folders (9:51)
4.9 Moving Email Messages Into Folders (6:31)
4.10 Printing Email Messages (3:10)
4.11 Working With Email Attachments (5:29)

Module 4: Study Guide Answers

Module 4: Study Guide Answers

Module 3 & 4 Knowledge Assessment (Quiz)

Knowledge Assessment (Quiz)

Module 5: Toolbox

Toolbox
Link To The 10/11/21 Live Online Instructor-led Class (10:00 AM Central)

Module 5: Introduction To Excel Interface & Basics

5.1 Recorded Online Instructor-led Class (38:35)
5.2 Worksheets Vs. Workbooks, Active Worksheets, Menus, & Ribbons (5:35)
5.3 Quick Access Toolbar, Title Bar, Window Commands, Name Box, & Formula Bar (6:24)
5.4 Name Box & The Active Cell (1:15)
5.5 Cell Addresses (4:53)
5.6 Formula Bar, Scroll Bars, View & Zoom Controls, Status Bar, & Backstage View (6:48)
5.7 Cell Ranges & Regions (5:13)
5.8 Creating & Opening Workbooks (3:11)
5.9 Optional Video - Help With The Activity in Module 5, Pages 16-17

Module 5: Study Guide Answers

Module 5: Study Guide Answers

Module 6: Toolbox

Toolbox
Link To The 10/18/21 Live Online Instructor-led Class (10:00 AM Central)

Module 6: Excel Basics

6.1 Recorded Online Instructor-led Class (36:54)
6.2 Selecting Cells, Select All, & Mouse Cursor Shapes (8:10)
6.3 Mouse To Select Cells & Navigate (10:40)
6.4 Keyboard To Select Cells & Navigate (7:40)
6.5 Cell Content (9:45)
6.6 Undo & Repeat Features (3:22)
6.7 Save, Save As, & The Help Feature (11:41)

Module 6: Study Guide Answers

Module 6: Study Guide Answers

Module 5 & 6 Knowledge Assessment (Quiz)

Module 5 & 6 Knowledge Assessment

Module 1 - 6 Knowledge Assessment (Test)

Module 1 Through 6 Knowledge Assessment (Test)

Module 7: Toolbox

Module 7: Toolbox
Link To The 10/25/21 Live Online Instructor-led Class (10:00 AM Central)

Module 7: Checkpoint Recap & Record Keeping Tools

7.1 Recorded Online Instructor-led Class (42:43)
7.2 Easy Homeschool Attendance Tracker (13:21)
7.3 Overview of the Basic Student Grade Book (6:53)
7.4 Grading Student Schoolwork (4:06)
7.5 Enter Student Name & Class Information (4:09)
7.6 The Grading Scale for the Basic Student Grade Book (1:09)
7.7 Assigning Course Work Weights Inside The Basics Student Grade Book (12:44)
7.8 Saving & Reusing The Basic Student Grade Book (7:26)

Module 8: Toolbox

Toolbox
Link To The 11/1/21 Live Online Instructor-led Class (10:00 AM Central)

Module 8: Excel Editing Data & Performing Calculations

8.1 Instructor-led Class (23:16)
8.2 Entering & Editing Data (3:11)
8.3 Moving, Copying, & Renaming Worksheets (11:57)
8.4 Navigating Using Worksheet Tabs (6:06)
8.5 Creating Formulas, Basic Mathematical Operators, & Cell References Vs. Constant Numbers (15:46)
8.6 Order of Operation (4:46)
8.7 Module 8 Recap (8:59)

Module 8: Study Guide Answers

Module 8: Study Guide Answers

Module 9: Toolbox

Module 9: Toolbox
Link To The 11/8/21 Live Online Instructor-led Class (10:00 AM Central)

Module 9: Excel Functions, Formulas, Copying, & Moving

9.1 Recorded Instructor-led Class (32:13)
9.2 Using Functions (8:20)
9.3 AutoSum (8:12)
9.4 The Formula Bar & Insert Function Button (7:19)
9.5 AutoComplete (3:54)
9.6 Formulas Tab & Ribbon (1:46)
9.7 Reusing Formulas (1:17)
9.8 Copying Formulas (10:34)
9.9 Autofill To Copy (6:12)
9.10 Moving Cell Content & Formulas (7:41)
9.11 Using Paste Special (9:35)

Module 9: Study Guide Answers

Module 9: Study Guide Answers

Module 8 & 9 Knowledge Assessment (Quiz)

Modules 8 & 9 Knowledge Assessment (Quiz)

Module 10: Toolbox

Toolbox
Link To The 11/15/21 Live Online Instructor-led Class (10:00 AM Central)

Module 10: Excel Absolute & Relative Formulas & Module 5 Through 10 Review

10.1 Recorded Instructor-led Class (25:14)
10.2 Absolute & Relative Formulas (7:06)

Module 10: Study Guide Answers

Study Guide Answers

Module 5 - 10 Knowledge Assessment (Test)

Module 5 Through 10 Knowledge Assessment (Test)

Module 11: Toolbox

Toolbox
Link To The 11/15/21 Live Online Instructor-led Class (10:00 AM Central)

Module 11: Autofill & Creating Charts

11.1 Recorded Instructor-led Class (28:54)
11.2 Formulas & Autofill (3:21)
11.3 Dates & Autofill (2:12)
11.4 Months and Autofill (1:24)
11.5 Quarters and Autofill (1:35)
11.6 Times & Autofill (3:54)
11.7 Custom Lists & Autofill (2:38)
11.8 Numeric Info & Autofill (6:54)
11.9 Creating Chart Sheets (7:29)
11.10 Creating Embedded Charts (10:27)
11.11 Module Recap (4:45)

Module 11: Study Guide Answers

Study Guide Answers

Module 12: Toolbox

Toolbox
Link To The 11/29/21 Live Online Instructor-led Class (10:00 AM Central)

Module 12: Modifying Worksheets

12.1 Recorded Instructor-led Class (30:53)
12.2 Naming Cells (11:50)
12.3 Inserting & Deleting Columns & Rows (5:14)
12.4 Clearing Cell Information (2:28)
12.5 Transposing Cell Information (3:37)
12.6 Spell Check (7:19)
12.7 Find & Replace (4:48)
12.8 Column Widths & Row Heights (7:18)
12.9 Hiding Columns & Rows (3:29)

Module 12: Study Guide Answers

Study Guide Answers

Module 10 - 12 Knowledge Assessment (Quiz)

Module 10 - 12 Knowledge Assessment (Quiz)

Module 13: Toolbox

Toolbox
Link To The 12/6/21 Live Online Instructor-led Class (10:00 AM Central)

Module 13: Enhancing Worksheet Appearances

13.1 Recorded Instructor-led Class (19:30)
13.2 Applying Borders (9:47)
13.3 Applying Cell & Font Colors (5:46)
13.4 Modifying Cell Alignment Part 1 of 2 (7:06)
13.5 Modifying Cell Alignment Part 2 of 2 (2:23)
13.6 Bolding, Italicizing, & Underlining (1:56)
13.7 Changing Fonts & Font Size (4:02)
13.8 Modifying Numeric Information (2:19)
13.9 Repeating Cell Format (3:49)
13.10 Formatting Cells Using A Dialog Box (3:49)

Module 13: Study Guide Answers

Study Guide Answers

Module 14: Toolbox

Toolbox
Link To The 12/6/21 Live Online Instructor-led Class (10:00 AM Central)

Module 14: Printing Worksheets & Workbooks, Combining & Separating Cell Information

14.1 Instructor-led Session (13:54)
14.2 Overview of Print Features (3:49)
14.3 Printing Worksheets (6:49)
14.4 Changing Print Orientation (3:06)
14.5 Adjusting Page Margins (5:37)
14.6 Altering The Size Of The Print Area (2:10)
14.7 Fitting Content To The Page Size (4:09)
14.8 Inserting Headers & Footers (9:06)
14.9 Repeating Column & Row Titles (3:36)
14.10 Recap of Print Features (5:57)

Module 14: Study Guide Answers

Study Guide Answers

Module 15: Toolbox

Toolbox
Link To The 12/13/21 Live Online Instructor-led Class (10:00 AM Central)

Module 15: Combining & Separating Cell Information

15.1 Recorded Instructor-led Session (16:16)
15.2 Combining Cell Information (18:36)
15.3 Separating Cell Information (11:09)
15.4 Copying Formula Values (5:39)

Module 15: Study Guide Answers

Study Guide Answers

Module 13 - 15 Knowledge Assessment (Quiz)

Modules 13-15 Knowledge Assessment

Module 16: Toolbox

Toolbox
Link To The 12/13/21 Live Online Instructor-led Class (10:00 AM Central)

Module 16: Working With Comments

16.1 Instructor-led Class (22:35)
16.2 Overview of Excel Comments (3:23)
16.3 Inserting Comments (4:15)
16.4 Editing Comments (2:46)
16.5 Removing Comments (3:09)
16.6 Moving From Comment to Comment (2:44)
16.7 Working with Comments Recap (2:16)

Module 16: Study Guide Answers

Study Guide Answers

Module 17: Toolbox

Toolbox
Link To The 1/10/22 Live Online Instructor-led Class (10:00 AM Central)

Module 17: Calculating Data Across Worksheets

17.1 Recorded Instructor-led Class (19:08)
17.2 Creating Formulas By Calculating Across Worksheets, Manually Typing or Using Your Mouse To Create These Formulas (10:46)
17.3 Using Named Cells To Create Formulas With Data From Different Worksheets (9:23)
17.4A Using Functions To Calculate Data From Different Worksheets (6:16)
17.4B Using Functions When Data Is Located On The Same Cell On Each Worksheet (5:29)
17.5 Automatically Update Text Information Housed Elsewhere (10:17)
17.6 Creating Calculations From Data Located On Other Workbooks (9:48)
17.7 Quickly Adding Worksheets To A Workbook (0:59)

Module 17: Study Guide Answers

Study Guide Answers

Module 18: Toolbox

Toolbox
Link To The 1/10/22 Live Online Instructor-led Class (10:00 AM Central)

Module 18: Module 5 Through 18 Review

18.1 Recorded Instructor-led Class (Modules 5 Through 18 Review) (27:14)

Module 18 Knowledge Assessment (Test Over Modules 5 Through 18)

Knowledge Assessment (Test)

Module 18: Study Guide Answers

Study Guide Answers

Module 19: Toolbox

Toolbox
Link To The 1/17/22 Live Online Instructor-led Class (10:00 AM Central)

Module 19: Sorting & Filtering Data

19.1 Recorded Instructor-led Class (15:31)
19.2 Sorting Data (16:15)
19.3 Filtering Data (16:07)

Module 19: Study Guide Answers

Study Guide Answers

Knowledge Assessment (Quiz): Modules 17 - 19

Knowledge Assessment (Quiz): Modules 17-19

Module 20: Toolbox

Toolbox
Link To The 1/24/22 Live Online Instructor-led Class (10:00 AM Central)

Module 20: Working With IF Statements

20.1 Recorded Instructor-led Class (19:34)
20.2 Working With IF Statements (10:38)
20.3 Working With Text IF Statements (8:41)
20.4 Working With Calculated IF Statements (9:27)
20.5 Working With Combination IF Statements (7:32)
20.6 Creating IF Statements (8:12)
20.7 Editing IF Statements (6:12)

Module 20: Study Guide Answers

Study Guide Answers

Module 21: Toolbox

Toolbox
Link To The 1/24/22 Live Online Instructor-led Class (10:00 AM Central)

Module 21: Introduction To Microsoft PowerPoint

21.1 Recorded Instructor-led Class (24:01)
21.2 Exploring The PowerPoint Environment (14:28)
21.3 Creating A New Presentation & Opening An Existing Presentation (4:50)
21.4 Saving Your Work (9:59)
21.5 Closing A Presentation & Closing The PowerPoint Software Program (3:27)

Module 21: Study Guide Answers

Study Guide Answers

Module 22: Toolbox

Toolbox
Link To The 1/31/22 Live Online Instructor-led Class (10:00 AM Central)

Module 22: Creating New Presentations & Copying & Moving Slides in Microsoft PowerPoint

22.1 Recorded Instructor-led Class (25:07)
22.2 Creating A Presentation (5:30)
22.3 Adding A Slide (5:16)
22.4 Editing A Slide & Its Layout (4:46)
22.5 Duplicating A Slide (3:41)
22.6 Deleting A Slide (3:04)
22.7 Copying Slides (6:41)
22.8 Moving Slides (7:27)

Module 22: Study Guide Answers

Study Guide Answers

Module 23: Toolbox

Toolbox
Link To The 2/7/22 Live Online Instructor-led Class (10:00 AM Central)

Module 23: Presentation Best Practices & Viewing Presentations in Microsoft PowerPoint

23.1 Recorded Instructor-led Class (25:17)
23.2 Viewing Options (8:49)
23.3 Starting Presentations (4:58)
23.4 Moving Within The Presentation (11:14)
23.5 Changing Presentation Background Colors Quickly (3:46)

Module 23: Study Guide Answers

Study Guide Answers

Knowledge Assessment (Quiz): Modules 22 - 23

Knowledge Assessment (Quiz): Modules 22 - 23

Module 24: Toolbox

Toolbox
Link To The 2/14/22 Live Online Instructor-led Class (10:00 AM Central)

Module 24: Enhancing Text in Microsoft PowerPoint

24.1 Recorded Instructor-led Class (26:40)
24.2 Changing Font Styles & Sizes (6:09)
24.3 Clearing Font Formatting (2:12)
24.4 Bulleting & Numbering Lists (5:27)
24.5 Changing List Levels (5:05)
24.6 Adjusting Line Spacing (9:21)
24.7 Changing Text Direction (2:00)
24.8 Part 1 Applying Character Formatting (8:36)
24.8 Part 2 Applying Character Formatting (6:56)
24.9 Modifying Text Alignment (2:38)

Module 24: Study Guide Answers

Study Guide Answers

Module 25: Toolbox

Toolbox
Link To The 2/21/22 Live Online Instructor-led Class (10:00 AM Central)

Module 25: Exploring Graphic & Animation Options in Microsoft PowerPoint

25.1 Recorded Instructor-led Class (29:59)
25.2 Inserting Pictures, Shapes, & SmartArt (21:19)
25.3 Resizing Graphic Objects & Resizing Graphic Objects Proportionately (7:53)
25.4 Rotating, Deleting & Moving Pictures & Graphic Objects (4:41)
25.5 Selecting & Grouping Multiple Pictures & Objects (5:02)
25.6 Assigning Single Animation (14:03)
25.7 Displaying The Animation Pane & Reordering, Removing, & Triggering Animation (13:12)
25.8 Changing Effect Options (3:11)
25.9 Assigning Multiple Animation To A Slide Item (6:29)
25.10 Modifying The Slide Background & Applying Slide Transitions (8:23)

Module 25: Study Guide Answers

Study Guide Answers

Module 26: Toolbox

Toolbox
Link To The 2/28/22 & 3/7/22 Live Online Instructor-led Class (10:00 AM Central)

Module 26: Printing & Checking Spelling Accuracy in Microsoft PowerPoint

26.1 Recorded Instructor-led Class (7:11)
26.2 Printing Microsoft PowerPoint Presentations (5:06)
26.3 Checking Spelling Accuracy (6:22)

Module 26: Study Guide Answers

Study Guide Answers

Knowledge Assessment (Test): Modules 22 - 26

Knowledge Assessment (Test): Modules 22 - 26

Module 27: Toolbox

Toolbox
Link To The 3/14/22 Live Online Instructor-led Class (10:00 AM Central)

Module 27: Introduction to Microsoft Word

27.1 Recorded Instructor-led Class (13:32)
27.2 Introduction to Microsoft Word (2:13)
27.3 Microsoft Word Menus & Ribbons (3:00)
27.4 Microsoft Office Software Similarities (1:11)
27.5 Selecting Text Using Your Keyboard (2:13)
27.6 Selecting Text Using Your Mouse (2:14)
27.7 Paragraph Spacing (2:03)
27.8 Paragraph Alignment (3:09)

Module 27: Study Guide Answers

Study Guide Answers

Module 28: Toolbox

Toolbox
Link To The 3/21/22 Live Online Instructor-led Class (10:00 AM Central)

Module 28: Working with Paragaraphs, Pages, Text, Spacing, Indentation & Tabs in Microsoft Word

28.1 Recorded Instructor-led Class (8:47)
28.2 Identifying Paragraphs & Other Indicators (9:53)
28.3 Selecting Text (8:30)
28.4 Paragraph Spacing (8:02)
28.5 Indenting Paragraphs (12:16)
28.6 Working with Tabs & Displaying The Ruler (13:59)
28.7 Working with Different Tab Types & The Ruler (11:23)
28.8 Working With Different Tab Types & The Dialog Box (12:49)

Module 28: Study Guide Answers

Study Guide Answers

Module 29: Toolbox

Module 29: Toolbox
Link To The 3/28/22 Live Online Instructor-led Class (10:00 AM Central)

Module 29: Formatting Text in Microsoft Word

29.1 Recorded Instructor-led Class (19:58)
29.2 Changing Font Style, Size, & Color (14:49)
29.3 Changing Case (9:07)
29.4 Bolding, Italicizing, & Underling (7:48)
29.5 Using Strikethrough, Subscript, & Superscript (8:13)
29.6 Adding Bullets & Numbering (17:03)
29.7 Working with Text Effects (5:39)
29.8 Highlighting Text (5:09)
29.9 Aligning Text (9:19)
29.10 Changing Paragraph Backgrounds (6:55)

Module 29: Study Guide Answers

Study Guide Answers

Knowledge Assessment (Quiz): Modules 27 - 29

Knowledge Assessment (Quiz): Modules 27 - 29

Module 30: Toolbox

Module 30: Toolbox
Link To The 4/4/22 Live Online Instructor-led Class (10:00 AM Central)

Module 30: Hyphenation, Drop Caps, Borders, & Easy Formatting

30.1 Recorded Instructor-led Class (3:04)
30.2 Keeping Hyphenated Words Together (3:22)
30.3 Inserting Symbols (7:37)
30.4 Adding & Editing Drop Caps (7:35)
30.5 Applying A Page Border (8:43)
30.6 Applying A Paragraph Border (8:02)
30.7 Using The Format Painter (5:17)
30.8 Working with Pre-Defined Styles (7:40)
30.9 Applying & Customizing A Document Design (5:44)
30.10 Clearing All Formatting (3:15)

Module 30: Study Guide Answers

Study Guide Answers

Module 31: Toolbox

Module 31: Toolbox
Link To The 4/11/22 Live Online Instructor-led Class (10:00 AM Central)

Module 31: Working with Headers, Footers, Page Numbers, Section Breaks, Columns, & Tables

31.1 Recorded Instructor-led Class (21:23)
31.2 Working with Headers & Footers (15:40)
31.3 Adding & Resetting Page Numbers (8:03)
31.4 Applying Page & Section Breaks (14:59)
31.5 Using Section Breaks with Headers, Footers, & Page Numbers (13:15)
31.6 Page Set-up Features (14:55)
31.7 Working with Columns (11:01)
31.8 Inserting Tables (16:23)

Module 31: Study Guide Answers

Study Guide Answers

Module 32: Toolbox

Module 32: Toolbox
Link To The 4/18/22 Live Online Instructor-led Class (10:00 AM Central)

Module 32: Working with Footnotes, Endnotes, & Tables of Contents in Microsoft Word

32.1 Recorded Instructor-led Class (25:04)
32.2 Adding Footnotes & Endnotes (13:05)
32.3 Formatting Footnotes & Endnotes (6:38)
32.4 Adding & Updating Tables of Contents (13:12)

Module 32: Study Guide Answers

Study Guide Answers

Knowledge Assessment: Modules 30 - 32

Knowledge Assessment: Modules 30 - 32

Module 33: Toolbox

Module 33: Toolbox
Link To The 4/25/22 Live Online Instructor-led Class (10:00 AM Central)

Module 33: Polishing Your Document

33.1 Recorded Instructor-led Class (8:53)
33.2 Increasing & Decreasing Font Sizes (9:30)
33.3 Applying Page Borders & Colors (10:04)
33.4 Adding A Document Theme/Color Theme (11:14)
33.5 Using Spell Check (5:42)
33.6 Using the Thesaurus (2:14)
33.7 Moving & Copying Text
33.8 Adding Columns to Your Document (7:31)
33.9 Using the Go To Feature (3:35)
33.10 Changing Margins & Document Orientation (7:28)
33.11 Working with the Print Features (6:10)
33.12 Working with Save & Save As Features (15:38)

Module 33: Study Guide Answers

Study Guide Answers

Module 34: Toolbox

Module 34: Toolbox
Link To The 5/2/22 Live Online Instructor-led Class (10:00 AM Central)

Module 34: Pulling It All Together To Create Business Proposals & Research Papers (Part I)

34.1 Recorded Instructor-led Session
34.2 Selecting Document Content (10:47)
34.3 Paragraph Spacing (8:07)
34.4 Creating Custom Tabs (24:14)
34.5 Indenting Paragraphs (5:18)
34.6 Adding Space for Binding Materials (6:32)
34.7 Adding Page & Section Breaks (17:52)
34.8 Using Section Breaks to Center Cover Page Content (13:51)

Module 34: Study Guide Answers

Study Guide Answers

Module 35: Toolbox

Module 35: Toolbox
Link To The 5/9/22 Live Online Instructor-led Class (10:00 AM Central)

Module 35: Pulling It All Together To Create Business Proposals & Research Papers (Part II)

35.1 Recorded Instructor-led Session (14:52)
35.2 Creating Different Document Headers & Footers (14:41)
35.3 Adjusting Page Numbers (11:50)
35.4 Changing Page Orientation (4:51)
35.5 Working With Columns (11:01)
35.6 Assigning A Text Style (17:03)
35.6 Assigning A Text Style (7:40)
35.7 Applying A Document Design (5:44)
35.8 Adding & Updating Tables of Contents (13:12)
35.9 Inserting Footnotes & Endnotes (13:05)
35.10 Reorganizing Document Content
35.11 Customizing Bullets (17:03)

Module 35: Study Guide Answers

Study Guide Answers

Knowledge Assessment (Test): Modules 27 - 35

Knowledge Assessment (Test): Modules 27 - 35

Module 36: Toolbox

Link To The 5/16/22 Live Online Instructor-led Class (10:00 AM Central)

Module 36: Microsoft Word Review

36.1 Microsoft Word Review (58:21)

BONUS CONTENT! Module 37: Toolbox

Module 37: Toolbox

Module 37: Creating Mail Merges

37.1 Recorded Instructor-led Class (58:21)
37.2 Mail Merge Basics (7:11)
37.3 Identifying A Data Source (3:38)
37.4 Initiating The Mail Merge (9:05)
37.5 Inserting Merge Fields (9:48)
37.6 Merging The Data Source & File Info (4:50)
37.7 Mail Merge Troubleshooting Tip (2:54)
37.8 Previewing Merged Information (5:12)

Module 37: Study Guide Answers

Study Guide Answers

17.2 Creating Formulas By Calculating Across Worksheets, Manually Typing or Using Your Mouse To Create These Formulas

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock