PAKISTAN COMPUTER BUREAU

"Live up to your traditions and
add to it another chapter of glory."
Muhammad Ali Jinnah

             

Home

Profile

Information &
Services

Online
Testing

Trainings

Projects

Jobs

Tenders

Home  >  Basic IT Training  > Course outline  >  Spreadsheets (Open Office Calc)

About PCB

Related Links

Downloads

FAQs

Site Map

Contact PCB

Terms of Use

Privacy Policy

Pakistan.Gov


Course Outline of
Spreadsheets (Open Office Calc)

Lesson 1: Opening Spreadsheet

Lesson 9: Working with Formulas

            Uses of Spreadsheets

            Creating Formulas

            Toolbars and menus

            Relative and Absolute Formulas

Lesson 2: How to get Help

Lesson 10: Auto Calculate and Data Sorting

            Getting Help

            Auto Calculation

            Data Sorting

Lesson 3: Entering Data in Spreadsheet

            Entering Data

Lesson 11: Charts

            Chart terminology

Lesson 4: Navigating, Inserting, Deleting,                Worksheet

            Opening Worksheets

Lesson 12: Importing and Exporting Data

            Adding and Deleting

            Importing & exporting from Writer

            Insert and Delete

Lesson 5: Formatting Worksheet

            Column width and row height

            Numeric formats

Lesson 6: Alignment of  Data and Naming                Ranges

            Alignment of data

            Naming ranges

Lesson 7: Changing appearance of cell

            Fonts and Merging

            Borders

Lesson 8: Printing Workbooks

            Print options

            Headers and Footers

The Official website of Pakistan Computer Bureau (PCB)


Copyright Pakistan Computer Bureau 2004, All Rights Reserved.