Microsoft Office® - Excel 2007

Lessons

Viewing Times

ClipNotes

The Basics of Workbooks and Worksheets

Lesson 1: 

5:40

 ClipNotes
Close

Getting Started

In this lesson we will cover the following objectives:

  • Starting Excel
  • Getting Familiar with the Excel 2007 Interface
  • Customize the Interface

  • Using Shortcut Keys

 
Lesson 2: 
Working with Worksheets

Free Training

Close
First Name:
Last Name:
Email:

* This information will be used to create a free ClipTraining account. You'll receive premium content via Clip of the Week. You are under no obligation and may unsubscribe at any time.

8:39

 ClipNotes
Close

Working with Worksheets

In this lesson we will cover the following objectives:

  •  Navigate Worksheets
  •  Rename or Delete Worksheets
  •  Hide Worksheets
  •  Move or Copy Worksheets
  •  Change Worksheet Tab Colors
 
Lesson 3: 
Templates and Closing Excel

Free Training

Close
First Name:
Last Name:
Email:

* This information will be used to create a free ClipTraining account. You'll receive premium content via Clip of the Week. You are under no obligation and may unsubscribe at any time.

3:08

 ClipNotes
Close

Templates and Closing Excel

In this lesson we will cover the following objectives:

  • Using Templates
  • Closing and Exiting Excel
 
Lesson 4: 
Entering Data and Worksheet Navigation

3:54

 ClipNotes
Close

Entering Data and Worksheet Navigation

In this lesson we will cover the following objectives:

  • Entering Data into a Worksheet
  • Worksheet Navigation
 
Lesson 5: 
Insert Different Types of Data

3:26

 ClipNotes
Close

Insert Different Types of Data

In this lesson we will cover the following objectives:

  • Insert Different Types of Data
    • Text
    • Numerical
    • Dates
    • Comments
 
Lesson 6: 
Selecting and Naming Ranges

4:49

 ClipNotes
Close

Selecting and Naming Ranges

In this lesson we will cover the following objectives:

  • Selecting Ranges
    •  Contiguous
    •  Non-Contiguous
    •  Name a Range
 
Lesson 7: 
Insert Data Into Multiple Cells Using the Clipboard and Ctrl+Enter

3:35

 ClipNotes
Close

Insert Data Into Multiple Cells Using the Clipboard and Ctrl+Enter

In this lesson we will cover the following objectives:

  • Use the Clipboard
  • Use Ctrl+Enter
 
Lesson 8: 
Insert Data Into Multiple Cells Using AutoFill

4:48

 ClipNotes
Close

Insert Data Into Multiple Cells Using AutoFill

In this lesson we will cover the following objectives:

  • Use AutoFill to enter data
  • Use AutoFill to enter a series
  • Create a Custom Series
 
Lesson 9: 
AutoComplete

2:13

 ClipNotes
Close

AutoComplete

In this lesson we will cover the following objectives:

  • AutoComplete
 

Formatting and Conditional Formatting

Lesson 10: 
Using the Font Grouping and Dialog Box

4:25

 ClipNotes
Close

Using the Font Grouping and Dialog Box

In this lesson we will cover the following objectives:

  • Using the Font Grouping
  • Using the Format Cells Dialog
 
Lesson 11: 
Using the Alignment Grouping and Dialog Box

3:39

 ClipNotes
Close

Using the Alignment Grouping and Dialog Box

In this lesson we will cover the following objectives:

  • Using the Alignment Grouping
  • Alignment Options from the Format Cells Dialog
 
Lesson 12: 
Using the Number Grouping and Dialog Box

2:31

 ClipNotes
Close

Using the Number Grouping and Dialog Box

In this lesson we will cover the following objectives:

  • Using the Number Grouping
  • Number Options from the Format Cells Dialog
 
Lesson 13: 
Row Height, Column Width and Hide/Unhide

3:12

 ClipNotes
Close

Row Height, Column Width and Hide/Unhide

In this lesson we will cover the following objectives:

  • Row Height
  • Column Width
  • Hide/Unhide Rows and Columns
 
Lesson 14: 
Formatting a Data Bar

4:15

 ClipNotes
Close

Formatting a Data Bar

In this lesson we will cover the following objectives:

  • What is Conditional Formatting?
  • Formatting a Data Bar
 
Lesson 15: 
Format with Color Scales and Icon Sets

3:31

 ClipNotes
Close

Format with Color Scales and Icon Sets

In this lesson we will cover the following objectives:

  • Format with:
    • Color Scales
    • Icon Sets
 
Lesson 16: 
Highlight Cell Rules

3:29

 ClipNotes
Close

Highlight Cell Rules

In this lesson we will cover the following objectives:

  • Highlight Cell Rules
 
Lesson 17: 
Top/Bottom Rules

4:22

 ClipNotes
Close

Top/Bottom Rules

In this lesson we will cover the following objectives:

  • Top/Bottom Rules
 
Lesson 18: 
Manage Multiple Conditional Formatting Rules

2:44

 ClipNotes
Close

Manage Multiple Conditional Formatting Rules

In this lesson we will cover the following objectives

  • Manage Multiple Conditional Formatting Rules
 

Working with Formulas and Functions

Lesson 19: 
Excel Formulas

5:49

 ClipNotes
Close

Excel Formulas

In this lesson we will cover the following objectives:

  • What is a Formula?
  • Operators
  • Enter and Edit Formulas
 
Lesson 20: 
Absolute References & Using Named Ranges

8:22

 ClipNotes
Close

Absolute References & Using Named Ranges

In this lesson we will cover the following objectives:

  • Using Absolute References
  • Using Named Ranges
 
Lesson 21: 
Excel Functions

5:30

 ClipNotes
Close

Excel Functions

In this lesson we will cover the following objectives:

  • What is a Function?
  • Insert a Function
  • Using AutoSum
 
Lesson 22: 
Commonly Used Functions and Status Bar Results

5:06

 ClipNotes
Close

Commonly Used Functions and Status Bar Results

In this lesson we will cover the following objectives:

  • Commonly Used Functions
  • Status Bar Function Results
 
Lesson 23: 
The Function Library and Financial Functions

4:20

 ClipNotes
Close

The Function Library and Financial Functions

In this lesson we will cover the following objectives:

  • The Function Library
  • Financial Functions
 
Lesson 24: 
Logical Functions

4:17

 ClipNotes
Close

Logical Functions

In this lesson we will cover the following objectives:

  • Logical Functions
 
Lesson 25: 
Text and Date Functions

4:11

 ClipNotes
Close

Text and Date Functions

In this lesson we will cover the following objectives:

  • Text Functions

  • Date Functions

 

Using Tables and Pivot Tables To Sort & Filter Data

Lesson 26: 
Sorting Your Data

3:56

 ClipNotes
Close

Sorting Your Data

In this lesson we will cover the following objectives:

  • Ascending/Descending Sorts
  • Using Table Column Headers
 
Lesson 27: 
Performing Custom Sorts

2:42

 ClipNotes
Close

Performing Custom Sorts

In this lesson we will cover the following objectives:

  • Sort by Multiple Columns
  • Sort by Color
 
Lesson 28: 
Filter Your Data

4:07

 ClipNotes
Close

Filter Your Data

In this lesson we will cover the following objectives:

  •  Custom Filters
 
Lesson 29: 
Understanding Pivot Tables

2:45

 ClipNotes
Close

Understanding Pivot Tables

In this lesson we will cover the following objectives:

  • Understanding Pivot Tables
 
Lesson 30: 
Create a Simple Pivot Table

3:17

 ClipNotes
Close

Create a Simple Pivot Table

In this lesson we will cover the following objectives:

  • Create a Simple Pivot Table
 
Lesson 31: 
Update Your Pivot Table

2:49

 ClipNotes
Close

Update Your Pivot Table

In this lesson we will cover the following objectives:

  • Update Your Pivot Table
 

Protecting Your Workbook and Worksheets

Lesson 32: 
Protect Your Data

5:57

 ClipNotes
Close

Protect Your Data

In this lesson we will cover the following objectives:

  • Password Protect Your Workbook
 
Lesson 33: 
Workbook Protection Settings

3:59

 ClipNotes
Close

Workbook Protection Settings

In this lesson we will cover the following objectives:

  • Sort by Multiple Columns
  • Sort by Color
 
Lesson 34: 
Protect Specific Aspects of Your Workbook

5:00

 ClipNotes
Close

Protect Specific Aspects of Your Workbook

In this lesson we will cover the following objectives:

  • Lock or Unlock Cells
  • Protect Your Worksheets
 

Changing The View In Excel

Lesson 35: 
Worksheet Views

4:22

 ClipNotes
Close

Worksheet Views

In this lesson we will cover the following objectives:

  • Changing Workbook Views
  • Different Workbook Views
 
Lesson 36: 
Zoom Control and Show/Hide Options

2:41

 ClipNotes
Close

Zoom Control and Show/Hide Options

In this lesson we will cover the following objectives:

  • Zoom Controls
  • Show/Hide Options
 
Lesson 37: 
Window Options

5:34

 ClipNotes
Close

Window Options

In this lesson we will cover the following objectives:

  • Freeze Headings
  • Split The Window
  • Additional Window Options
 

Insert Illustrations and SmartArt

Lesson 38: 
Using Illustrations

3:52

 ClipNotes
Close

Using Illustrations

In this lesson we will cover the following objectives:

  • Insert Pictures
  • Insert Clip Art
  • Insert Shapes
 
Lesson 39: 
Formatting Pictures, Clip Art and Shapes

6:54

 ClipNotes
Close

Formatting Pictures, Clip Art and Shapes

In this lesson we will cover the following objectives:

  • Picture & ClipArt Formatting Options
 
Lesson 40: 
Shape Formatting Options

5:06

 ClipNotes
Close

Shape Formatting Options

In this lesson we will cover the following objectives:

  • Shape Formatting Options
 
Lesson 41: 
Adding SmartArt Into Worksheets

4:29

 ClipNotes
Close

Adding SmartArt Into Worksheets

In this lesson we will cover the following objectives:

  • Adding SmartArt Into Worksheets
 

Basic and Advanced Charting and Chart Formatting

Lesson 42: 
Excel Chart Building

6:08

 ClipNotes
Close

Excel Chart Building

In this lesson we will cover the following objectives:

  • Chart Types
  • Chart Terminology
 
Lesson 43: 
Create a Simple Chart

5:13

 ClipNotes
Close

Create a Simple Chart

In this lesson we will cover the following objectives:

  • Create a Pie Chart
  • Create a Column Chart
  • Make Some Design Changes
 
Lesson 44: 
Changing Labels, Colors and Backgrounds

10:18

 ClipNotes
Close

Changing Labels, Colors and Backgrounds

In this lesson we will cover the following objectives:

  • Changing Labels
  • Changing Colors & Background
 
Lesson 45: 
Make a Combination Chart

2:06

 ClipNotes
Close

Make a Combination Chart

In this lesson we will cover the following objectives:

  • Make a Combination Chart
 

Printing and Proofing in Excel

Lesson 46: 
Manually Adjusting the Print Structure

4:59

 ClipNotes
Close

Manually Adjusting the Print Structure

In this lesson we will cover the following objectives:

  • Using Print Preview
  • Portrait or Landscape
  • Define Print Areas
  • Change Print Areas
 
Lesson 47: 
Adjusting Page Setup Options (Part 1)

3:26

 ClipNotes
Close

Adjusting Page Setup Options (Part 1)

In this lesson we will cover the following objectives:

  • The Page Tab
  • The Margins Tab
 
Lesson 48: 
Adjusting Page Setup Options (Part 2)

7:12

 ClipNotes
Close

Adjusting Page Setup Options (Part 2)

In this lesson we will cover the following objectives:

  • The Header/Footer Tab
  • The Sheet Tab
 
Lesson 49: 
Printing Worksheets

3:34

 ClipNotes
Close

Printing Worksheets

In this lesson we will cover the following objectives:

  • Printing Worksheets
 
Lesson 50: 
Proofing Tools

4:06

 ClipNotes
Close

Proofing Tools

In this lesson we will cover the following objectives:

  • Spell Check
  • Thesaurus
  • Translate
 

Login for Access

Close
ClipStart Guides are available free of charge, but you must be logged in to access them. Please log in or sign up for a free training membership to access this ClipStart Guide.
Don't have an account yet?

Join Now!Click here to find out the advantages and sign-up today!

Membership Required
For FREE access to select the clips in this category you must login with a FREE Training Membership.

Access all clips with a Full Membership.

Select one of the options below to join, or click the login button above to sign in.


Multiple Users?

<a href="contact.cfm">Contact us</a> for additional information on how ClipTraining can benefit your organization.
Contact us for additional information on how ClipTraining can benefit your organization.