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/OpenOffice3.1_Calc

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

    OpenOffice.org 3.1 Calc

    70 Lessons      03:51:55 hrs

    OpenOffice.org Calc is the spreadsheet program which helps to organize, present and manipulate the data. Calc is similar to Microsoft Office’s Excel. This course explains how to work in OpenOffice.org Calc and its advanced features.

    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

    • +

      OpenOffice.org 3.1


       

      What is OpenOffice.org 3.1?

      02:52

       

      N/A

       

      N/A


       

      Why use OpenOffice.org?

      03:35

       

      N/A

       

      N/A


       

      Getting Started with Openoffice.org 3.1 Calc

      03:10

       

      N/A

       

      N/A


       

      Benefits of Calc

      03:12

       

      N/A

       

      N/A


    • +

      Creating and Navigating a Spreadsheet


       

      Interface Ride

      06:25

       

      N/A

       

      N/A


       

      Creating a new Workbook

      02:30

       

      N/A

       

      N/A


       

      Saving a Workbook

      05:16

       

      N/A

       

      N/A


       

      Closing a Saved Workbook

      02:29

       

      N/A

       

      N/A


       

      Opening the Existing Workbook

      03:15

       

      N/A

       

      N/A


       

      Sending the Workbook as an Email

      02:54

       

      N/A

       

      N/A


       

      Exporting the Workbook

      03:27

       

      N/A

       

      N/A


    • +

      Working with Cells


       

      Inserting your Data into Cells

      08:09

       

      N/A

       

      N/A


       

      Moving and Grooving Cells

      03:09

       

      N/A

       

      N/A


       

      Selecting Cells

      04:52

       

      N/A

       

      N/A


       

      Cut, Copy and Paste

      03:24

       

      N/A

       

      N/A


       

      Undo, Redo and Repeat

      03:44

       

      N/A

       

      N/A


       

      Finding and Replacing Cell Contents

      05:46

       

      N/A

       

      N/A


    • +

      Filling


       

      Auto Fill

      04:17

       

      N/A

       

      N/A


       

      Custom Fill – Using Series

      04:08

       

      N/A

       

      N/A


    • +

      Making Calculations in Calc


       

      Defining Formulas – I

      03:43

       

      N/A

       

      N/A


       

      Defining Formulas – II

      02:58

       

      N/A

       

      N/A


       

      Cell References

      03:58

       

      N/A

       

      N/A


       

      Working with Functions – I

      02:40

       

      N/A

       

      N/A


       

      Working with Functions – II

      03:06

       

      N/A

       

      N/A


       

      Working with Functions – III

      03:11

       

      N/A

       

      N/A


    • +

      Viewing a Spreadsheet


       

      Page Views

      03:47

       

      N/A

       

      N/A


       

      Displaying Toolbars, Rulers and Status Bar

      02:02

       

      N/A

       

      N/A


       

      Highlighting Numerical Values

      01:16

       

      N/A

       

      N/A


    • +

      Handling Cells, Columns and Rows


       

      Inserting a Cell, Row or Column

      03:31

       

      N/A

       

      N/A


       

      Deleting a Cell, Row or Column

      02:48

       

      N/A

       

      N/A


       

      Merging & Splitting Cells

      04:02

       

      N/A

       

      N/A


       

      Changing Width and Height

      04:31

       

      N/A

       

      N/A


       

      Hiding and Restoring Columns and Rows

      02:25

       

      N/A

       

      N/A


    • +

      Formatting Cells


       

      Formatting Numbers

      05:07

       

      N/A

       

      N/A


       

      Fonts and Font Effects

      05:04

       

      N/A

       

      N/A


       

      Text Alignments

      03:57

       

      N/A

       

      N/A


       

      Auto Format

      02:28

       

      N/A

       

      N/A


       

      Applying Styles

      03:03

       

      N/A

       

      N/A


       

      Using Conditional Format

      02:30

       

      N/A

       

      N/A


    • +

      Inserting Graphics


       

      Inserting Images

      02:22

       

      N/A

       

      N/A


       

      Working with Graphics

      07:04

       

      N/A

       

      N/A


       

      Insert images from Gallery

      02:08

       

      N/A

       

      N/A


       

      Drawing on your Own

      02:10

       

      N/A

       

      N/A


       

      Inserting OLE Object

      02:53

       

      N/A

       

      N/A


    • +

      Other Insert Features


       

      Chart Using Chart Wizard

      07:51

       

      N/A

       

      N/A


       

      Editing the Chart

      03:50

       

      N/A

       

      N/A


       

      Keeping Links with Hyperlinks

      04:19

       

      N/A

       

      N/A


       

      Inserting Notes

      01:43

       

      N/A

       

      N/A


    • +

      Managing Worksheets


       

      Adding and Deleting Sheets

      03:42

       

      N/A

       

      N/A


       

      Selecting and Renaming Sheets

      01:25

       

      N/A

       

      N/A


       

      Copying and Moving Sheets

      01:56

       

      N/A

       

      N/A


       

      Hiding and Restoring Sheets

      01:15

       

      N/A

       

      N/A


    • +

      Printing your Work


       

      Previewing the Printout

      02:18

       

      N/A

       

      N/A


       

      Formatting Page Printout

      06:24

       

      N/A

       

      N/A


       

      Dealing with Page Breaks

      02:15

       

      N/A

       

      N/A


       

      Printing a Calc Spreadsheet

      02:27

       

      N/A

       

      N/A


    • +

      Sharing


       

      Protecting the Workbook

      01:21

       

      N/A

       

      N/A


       

      Protecting Worksheet

      02:01

       

      N/A

       

      N/A


       

      Protecting Cells

      02:09

       

      N/A

       

      N/A


       

      Tracking the Changes in a Document

      04:08

       

      N/A

       

      N/A


       

      Comparing and Merging Workbook

      02:12

       

      N/A

       

      N/A


    • +

      Report Creation


       

      Sorting the Records

      02:23

       

      N/A

       

      N/A


       

      Filtering the Records

      02:12

       

      N/A

       

      N/A


       

      Groups and Outline

      01:52

       

      N/A

       

      N/A


       

      Sub Total List

      03:12

       

      N/A

       

      N/A


       

      Data Pilot

      02:45

       

      N/A

       

      N/A


    • +

      Handling Data


       

      Trace Dependence and Precedence

      02:18

       

      N/A

       

      N/A


       

      Goal Seek

      02:58

       

      N/A

       

      N/A


       

      Solver

      01:12

       

      N/A

       

      N/A


       

      Validity Checking

      02:29

       

      N/A

       

      N/A


    Self Assessment

    Attempts

    Status

    OpenOffice.org 3.1 Calc

    0

     


    Creating and Navigating a Spreadsheet

    0

     


    Working with Cells

    0

     


    Filling

    0

     


    Making Calculations in Calc

    0

     


    Viewing a Spreadsheet

    0

     


    Handling Cells, Columns and Rows

    0

     


    Formatting Cells

    0

     


    Inserting Graphics

    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

    Abstraction
    The term abstraction denotes the process or the result of a generalization. Generalization describes objects by qualities common to all objects of a certain class of objects

    Accessibility
    Ability of an application to provide its functionality also in situations where the usage of input and output devices is restricted for some reason

    Add-In
    An add-in is a functional extension for the OpenOffice.org application on the basis of UNO components, which interact with parts of the application that were especially laid out to be extended. Examples of Add-Ins are Chart and Calc Add-Ins.

    Any
    All purpose data type for variables in UNOIDL. An any variable contains whichever data type is specified for UNOIDL.

    API
    Application Programming Interface. The entirety of published methods, properties and other means for software developers to access an application through software they write using this application.

    Assistive Technology
    Devices which can be used to improve accessibility, see Accessibility.

    AT
    Assistive Technology, devices which can be used to improve accessibility. See Accessibility.

    Automation
    Communication protocol between OLE automation objects. See OLE Automation.

    AWT
    Abstract Window Toolkit. The OpenOffice.org API contains a module com.sun.star.awt with abstract specifications for a window toolkit that handles graphical devices, window environments and user interfaces.