Top Reasons to Buy

Demo links

open

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
    -
    thumbnail

    Creating a Basic Worksheet

    01:41

     
     

    -
    thumbnail

    Navigating and Editing Data in a Worksheet

    05:01

     
     

    -
    thumbnail

    Saving and Opening a File

    05:48

     
     

    -
    thumbnail

    Customizing Quick Access Toolbar

    02:12

     
     

    -
    thumbnail

    Moving Data around Excel Worksheet

    07:54

     
     

    -
    thumbnail

    Adding and Moving Columns or Rows

    02:50

     
     

    -
    thumbnail

    Printing an Excel Sheet

    01:52

     
     

    -
    thumbnail

    Creating Headers and Footers

    02:02

     
     

    -
    thumbnail

    Page Setup Options

    01:42

     
     

  •   Managing and Formatting WorksheetOpen or Close
    -
    thumbnail

    Worksheets and Workbooks

    03:43

     
     

    -
    thumbnail

    Find and Replace

    03:42

     
     

    -
    thumbnail

    Spell Check

    03:15

     
     

    -
    thumbnail

    Formatting Cell Values

    04:26

     
     

    -
    thumbnail

    Formatting Font Appearances

    03:11

     
     

    -
    thumbnail

    Formatting Alignments

    03:28

     
     

    -
    thumbnail

    Borders and Fills

    02:28

     
     

    -
    thumbnail

    The Format Painter

    01:28

     
     

    -
    thumbnail

    Styles and Themes

    03:37

     
     

    -
    thumbnail

    Controlling your Views

    01:40

     
     

  •   Formulae and FunctionsOpen or Close
    -
    thumbnail

    Building Basic Formula

    02:07

     
     

    -
    thumbnail

    Excel's Functions

    03:02

     
     

    -
    thumbnail

    Excel's Function Library

    04:36

     
     

    -
    thumbnail

    Using the Insert Function Button

    02:48

     
     

    -
    thumbnail

    Copying Formulas

    02:05

     
     

    -
    thumbnail

    Formula Auditing

    04:25

     
     

  •   Organizing WorksheetsOpen or Close
    -
    thumbnail

    Basics of Tables

    05:06

     
     

    -
    thumbnail

    Selecting and Editing a Table

    02:45

     
     

    -
    thumbnail

    Sorting a Table

    02:44

     
     

    -
    thumbnail

    Filtering a Table

    02:11

     
     

    -
    thumbnail

    Basic Data Grouping

    01:20

     
     

    -
    thumbnail

    Automatic Subtotaling

    02:11

     
     

    -
    thumbnail

    Understanding Templates

    02:42

     
     

  •   Charts and GraphicsOpen or Close
    -
    thumbnail

    Creating Basic Charts

    02:41

     
     

    -
    thumbnail

    Adding Pictures to a Worksheet

    02:57

     
     

    -
    thumbnail

    Excel's Clip Art Library and Shapes

    03:29

     
     

    -
    thumbnail

    Drawing a Shape

    02:37

     
     

    -
    thumbnail

    Inserting Smart-Art Graphic

    02:32

     
     

  •   Formatting ChartsOpen or Close
    -
    thumbnail

    Dealing with Duplicate Rows

    02:43

     
     

    -
    thumbnail

    Formatting Chart Elements

    02:23

     
     

    -
    thumbnail

    Texture, Picture Fills and Border Styles

    02:52

     
     

    -
    thumbnail

    Gaps, Widths, and Overlays in a Column Chart

    02:37

     
     

    -
    thumbnail

    Controlling a Chart Scale

    03:14

     
     

  •   Scenarios and Goal SeekingOpen or Close
    -
    thumbnail

    Introduction to Scenarios

    02:11

     
     

    -
    thumbnail

    Managing Scenarios

    02:41

     
     

    -
    thumbnail

    Using Goal Seek

    02:47

     
     

    -
    thumbnail

    Solver

    04:20

     
     

    -
    thumbnail

    Saving Solver Models

    02:37

     
     

    -
    thumbnail

    Configuring Solver

    02:00

     
     

  •   Advanced Data AnalysisOpen or Close
    -
    thumbnail

    Data Tables

    04:18

     
     

    -
    thumbnail

    Data Forms

    02:39

     
     

    -
    thumbnail

    Pivot Tables

    02:35

     
     

    -
    thumbnail

    Field Settings and Styles in Pivot Tables

    02:40

     
     

    -
    thumbnail

    Pivot Charts

    01:40

     
     

  •   Protecting Your Work bookOpen or Close
    -
    thumbnail

    Data Validation

    04:42

     
     

    -
    thumbnail

    Data Validation using Functions

    02:21

     
     

    -
    thumbnail

    Data Validation with Lists

    01:35

     
     

    -
    thumbnail

    Protecting a Worksheet

    04:19

     
     

    -
    thumbnail

    Protecting the Entire Workbook

    01:54

     
     

    -
    thumbnail

    Protecting Cell Ranges with More Passwords

    02:13

     
     

    -
    thumbnail

    Preparing Your Workbook

    03:48

     
     

  •   Worksheet CollaborationOpen or Close
    -
    thumbnail

    Adding Comments

    02:05

     
     

    -
    thumbnail

    Fine-Tuning Comments

    02:09

     
     

    -
    thumbnail

    Tracking Changes

    01:47

     
     

    -
    thumbnail

    Examining the Change Log

    01:25

     
     

    -
    thumbnail

    Accepting and Rejecting Changes

    01:57

     
     

    -
    thumbnail

    Sharing Your Workbook

    02:03

     
     

  •   Connection Worksheet to the WebOpen or Close
    -
    thumbnail

    Embedding and Linking Objects

    01:54

     
     

    -
    thumbnail

    Putting Worksheets on the Web

    03:04

     
     

    -
    thumbnail

    Performing Web Queries

    02:04

     
     

    -
    thumbnail

    Creating a Web Query

    03:41

     
     

    -
    thumbnail

    Using Hyperlinks

    01:40

     
     

    -
    thumbnail

    Adding a Hyperlink to a Worksheet Location

    01:52

     
     

  •   Working with Macros and XMLOpen or Close
    -
    thumbnail

    Introduction to Macros

    02:17

     
     

    -
    thumbnail

    Recording and Playing a Macro

    02:18

     
     

    -
    thumbnail

    The Trust Center

    02:56

     
     

    -
    thumbnail

    Excel and XML

    02:09

     
     

    -
    thumbnail

    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

-
BM
Lesson Plans
Duration
Status
ABL
Notes
Exercise
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.