OpenOffice.org: Calc
Overview:
This one-day course provides students with the knowledge and skills to design efficient, accurate and complex spreadsheets to accomplish a variety of tasks and analyze complex sets of data. This course is based on the documentation provided by the OpenOffice.org Community.
Prerequisites:
Prior to attending this class, students should have the following experience:
- Basic Desktop usage (mouse, keyboard, etc.).
- Basic experience with OpenOffice.org is helpful.
Objectives:
Upon successful completion of this course, students should be able to:
- Configure Calc
- Edit, format, sort and filter data content
- Use functions to manipulate data effectively
- Turn data into presentable charts and other output
- Implement Macros to increase efficiency and design a simple database using Calc
Course Topics:
- Introducing Calc
- Entering, Editing and Formatting Data
- Formulas and Functions
- Creating Charts and Graphs
- Printing with Calc
- DataPilot
- Data Analysis Using Scenarios and Goal Seek
- Using Graphics in Calc
- Linking Calc Data
- Using Styles in Calc
- Editing, Changing and Reviewing
- Calc Macros
- Calc as a Simple Database