37.5 Merging the Data Source & File Info

Computer Skills for The Real World (SP21.22)

Welcome & Getting Started

Welcome & Program Overview (22:04)
How To Get The Most Out Of This Class (15:47)
Course Outline
Toolbox (Course Handouts & More)

Module 1: Toolbox

Toolbox

Module 1: History of Computers & Internet

1.1 Recorded Instructor-led Class (22:04)
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

Module 2: Social Media & Email Etiquette

2.1 Recorded Online Instructor-led Class Session (10:06)
2.1 B Study Guide Info - Questions 18-23 (8:35)
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

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

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

Module 5:

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)

Module 5: Study Guide Answers

Module 5: Study Guide Answers

Module 6: Toolbox

Toolbox

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

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

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

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

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

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

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

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

Module 14: Printing Worksheets & Workbooks

14.1 Instructor-led Class (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

Module 15: Combining & Separating Cell Information

15.1 Recorded Instructor-led Class (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)

Module 13 - 15 Knowledge Assessment

Module 16: Toolbox

Toolbox

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

Module 17: Calculating Data Across Worksheets

17.1 Recorded Instructor-led Class (19:08)
17.2 & 17.3 Calculating Data Across Worksheets & 17.3 Using Your Mouse To Create Formulas With Data From Different Worksheets (10:46)
17.4 Using Named Cells To Create Formulas With Data From Different Worksheets (9:23)
17.5A Using Functions To Caculate Data From Different Worksheets (6:16)
17.5B Using Functions To Calculate Data From Different Worksheets (5:29)
17.6 Automatically Update Text Information Housed Elsewhere (10:17)
17.7 Creating Calculations From Data Located On Other Workbooks (9:48)
17.8 Quickly Adding Worksheets To A Workbook (0:59)

Module 17: Study Guide Answers

Study Guide Answers

Module 18: Toolbox

Toolbox

Module 18: Module 5 Through 17 Review

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

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

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

Module 19: Toolbox

Toolbox

Module 19: Class

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

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 Statement (8:12)
20.7 Editing IF Statements (6:12)

Module 20: Study Guide Answers

Study Guide Answers

Module 21: Toolbox

Toolbox

Module 21: Introduction To PowerPoint

21.1 Introduction To PowerPoint (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

Module 22: Creating New Presentations & Copying & Moving Slides

22.1 Recorded Instructor-led Class (25:07)
22.2 Creating A New 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

Module 23: Presentation Best Practices & Viewing Presentations in 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 Modules 22 & 23 (Quiz)

Module 24: Toolbox

Toolbox

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

Module 25: Exploring Graphic & Animation Options

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 Animations 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

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

Module 27: Introduction to Microsoft Word

27.1 Introduction to Microsoft Word (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

Module 28: Working with Paragraphs, Pages, Text, Spacing, Indentations & 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

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, & Underlining (7:48)
29.5 Using Strikethrough, Subscript, & Superscript (8:13)
29.6 Adding Bullets & Numbers (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

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

Module 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

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)

Study Guide Answers

Study Guide Answers

Module 32: Toolbox

Module 32: Toolbox

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 (Quiz): Modules 30 - 32

Knowledge Assessment (Quiz): Modules 30 - 32

Module 33: Toolbox

Module 33: Toolbox

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.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 the Save & Save As Features (15:38)

Module 33: Study Guide Answers

Study Guide Answers

Module 34: Toolbox

Module 34: Toolbox

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

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 - New (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

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 Adding Columns to Selected Text (11:01)
35.6 Assigning a Text Style (7:40)
35.7 Applying a Document Design (5:44)
35.8 Adding & Updating a Table of Contents (13:12)
35.9 Inserting Footnotes & Endnotes (13:05)
35.11 Customizing Bullets (17:03)

Module 35: Study Guide Answers

Study Guide Answers

Module 36: Toolbox

Module 36: Toolbox

Module 36: Microsoft Word Review

36.1 Recorded Instructor-led Session (58:21)

Knowledge Assessment (Test): Modules 27-35

Knowledge Assessment (Test): Modules 27-35

BONUS CONTENT Module 37: Toolbox

Module 37: Toolbox

BONUS CONTENT Module 37: Mail Merges Using Microsoft Word & Excel

37.1 Mail Merge Basics (7:11)
37.2 Identifying a Data Source (3:38)
37.3 Initiating The Mail Merge (9:05)
37.4 Inserting Field Codes (9:48)
37.5 Merging the Data Source & File Info (4:50)
37.6 Mail Merge Troubleshooting Tip (2:54)
37.7 Previewing Merged Information (5:12)

Module 37: Study Guide Answers

Study Guide Answers

37.5 Merging the Data Source & File Info

Lesson content locked

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

Enroll in Course to Unlock