
Overview
Worksheets are an integral part of financial analysis and audit. Experts pore over pages of mundane data to make interpretations and permutations. During such operations, they have to be meticulous as overlooking even a minor detail would prove disastrous and require starting the calculation afresh. The ability to manipulate data and perform calculations automatically using a software application certainly has more advantages over the printed format. In this course, you will use the features and tools present in OpenOffice Calc 2.3 to manage data.
Course Objectives
You will use the features and tools present in OpenOffice Calc 2.3 to manage data. You will also apply advanced analysis techniques to more complex data sets. In addition, you will apply visual elements and advanced formulas to a spreadsheet.
Prerequisites
Students should be familiar with using personal computers.
General office workers as well as data analysts.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Course duration
1 Day(s)
Course outline
Lesson 1: Exploring the OpenOffice Calc Interface
Target Student
Hardware Requirements
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components
Platform Requirements
Software Requirements
Delivery Method
Lesson 2: Creating a Spreadsheet
Lesson 3: Performing Calculations
Lesson 4: Modifying a Spreadsheet
Lesson 5: Formatting a Spreadsheet
Lesson 6: Auditing Data in a Spreadsheet
Lesson 7: Analyzing Data
Lesson 8: Presenting Data Using Charts
Lesson 9: Finalizing a Spreadsheet