Lessons

Viewing Times

Getting Started with Excel 2007

Lesson 1:  Getting Started

5:41

   Starting Excel

   Getting Familiar with the Excel 2007 Interface

   Customize the Interface

   Using Shortcut Keys

Lesson 2:  Working with Worksheets

8:38

   Navigate Worksheets

   Rename or Delete Worksheets

   Hide Worksheets

   Move or Copy Worksheets

   Change Worksheet Tab Colors

Lesson 3:  Templates and Closing Excel

3:09

Working with Spreadsheets

Lesson 4:  Entering Data and Worksheet Navigation

3:54

Lesson 5:  Insert Different Types of Data

3:27

Automatic Data Entry Methods

4:50

   Contiguous

   Non-Contiguous

   Name a Range

3:37

   Use the Clipboard

   Use Ctrl+Enter

4:50

   Use AutoFill to enter data

   Use AutoFill to enter a series

   Create a Custom Series

2:14

Formatting Cells

Lesson 10:  Using the Font Grouping and Dialog Box

4:23

Lesson 11:  Using the Alignment Grouping and Dialog Box

3:37

Lesson 12:  Using the Number Grouping and Dialog Box

2:31

Lesson 13:  Row Height, Column Width & Hide/Unhide

3:14

Conditional Formatting

Lesson 14:  Formatting a Data Bar

4:16

   What is Conditional Formatting?

   Formatting a Data Bar

Lesson 15:  Format with Color Scales and Icon Sets

3:32

Lesson 16:  Highlight Cell Rules

3:37

Lesson 17:  Top/Bottom Rules

4:22

Lesson 18:  Manage Multiple Conditional Formatting Rules

2:47

Basic Excel Formulas

5:50

   What is a Formula?

   Operators

   Enter and Edit Formulas

8:22

Using Basic Excel Functions

5:34

   What is a Function?

   Insert a Function

   Using AutoSum

5:09

   Commonly Used Functions

   Status Bar Function Results

Excel Function Groups

Lesson 23:  The Function Library and Financial Functions

4:22

Lesson 24:  Logical Functions

4:17

Lesson 25:  Text and Date Functions

4:12

Using Tables To Sort & Filter Data

4:00

   Ascending/Descending Sorts

   Using Table Column Headers

2:45

   Sort by Multiple Columns

   Sort by Color

4:09

   Custom Filters

Creating Pivot Tables

Lesson 29:  Understanding Pivot Tables

2:48

Lesson 30:  Create a Simple Pivot Table

3:22

Lesson 31:  Update Your Pivot Table

2:51

Protecting Your Workbook and Worksheets

5:57

   Password Protect Your Workbook

3:59

   Sort by Multiple Columns

   Sort by Color

5:00

   Lock or Unlock Cells

   Protect Your Worksheets

Changing The View

4:22

   Changing Workbook Views

   Different Workbook Views

Lesson 36:  Zoom Control and Show/Hide Options

2:41

Lesson 37:  Window Options

5:34

   Freeze Headings

   Split The Window

   Additional Window Options

Insert Illustrations and SmartArt

3:52

   Insert Pictures

   Insert Clip Art

   Insert Shapes

6:56

   Picture & ClipArt Formatting Options

5:06

4:29

Basic Charting

6:08

   Chart Types

   Chart Terminology

5:13

   Create a Pie Chart

   Create a Column Chart

   Make Some Design Changes

Advanced Chart Formatting

10:20

2:06

Printing Your Worksheets

4:59

   Using Print Preview

   Portrait or Landscape

   Define Print Areas

   Change Print Areas

3:26

   The Page Tab

   The Margins Tab

7:12

   The Header/Footer Tab

   The Sheet Tab

3:34

Proofing, Excel Options and Help

4:07

   Spell Check

   Thesaurus

   Translate