Top Reasons to Buy

Demo links

open

Excel 2010

Excel 2010 icon
 01:12:53 Hrs

Course Description

This course explains how to work in Microsoft Excel 2010 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

  •   Introduction to ExcelOpen or Close
    -
    thumbnail

    Overview of Excel 2010

    00:56

     
     

    -
    thumbnail

    Benefits of Excel 2010

    02:19

     
     

    -
    thumbnail

    What's New in Excel 2010?

    02:54

     
     

    -
    thumbnail

    Getting Started with Excel 2010

    01:58

     
     

    -
    thumbnail

    Exploring the New Excel Interface

    01:14

     
     

    -
    thumbnail

    Working with Ribbon

    01:40

     
     

    -
    thumbnail

    Customizing the Quick Access Toolbar

    01:28

     
     

    -
    thumbnail

    Working with Smart Tags

    00:50

     
     

  •   Working with Excel Data and RangeOpen or Close
    -
    thumbnail

    Selecting a Range

    01:09

     
     

    -
    thumbnail

    Filling same Data for a Selected Range

    00:48

     
     

    -
    thumbnail

    Moving or Copying a Range

    01:03

     
     

    -
    thumbnail

    Inserting a Row and Column

    01:06

     
     

    -
    thumbnail

    Inserting a Cell or Range

    00:43

     
     

    -
    thumbnail

    Deleting Data from a Range

    00:52

     
     

    -
    thumbnail

    Freezing Rows or Columns

    00:45

     
     

    -
    thumbnail

    Merging two or more Cells

    00:25

     
     

    -
    thumbnail

    Transposing Rows and Columns

    00:31

     
     

    -
    thumbnail

    Working with Range Names

    01:06

     
     

  •   Formatting Excel RangesOpen or Close
    -
    thumbnail

    Changing the Font and Font Size

    00:48

     
     

    -
    thumbnail

    Changing Font Color

    01:07

     
     

    -
    thumbnail

    Working with Text within a Cell

    01:03

     
     

    -
    thumbnail

    Adding a Background Color to a Range

    01:14

     
     

    -
    thumbnail

    Applying a Number Format

    00:53

     
     

    -
    thumbnail

    Applying Auto Format to a Range

    00:50

     
     

    -
    thumbnail

    Changing the Size of Row and Column

    01:20

     
     

    -
    thumbnail

    Wrapping Text within a Cell

    00:51

     
     

  •   Working with Formulas and FunctionsOpen or Close
    -
    thumbnail

    Introduction to Formulas

    01:57

     
     

    -
    thumbnail

    Building a Formula

    00:40

     
     

    -
    thumbnail

    Introduction to Excel Functions

    01:25

     
     

    -
    thumbnail

    Adding a Function to a Formula

    00:59

     
     

    -
    thumbnail

    Adding a Row or Column of Numbers

    00:46

     
     

    -
    thumbnail

    Building an Autosum Formula

    00:59

     
     

  •   Manipulating Excel WorksheetsOpen or Close
    -
    thumbnail

    Creating a New Worksheet

    01:09

     
     

    -
    thumbnail

    Moving a Worksheet

    01:16

     
     

    -
    thumbnail

    Copying and Renaming Worksheet

    01:22

     
     

    -
    thumbnail

    Deleting a Worksheet

    00:39

     
     

    -
    thumbnail

    Changing the Gridline Color

    00:46

     
     

  •   Working with Excel WorkbooksOpen or Close
    -
    thumbnail

    Creating a New Blank Workbook

    00:40

     
     

    -
    thumbnail

    Creating a New Workbook from a Template

    00:57

     
     

    -
    thumbnail

    Working with Workbooks

    01:29

     
     

    -
    thumbnail

    Arranging Workbook Windows

    01:13

     
     

    -
    thumbnail

    Finding and Replacing Text in a Workbook

    01:32

     
     

    -
    thumbnail

    Modifying Workbook Colors

    01:00

     
     

  •   Analyzing Excel DataOpen or Close
    -
    thumbnail

    Sorting a Range

    01:04

     
     

    -
    thumbnail

    Filtering a Range

    00:58

     
     

    -
    thumbnail

    Setting Data Validation Rules

    01:24

     
     

    -
    thumbnail

    Converting a Range to a Table

    00:51

     
     

    -
    thumbnail

    Creating a Data Table

    01:11

     
     

  •   Visualizing Data with Excel ChartsOpen or Close
    -
    thumbnail

    Examining Chart Elements

    01:36

     
     

    -
    thumbnail

    Understanding Chart Types

    03:07

     
     

    -
    thumbnail

    Creating a Chart and Adding Chart Titles

    01:28

     
     

    -
    thumbnail

    Adding Data Labels

    00:31

     
     

    -
    thumbnail

    Positioning the Chart Legend

    00:32

     
     

    -
    thumbnail

    Displaying a Data Table

    00:43

     
     

  •   Collaborating with Other PeopleOpen or Close
    -
    thumbnail

    Protecting a Workbook

    01:36

     
     

    -
    thumbnail

    Share a Workbook with Other Users

    01:22

     
     

    -
    thumbnail

    Track Workbook Changes

    01:32

     
     

    -
    thumbnail

    Accept or Reject Workbook Changes

    01:29

     
     

    -
    thumbnail

    Make a Workbook Compatible with Earlier Versions of Excel

    01:03

     
     

BM
Tips & Tricks
Status
Self Assessments
Attempts
Status

Introduction to Excel

-

Entering and Editing Excel Data

-

Working with Excel Data and Range

-

Formatting Excel Ranges

-

Working with Formulas and Functions

-

Manipulating Excel Worksheets

-

Working with Excel Workbooks

-

Analyzing Excel Data

-

Visualizing Data with Excel Charts

-

Collaborating with Other People

-
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

Glossary is not available for this index.