Create Tables and Import Files from Excel | Inspire Learning Solutions

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Introduction to Computer Applications

Computer Applications Class Downloads

Computer Applications Training Manual

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

Database Design Fundamentals (2:22)
Create Tables and Import Files from Excel (4:17)
Create Queries and Export Files to Excel (2:42)
Create and Modify Forms (4:31)
Create and Modify Reports (6:55)
Access Project: Create a Database with Table Relationships (6:03)

Lectures and Case Studies

Why Icy Hot Doesn't Pay for Advertising (3:22)

Teach online with

Create Tables and Import Files from Excel

Complete and Continue