Free Trial

You get to enjoy all premium features and unlimited course access in WingsLive.com for 1 day free trial.

It takes only 30 Seconds! Try now!

Membership

Get unlimited course access, exclusive features and learn on any device with our premium account that helps you to meet all your learning objectives.

Access Code

If you purchased an access code card in any outlet or if you have any of our Discount Code, Gift Code, Promo Code, Please Click here.

Login


Forgot password? Click here

Send us your Feedback

Forgot Password?

Please enter your registered email address to reset your password: you will receive an email with further instructions.

Free Trial Account

Sign up with:

Sign up with Facebook
Sign up with Google

Sign up with Email:

Share this course to your loved one

via Mail ID

Embed Link

Copy this link
www.wingslive.com/index.php/courses/Excel_2010

Quick Links

  •   Buy Gift

    Give a Gift of Knowledge

    "It always remembers, Give a man a fish, and you feed him for a day;
    Show him how to catch fish, and you feed him for a lifetime."

    Three simple processes for ordering it.
    Step 1: Simply decide which subscription plan you would like to give as a gift
    Step 2: Tell us whom you want this to be send
    Step 3: Complete the payment and leave the reset to us!
    We will send our WingsLive Gift Voucher code, in an attractive gift wallet & envelope,
    bearing your individual gift message, to your selected delivery address within 3 working
    days (or) We will send our WingsLive Gift Voucher code, in an attractive E-Greeting card,
    bearing your individual gift message, to the given email address within few minutes of
    time.
      CBT Store   Contact Us
  • Search Result

    Excel 2010

    80 Lessons      01:29:35 hrs

    Microsoft® Office Excel enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup language (XML) data to make it easier to connect to business processes.

    Screen Resolution Available On
    CD/DVD-Rom's, Online, Apps

    Searched Keyword:
    << Back

    BM

    Lesson Plans

    Duration

    Status

    ABL

    Notes

    Excersice


    Collapse all Expand all

    • +

      Introduction to Excel


       

      Overview of Excel 2010

      00:56

       

      N/A

       

      N/A


       

      Benefits of Excel 2010

      02:19

       

      N/A

       

      N/A


       

      What’s New in Excel 2010?

      02:54

       

      N/A

       

      N/A


       

      Getting Started with Excel 2010

      01:58

       

      N/A

       

      N/A


       

      Exploring the New Excel Interface

      01:14

       

      N/A

       

      N/A


       

      Working with Ribbon

      01:40

       

      N/A

       

      N/A


       

      Customizing the Quick Access Toolbar

      01:28

       

      N/A

       

      N/A


       

      Working with Smart Tags

      00:50

       

      N/A

       

      N/A


       

      Working with View

      00:57

       

      N/A

       

      N/A


       

      Configuring Excel Options

      01:00

       

      N/A

       

      N/A


    • +

      Entering and Editing Excel Data


       

      Basics of a Worksheet

      01:03

       

      N/A

       

      N/A


       

      Knowing the Types of Data you can use

      01:16

       

      N/A

       

      N/A


       

      Entering Text and Number in a Cell

      01:11

       

      N/A

       

      N/A


       

      Editing Cell Data

      00:54

       

      N/A

       

      N/A


       

      Deleting Data from a Cell

      00:36

       

      N/A

       

      N/A


    • +

      Working with Excel Data and Range


       

      Selecting a Range

      01:09

       

      N/A

       

      N/A


       

      Filling same Data for a Selected Range

      00:48

       

      N/A

       

      N/A


       

      Filling series of values to a Selected Range

      00:52

       

      N/A

       

      N/A


       

      Moving or Copying a Range

      01:03

       

      N/A

       

      N/A


       

      Inserting a Row and Column

      01:06

       

      N/A

       

      N/A


       

      Inserting a Cell or Range

      00:43

       

      N/A

       

      N/A


       

      Deleting Data from a Range

      00:52

       

      N/A

       

      N/A


       

      Hiding and Un-hiding a selected Range

      01:04

       

      N/A

       

      N/A


       

      Freezing Rows or Columns

      00:45

       

      N/A

       

      N/A


       

      Merging two or more Cells

      00:25

       

      N/A

       

      N/A


       

      Transposing Rows and Columns

      00:31

       

      N/A

       

      N/A


       

      Working with Range Names

      01:06

       

      N/A

       

      N/A


       

      Navigating a Workbook using Range Name

      00:59

       

      N/A

       

      N/A


    • +

      Formatting Excel Ranges


       

      Changing the Font and Font Size

      00:48

       

      N/A

       

      N/A


       

      Applying Effects to Fonts

      01:13

       

      N/A

       

      N/A


       

      Changing Font Color

      01:07

       

      N/A

       

      N/A


       

      Working with Text within a Cell

      01:03

       

      N/A

       

      N/A


       

      Adding a Background Color to a Range

      01:14

       

      N/A

       

      N/A


       

      Applying a Number Format

      00:53

       

      N/A

       

      N/A


       

      Applying Auto Format to a Range

      00:50

       

      N/A

       

      N/A


       

      Applying a Style to a Range

      00:38

       

      N/A

       

      N/A


       

      Changing the Size of Row and Column

      01:20

       

      N/A

       

      N/A


       

      Wrapping Text within a Cell

      00:51

       

      N/A

       

      N/A


       

      Adding Border to a Range

      00:25

       

      N/A

       

      N/A


    • +

      Working with Formulas and Functions


       

      Introduction to Formulas

      01:57

       

      N/A

       

      N/A


       

      Building a Formula

      00:40

       

      N/A

       

      N/A


       

      Introduction to Excel Functions

      01:25

       

      N/A

       

      N/A


       

      Adding a Function to a Formula

      00:59

       

      N/A

       

      N/A


       

      Adding a Row or Column of Numbers

      00:46

       

      N/A

       

      N/A


       

      Building an Autosum Formula

      00:59

       

      N/A

       

      N/A


       

      Adding a Range Name to a Formula

      00:56

       

      N/A

       

      N/A


       

      Moving and Copying a Formula

      01:36

       

      N/A

       

      N/A


    • +

      Manipulating Excel Worksheets


       

      Creating a New Worksheet

      01:09

       

      N/A

       

      N/A


       

      Moving a Worksheet

      01:16

       

      N/A

       

      N/A


       

      Copying and Renaming Worksheet

      01:22

       

      N/A

       

      N/A


       

      Deleting a Worksheet

      00:39

       

      N/A

       

      N/A


       

      Changing the Gridline Color

      00:46

       

      N/A

       

      N/A


       

      Toggling Worksheet Gridlines and Headings On and Off

      00:54

       

      N/A

       

      N/A


    • +

      Working with Excel Workbooks


       

      Creating a New Blank Workbook

      00:40

       

      N/A

       

      N/A


       

      Creating a New Workbook from a Template

      00:57

       

      N/A

       

      N/A


       

      Working with Workbooks

      01:29

       

      N/A

       

      N/A


       

      Arranging Workbook Windows

      01:13

       

      N/A

       

      N/A


       

      Finding and Replacing Text in a Workbook

      01:32

       

      N/A

       

      N/A


       

      Modifying Workbook Colors

      01:00

       

      N/A

       

      N/A


       

      Setting Workbook Fonts

      01:17

       

      N/A

       

      N/A


       

      Selecting Workbook Effects and Theme

      01:11

       

      N/A

       

      N/A


    • +

      Analyzing Excel Data


       

      Sorting a Range

      01:04

       

      N/A

       

      N/A


       

      Filtering a Range

      00:58

       

      N/A

       

      N/A


       

      Setting Data Validation Rules

      01:24

       

      N/A

       

      N/A


       

      Converting a Range to a Table

      00:51

       

      N/A

       

      N/A


       

      Creating a Data Table

      01:11

       

      N/A

       

      N/A


       

      Summarizing Data with Subtotals

      00:43

       

      N/A

       

      N/A


    • +

      Visualizing Data with Excel Charts


       

      Examining Chart Elements

      01:36

       

      N/A

       

      N/A


       

      Understanding Chart Types

      03:07

       

      N/A

       

      N/A


       

      Creating a Chart and Adding Chart Titles

      01:28

       

      N/A

       

      N/A


       

      Adding Data Labels

      00:31

       

      N/A

       

      N/A


       

      Positioning the Chart Legend

      00:32

       

      N/A

       

      N/A


       

      Displaying a Data Table

      00:43

       

      N/A

       

      N/A


       

      Changing the Chart Layout and Style

      00:59

       

      N/A

       

      N/A


    • +

      Collaborating with Other People


       

      Protecting a Workbook

      01:36

       

      N/A

       

      N/A


       

      Share a Workbook with Other Users

      01:22

       

      N/A

       

      N/A


       

      Track Workbook Changes

      01:32

       

      N/A

       

      N/A


       

      Accept or Reject Workbook Changes

      01:29

       

      N/A

       

      N/A


       

      Make a Workbook Compatible with Earlier Versions of Excel

      01:03

       

      N/A

       

      N/A


       

      Collaborate on a Workbook Online

      00:42

       

      N/A

       

      N/A


    Self Assessment

    Attempts

    Status

    Introduction to Excel

    0

     


    Entering and Editing Excel Data

    0

     


    Working with Excel Data and Range

    0

     


    Formatting Excel Ranges

    0

     


    Working with Formulas and Functions

    0

     


    Manipulating Excel Worksheets

    0

     


    Working with Excel Workbooks

    0

     


    Analyzing Excel Data

    0

     


    Visualizing Data with Excel Charts

    0

     


    Collaborating with Other People

    0

     


    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.