Excel 2007

Excel 2007 icon
 03:47:23 Hrs

Course Description

This course explains how to work in Microsoft Excel 2007 and its advanced features. It also has tips and tricks and self assessments.

Video Resolution:
   800 X 600
   1024 X 768
BM
Lesson Plans
Duration
Status
Notes

Collapse all Expand all

  •   Creating and Navigating a WorksheetOpen or Close
    -

    Creating a Basic Worksheet

    01:41

     
     


    -

    Navigating and Editing Data in a Worksheet

    05:01

     
     


    -

    Saving and Opening a File

    05:48

     
     


    -

    Customizing Quick Access Toolbar

    02:12

     
     


    -

    Moving Data around Excel Worksheet

    07:54

     
     


    -

    Adding and Moving Columns or Rows

    02:50

     
     


    -

    Printing an Excel Sheet

    01:52

     
     


    -

    Creating Headers and Footers

    02:02

     
     


    -

    Page Setup Options

    01:42

     
     


  •   Managing and Formatting WorksheetOpen or Close
    -

    Worksheets and Workbooks

    03:43

     
     


    -

    Find and Replace

    03:42

     
     


    -

    Spell Check

    03:15

     
     


    -

    Formatting Cell Values

    04:26

     
     


    -

    Formatting Font Appearances

    03:11

     
     


    -

    Formatting Alignments

    03:28

     
     


    -

    Borders and Fills

    02:28

     
     


    -

    The Format Painter

    01:28

     
     


    -

    Styles and Themes

    03:37

     
     


    -

    Controlling your Views

    01:40

     
     


  •   Formulae and FunctionsOpen or Close
    -

    Building Basic Formula

    02:07

     
     


    -

    Excel's Functions

    03:02

     
     


    -

    Excel's Function Library

    04:36

     
     


    -

    Using the Insert Function Button

    02:48

     
     


    -

    Copying Formulas

    02:05

     
     


    -

    Formula Auditing

    04:25

     
     


  •   Organizing WorksheetsOpen or Close
    -

    Basics of Tables

    05:06

     
     


    -

    Selecting and Editing a Table

    02:45

     
     


    -

    Sorting a Table

    02:44

     
     


    -

    Filtering a Table

    02:11

     
     


    -

    Basic Data Grouping

    01:20

     
     


    -

    Automatic Subtotaling

    02:11

     
     


    -

    Understanding Templates

    02:42

     
     


  •   Charts and GraphicsOpen or Close
    -

    Creating Basic Charts

    02:41

     
     


    -

    Adding Pictures to a Worksheet

    02:57

     
     


    -

    Excel's Clip Art Library and Shapes

    03:29

     
     


    -

    Drawing a Shape

    02:37

     
     


    -

    Inserting Smart-Art Graphic

    02:32

     
     


  •   Formatting ChartsOpen or Close
    -

    Dealing with Duplicate Rows

    02:43

     
     


    -

    Formatting Chart Elements

    02:23

     
     


    -

    Texture, Picture Fills and Border Styles

    02:52

     
     


    -

    Gaps, Widths, and Overlays in a Column Chart

    02:37

     
     


    -

    Controlling a Chart Scale

    03:14

     
     


  •   Scenarios and Goal SeekingOpen or Close
    -

    Introduction to Scenarios

    02:11

     
     


    -

    Managing Scenarios

    02:41

     
     


    -

    Using Goal Seek

    02:47

     
     


    -

    Solver

    04:20

     
     


    -

    Saving Solver Models

    02:37

     
     


    -

    Configuring Solver

    02:00

     
     


  •   Advanced Data AnalysisOpen or Close
    -

    Data Tables

    04:18

     
     


    -

    Data Forms

    02:39

     
     


    -

    Pivot Tables

    02:35

     
     


    -

    Field Settings and Styles in Pivot Tables

    02:40

     
     


    -

    Pivot Charts

    01:40

     
     


  •   Protecting Your Work bookOpen or Close
    -

    Data Validation

    04:42

     
     


    -

    Data Validation using Functions

    02:21

     
     


    -

    Data Validation with Lists

    01:35

     
     


    -

    Protecting a Worksheet

    04:19

     
     


    -

    Protecting the Entire Workbook

    01:54

     
     


    -

    Protecting Cell Ranges with More Passwords

    02:13

     
     


    -

    Preparing Your Workbook

    03:48

     
     


  •   Worksheet CollaborationOpen or Close
    -

    Adding Comments

    02:05

     
     


    -

    Fine-Tuning Comments

    02:09

     
     


    -

    Tracking Changes

    01:47

     
     


    -

    Examining the Change Log

    01:25

     
     


    -

    Accepting and Rejecting Changes

    01:57

     
     


    -

    Sharing Your Workbook

    02:03

     
     


  •   Connection Worksheet to the WebOpen or Close
    -

    Embedding and Linking Objects

    01:54

     
     


    -

    Putting Worksheets on the Web

    03:04

     
     


    -

    Performing Web Queries

    02:04

     
     


    -

    Creating a Web Query

    03:41

     
     


    -

    Using Hyperlinks

    01:40

     
     


    -

    Adding a Hyperlink to a Worksheet Location

    01:52

     
     


  •   Working with Macros and XMLOpen or Close
    -

    Introduction to Macros

    02:17

     
     


    -

    Recording and Playing a Macro

    02:18

     
     


    -

    The Trust Center

    02:56

     
     


    -

    Excel and XML

    02:09

     
     


    -

    Mapping a Simple Document

    02:05

     
     


BM
Tips & Tricks
Status

Microsoft Excel 2007 - Tips

-

Calculating Loan Term


 


-

Adding Calculator to Excel Sheet


 


-

Transforming Text to Numbers


 


-

Converting Row into Column


 


-

Adding a Trend Line


 


-

Filling with Gradient


 


-

Inserting a Background Image


 


-

Taking Picture of our Worksheet


 


-

Creating Link from an Excel Workbook


 


-

Embedding a Worksheet


 


Self Assessments
Attempts
Status

Introduction to Excel 2007

-

Creating and Navigating a Worksheet

-

Managing and Formatting Worksheet

-

Formulae and Functions

-

Organizing Worksheets

-

Charts and Graphics

-

Formatting Charts

-

Scenarios and Goal Seeking

-

Advanced Data Analysis

-

Protecting Your Work book

-

Worksheet Collaboration

-

Connection Worksheet to the Web

-

Working with Macros and XML

-
Lesson Plans
Tips and Tricks

Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

3-D reference

A reference to a range that spans two or more worksheets in a workbook.

3-D walls and floor

The areas surrounding many 3-D chart types that give dimension and boundaries to the chart. Two walls and one floor are displayed within the plot area.

Activate

To make a chart sheet or worksheet the active, or selected, sheet. The sheet that you activate determines which tabs are displayed. To activate a sheet, click the tab for the sheet in the workbook.

Active Cell

The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.

Active Sheet

The sheet that you"re working on in a workbook. The name on the tab of the active sheet is bold.

Address

The path to an object, document, file, page, or other destination. An address can be a URL (Web address) or a UNC path (network address), and can include a specific location within a file, such as a Word bookmark or an Excel cell range.

Alternate Startup Folder

A folder in addition to the XLStart folder that contains workbooks or other files that you want to be opened automatically when you start Excel and templates that you want to be available when you create new workbooks.

Argument

The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.

Array

Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.

Array Formula

A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.

Associated PivotTable Report

The PivotTable report that supplies the source data to the PivotChart report. It is created automatically when you create a new PivotChart report. When you change the layout of either report, the other also changes.

Autoformat

A built-in collection of cell formats (such as font size, patterns, and alignment) that you can apply to a range of data. Excel determines the levels of summary and detail in the selected range and applies the formats accordingly.

Axis

A line bordering the chart plot area used as a frame of reference for measurement. The y axis is usually the vertical axis and contains data. The x-axis is usually the horizontal axis and contains categories.