Duration: 1 day | Book this course
Cost: $265.00 + GST
Course Description
Calc is the spreadsheet program of the free, open-source, multi-platform OpenOffice.org suite. It is compatible with other popular applications, such as Microsoft® Excel®.
This one day essential training will get you started with all the basics of OpenOffice.org Calc. Participants will learn how to enter and edit information in a worksheet; manage and navigate worksheets and workbooks; perform calculations and manipulate worksheet data; format the worksheet contents; and prepare, set up, and print information.
Prerequisites
Knowledge of Microsoft® Windows® or Linux® operating system
Who Should Take This Course
New users of OpenOffice.org Calc
Course Objectives
Upon completing this course, you will have learned how to:
- Enter and edit information in a worksheet and manage workbooks.
- Navigate worksheets and workbooks.
- Perform calculations on worksheet data.
- Manipulate worksheet data.
- Format the contents of a worksheet.
- Prepare, set up, and print information.
Course Outline
Getting Started with the Calc Interface
Starting Calc
Getting Help
Entering information
Editing and clearing information in cells
Undoing an Action
Exiting Calc
Managing Worksheets and Workbooks
Creating a new workbook
Starting a new workbook using a Template
Saving and closing
Exploring navigating options
Inserting and labelling worksheets
Moving worksheets from within a workbook
Applying Various Selection Techniques
Copying cells and cell ranges
Deleting cell contents
Moving cells and cell ranges
Manipulating rows and columns
Inserting and deleting rows and columns
Using AutoCalculate and AutoSum
Understanding difference between freezing panes and splitting screen
Formatting Worksheet Information
Formatting characters and numbers in cells and cell ranges
Formatting using the Paintbrush option
Formatting using the Conditional Formatting option
Merging cell information
Copying and clearing formats
Using Formulas and Functions
Understanding basic formula and function structure
Understanding MDAS and BEDMAS mathematical principles
Performing basic calculations
Copying formulas - relative vs absolute references
Creating mixed reference formulas
Replacing cell references with more descriptive names and why
Using Calc for Database and List Management Purposes
Sorting data
Using AutoFilter and Advance Filter to control display of data
Creating subtotals automatically
Getting Things Sorted for Printing
Checking spelling in a worksheet
Finding and replacing information
Setting up page size, orientation, and margins
Incorporating custom headers and footers
Previewing a worksheet
Printing a worksheet
Export entire workbook directly as PDF