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
    -

    Overview of Excel 2010

    00:56

     
     


    -

    Benefits of Excel 2010

    02:19

     
     


    -

    What's New in Excel 2010?

    02:54

     
     


    -

    Getting Started with Excel 2010

    01:58

     
     


    -

    Exploring the New Excel Interface

    01:14

     
     


    -

    Working with Ribbon

    01:40

     
     


    -

    Customizing the Quick Access Toolbar

    01:28

     
     


    -

    Working with Smart Tags

    00:50

     
     


  •   Working with Excel Data and RangeOpen or Close
    -

    Selecting a Range

    01:09

     
     


    -

    Filling same Data for a Selected Range

    00:48

     
     


    -

    Moving or Copying a Range

    01:03

     
     


    -

    Inserting a Row and Column

    01:06

     
     


    -

    Inserting a Cell or Range

    00:43

     
     


    -

    Deleting Data from a Range

    00:52

     
     


    -

    Freezing Rows or Columns

    00:45

     
     


    -

    Merging two or more Cells

    00:25

     
     


    -

    Transposing Rows and Columns

    00:31

     
     


    -

    Working with Range Names

    01:06

     
     


  •   Formatting Excel RangesOpen or Close
    -

    Changing the Font and Font Size

    00:48

     
     


    -

    Changing Font Color

    01:07

     
     


    -

    Working with Text within a Cell

    01:03

     
     


    -

    Adding a Background Color to a Range

    01:14

     
     


    -

    Applying a Number Format

    00:53

     
     


    -

    Applying Auto Format to a Range

    00:50

     
     


    -

    Changing the Size of Row and Column

    01:20

     
     


    -

    Wrapping Text within a Cell

    00:51

     
     


  •   Working with Formulas and FunctionsOpen or Close
    -

    Introduction to Formulas

    01:57

     
     


    -

    Building a Formula

    00:40

     
     


    -

    Introduction to Excel Functions

    01:25

     
     


    -

    Adding a Function to a Formula

    00:59

     
     


    -

    Adding a Row or Column of Numbers

    00:46

     
     


    -

    Building an Autosum Formula

    00:59

     
     


  •   Manipulating Excel WorksheetsOpen or Close
    -

    Creating a New Worksheet

    01:09

     
     


    -

    Moving a Worksheet

    01:16

     
     


    -

    Copying and Renaming Worksheet

    01:22

     
     


    -

    Deleting a Worksheet

    00:39

     
     


    -

    Changing the Gridline Color

    00:46

     
     


  •   Working with Excel WorkbooksOpen or Close
    -

    Creating a New Blank Workbook

    00:40

     
     


    -

    Creating a New Workbook from a Template

    00:57

     
     


    -

    Working with Workbooks

    01:29

     
     


    -

    Arranging Workbook Windows

    01:13

     
     


    -

    Finding and Replacing Text in a Workbook

    01:32

     
     


    -

    Modifying Workbook Colors

    01:00

     
     


  •   Analyzing Excel DataOpen or Close
    -

    Sorting a Range

    01:04

     
     


    -

    Filtering a Range

    00:58

     
     


    -

    Setting Data Validation Rules

    01:24

     
     


    -

    Converting a Range to a Table

    00:51

     
     


    -

    Creating a Data Table

    01:11

     
     


  •   Visualizing Data with Excel ChartsOpen or Close
    -

    Examining Chart Elements

    01:36

     
     


    -

    Understanding Chart Types

    03:07

     
     


    -

    Creating a Chart and Adding Chart Titles

    01:28

     
     


    -

    Adding Data Labels

    00:31

     
     


    -

    Positioning the Chart Legend

    00:32

     
     


    -

    Displaying a Data Table

    00:43

     
     


  •   Collaborating with Other PeopleOpen or Close
    -

    Protecting a Workbook

    01:36

     
     


    -

    Share a Workbook with Other Users

    01:22

     
     


    -

    Track Workbook Changes

    01:32

     
     


    -

    Accept or Reject Workbook Changes

    01:29

     
     


    -

    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

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