Computer Applications Class Downloads
Word Fundamentals
-
Lesson 1: Cover Sheets (2:09)
-
Lesson 2: Create an Outline (2:26)
-
Lesson 3; Keep Text Aligned by using Tab Stops (2:30)
-
Lesson 4: Create and Modify Tables (3:12)
-
Lesson 5: Create and Modify Charts (2:57)
-
Lesson 6: SmartArt Graphics (2:51)
-
Lesson 7: Divide Text into Columns (4:48)
-
Lesson 8: Create a Flowchart using Shapes (5:03)
-
Lesson 9: Add Headers, Footers and Page Numbers (2:19)
-
Lesson 10: Create a Table of Contents and an Index (2:24)
-
Lesson 11: Create Emails using Mail Merge (4:07)
-
Lesson 12: Create Letters using Mail Merge (3:47)
Excel Fundamentals
-
Excel for Business Activity Book
-
Lesson 1: Entering Data and Formatting Cells (5:31)
-
Lesson 2: Cut, Copy, Paste and Paste Special (4:37)
-
Lesson 3: Create and Manage a Data List (4:19)
-
Lesson 4: Introduction to Formulas and Functions (2:34)
-
Lesson 5: Separate Data using Text-to-Columns (3:23)
-
Lesson 6: Combine Data using Text Functions (5:13)
-
Lesson 7: Input Data using a Table (3:54)
-
Lesson 8a: Filtering Data (1:11)
-
Lesson 8b: Sorting Data (0:37)
-
Lesson 8c: Using the SUBTOTAL function (1:32)
-
Lesson 8d: Advanced Filters (1:53)
-
Lesson 9: Absolute and Mixed Cell References (2:01)
-
Lesson 10a: Retrieve Data using VLOOKUP (4:35)
-
Lesson 10b: Advanced VLOOKUP Skills and Techniques (3:05)
-
Lesson 11: Create Outlines and Subtotals (1:31)
-
Lesson 12: Apply Conditional Formatting (2:39)
-
Lesson 13: Combine Worksheets using Consolidate (2:21)
-
Lesson 14: Introduction to Charts (2:38)
-
Lesson 15: What is a PivotTable? (3:29)
-
Lesson 16: Printing Worksheets (5:56)
Introduction to PivotTables
-
PivotTable Practice Files
-
Lesson 1: Summary Reports (1:49)
-
Lesson 2: Calculated Fields (3:06)
-
Lesson 3: Organize Data into Groups (2:21)
-
Lesson 4: Display Percentage of Totals (2:15)
-
Lesson 5: Display Multiple Value Calculations (2:09)
-
Lesson 6: Report Filter Pages (2:16)
-
Lesson 7: Filter Data using Timelines and Slicers (2:53)
-
Lesson 8: Introduction to PivotCharts (4:03)
PowerPoint Fundamentals
-
Lesson 1: Designs and Layouts (3:32)
-
Lesson 2: Text Box Animations (5:07)
-
Lesson 3: Create and Format Tables (2:46)
-
Lesson 4: Create Charts with Animations (5:33)
-
Lesson 5: Add Photos and SmartArt Graphics (2:39)
-
Lesson 6: Motion Path Animations (3:25)
-
Lesson 7: Record Slide Presentations with Voice Narration (2:34)
-
Lesson 8: Custom Presentations and Slide Transitions (3:28)
-
Lesson 9: Create Presentations using an Outline (3:25)
-
Lesson 10: Exporting and Printing Presentations (1:37)
Database Design using Access
Lectures and Case Studies
