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_2007

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 2007

    80 Lessons      03:47:23 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 2007


       

      Microsoft Excel 2007

      03:16

       

      N/A

       

      N/A


       

      Excel’s New Interface

      04:26

       

      N/A

       

      N/A


       

      Excel’s New Feature

      02:48

       

      N/A

       

      N/A


    • +

      Creating and Navigating a Worksheet


       

      Creating a Basic Worksheet

      01:41

       

      N/A

       

      N/A


       

      Navigating and Editing Data in a Worksheet

      05:01

       

      N/A

       

      N/A


       

      Saving and Opening a File

      05:48

       

      N/A

       

      N/A


       

      Customizing Quick Access Toolbar

      02:12

       

      N/A

       

      N/A


       

      Moving Data around Excel Worksheet

      07:54

       

      N/A

       

      N/A


       

      Adding and Moving Columns or Rows

      02:50

       

      N/A

       

      N/A


       

      Printing an Excel Sheet

      01:52

       

      N/A

       

      N/A


       

      Creating Headers and Footers

      02:02

       

      N/A

       

      N/A


       

      Page Setup Options

      01:42

       

      N/A

       

      N/A


    • +

      Managing and Formatting Worksheet


       

      Worksheets and Workbooks

      03:43

       

      N/A

       

      N/A


       

      Find and Replace

      03:42

       

      N/A

       

      N/A


       

      Spell Check

      03:15

       

      N/A

       

      N/A


       

      Formatting Cell Values

      04:26

       

      N/A

       

      N/A


       

      Formatting Font Appearances

      03:11

       

      N/A

       

      N/A


       

      Formatting Alignments

      03:28

       

      N/A

       

      N/A


       

      Borders and Fills

      02:28

       

      N/A

       

      N/A


       

      The Format Painter

      01:28

       

      N/A

       

      N/A


       

      Styles and Themes

      03:37

       

      N/A

       

      N/A


       

      Controlling your Views

      01:40

       

      N/A

       

      N/A


    • +

      Formulae and Functions


       

      Building Basic Formula

      02:07

       

      N/A

       

      N/A


       

      Excel’s Functions

      03:02

       

      N/A

       

      N/A


       

      Excel’s Function Library

      04:36

       

      N/A

       

      N/A


       

      Using the Insert Function Button

      02:48

       

      N/A

       

      N/A


       

      Copying Formulas

      02:05

       

      N/A

       

      N/A


       

      Formula Auditing

      04:25

       

      N/A

       

      N/A


    • +

      Organizing Worksheets


       

      Basics of Tables

      05:06

       

      N/A

       

      N/A


       

      Selecting and Editing a Table

      02:45

       

      N/A

       

      N/A


       

      Sorting a Table

      02:44

       

      N/A

       

      N/A


       

      Filtering a Table

      02:11

       

      N/A

       

      N/A


       

      Basic Data Grouping

      01:20

       

      N/A

       

      N/A


       

      Automatic Subtotaling

      02:11

       

      N/A

       

      N/A


       

      Understanding Templates

      02:42

       

      N/A

       

      N/A


    • +

      Charts and Graphics


       

      Creating Basic Charts

      02:41

       

      N/A

       

      N/A


       

      Adding Pictures to a Worksheet

      02:57

       

      N/A

       

      N/A


       

      Excel's Clip Art Library and Shapes

      03:29

       

      N/A

       

      N/A


       

      Drawing a Shape

      02:37

       

      N/A

       

      N/A


       

      Inserting Smart-Art Graphic

      02:32

       

      N/A

       

      N/A


    • +

      Formatting Charts


       

      Dealing with Duplicate Rows

      02:43

       

      N/A

       

      N/A


       

      Formatting Chart Elements

      02:23

       

      N/A

       

      N/A


       

      Texture, Picture Fills and Border Styles

      02:52

       

      N/A

       

      N/A


       

      Gaps, Widths, and Overlays in a Column Chart

      02:37

       

      N/A

       

      N/A


       

      Controlling a Chart Scale

      03:14

       

      N/A

       

      N/A


    • +

      Scenarios and Goal Seeking


       

      Introduction to Scenarios

      02:11

       

      N/A

       

      N/A


       

      Managing Scenarios

      02:41

       

      N/A

       

      N/A


       

      Using Goal Seek

      02:47

       

      N/A

       

      N/A


       

      Solver

      04:20

       

      N/A

       

      N/A


       

      Saving Solver Models

      02:37

       

      N/A

       

      N/A


       

      Configuring Solver

      02:00

       

      N/A

       

      N/A


    • +

      Advanced Data Analysis


       

      Data Tables

      04:18

       

      N/A

       

      N/A


       

      Data Forms

      02:39

       

      N/A

       

      N/A


       

      Pivot Tables

      02:35

       

      N/A

       

      N/A


       

      Field Settings and Styles in Pivot Tables

      02:40

       

      N/A

       

      N/A


       

      Pivot Charts

      01:40

       

      N/A

       

      N/A


    • +

      Protecting Your Work book


       

      Data Validation

      04:42

       

      N/A

       

      N/A


       

      Data Validation using Functions

      02:21

       

      N/A

       

      N/A


       

      Data Validation with Lists

      01:35

       

      N/A

       

      N/A


       

      Protecting a Worksheet

      04:19

       

      N/A

       

      N/A


       

      Protecting the Entire Workbook

      01:54

       

      N/A

       

      N/A


       

      Protecting Cell Ranges with More Passwords

      02:13

       

      N/A

       

      N/A


       

      Preparing Your Workbook

      03:48

       

      N/A

       

      N/A


    • +

      Worksheet Collaboration


       

      Adding Comments

      02:05

       

      N/A

       

      N/A


       

      Fine-Tuning Comments

      02:09

       

      N/A

       

      N/A


       

      Tracking Changes

      01:47

       

      N/A

       

      N/A


       

      Examining the Change Log

      01:25

       

      N/A

       

      N/A


       

      Accepting and Rejecting Changes

      01:57

       

      N/A

       

      N/A


       

      Sharing Your Workbook

      02:03

       

      N/A

       

      N/A


    • +

      Connection Worksheet to the Web


       

      Embedding and Linking Objects

      01:54

       

      N/A

       

      N/A


       

      Putting Worksheets on the Web

      03:04

       

      N/A

       

      N/A


       

      Performing Web Queries

      02:04

       

      N/A

       

      N/A


       

      Creating a Web Query

      03:41

       

      N/A

       

      N/A


       

      Using Hyperlinks

      01:40

       

      N/A

       

      N/A


       

      Adding a Hyperlink to a Worksheet Location

      01:52

       

      N/A

       

      N/A


    • +

      Working with Macros and XML


       

      Introduction to Macros

      02:17

       

      N/A

       

      N/A


       

      Recording and Playing a Macro

      02:18

       

      N/A

       

      N/A


       

      The Trust Center

      02:56

       

      N/A

       

      N/A


       

      Excel and XML

      02:09

       

      N/A

       

      N/A


       

      Mapping a Simple Document

      02:05

       

      N/A

       

      N/A


    BM

    Lesson Plans

    Status

    Excersice

    Microsoft Excel 2007 - Tips


     

    Calculating Loan Term

     

    N/A


     

    Adding Calculator to Excel Sheet

     

    N/A


     

    Transforming Text to Numbers

     

    N/A


     

    Converting Row into Column

     

    N/A


     

    Adding a Trend Line

     

    N/A


     

    Filling with Gradient

     

    N/A


     

    Inserting a Background Image

     

    N/A


     

    Taking Picture of our Worksheet

     

    N/A


     

    Creating Link from an Excel Workbook

     

    N/A


     

    Embedding a Worksheet

     

    N/A


    Self Assessment

    Attempts

    Status

    Introduction to Excel 2007

    0

     


    Creating and Navigating a Worksheet

    0

     


    Managing and Formatting Worksheet

    0

     


    Formulae and Functions

    0

     


    Organizing Worksheets

    0

     


    Charts and Graphics

    0

     


    Formatting Charts

    0

     


    Scenarios and Goal Seeking

    0

     


    Advanced Data Analysis

    0

     


    Protecting Your Work book

    0

     


    Worksheet Collaboration

    0

     


    Connection Worksheet to the Web

    0

     


    Working with Macros and XML

    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

    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.