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.
Target Student
General office workers as well as data analysts.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- explore various elements of the OpenOffice Calc interface.
- create a spreadsheet.
- perform calculations.
- modify a spreadsheet.
- format a spreadsheet.
- audit data in a spreadsheet.
- analyze data.
- present data using charts.
- finalize a spreadsheet.
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
- Intel® Pentium® IV 1.5 GHz processor (2 GHz recommended)
- 256 MB RAM
- 1.5 GB disk space or larger
- CD-ROM or DVD drive
- VGA or higher video adapter and monitor
- Keyboard and mouse or other input device
- Network cards and cabling for local network access
- Printer
- Projection system to display the instructor's computer screen
Platform Requirements
- Microsoft® Windows® 98, ME, 2000 (Service Pack 2 or higher), XP, 2003, or Vista (enhanced Vista integration from version 2.2); Solaris™ 8 OS or higher; Linux kernel version 2.2.13 or higher; glibc2 version 2.2.0 or higher; Power Mac G3 400 Mhz or higher.
Software Requirements
- OpenOffice 2.3 Suite
- Adobe® Reader®
- Microsoft® Windows® XP Professional with Service Pack 2
Delivery Method
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
- Topic 1A: Explore the Interface
- Topic 1B: Obtain Help
- Topic 1C: Customize the Interface
Lesson 2: Creating a Spreadsheet
- Topic 2A: Enter Data in a Spreadsheet
- Topic 2B: Save a Spreadsheet
Lesson 3: Performing Calculations
- Topic 3A: Calculate Using Basic Formulas and Functions
- Topic 3B: Calculate Using Advanced Functions
Lesson 4: Modifying a Spreadsheet
- Topic 4A: Manipulate Data
- Topic 4B: Sort and Filter Data
- Topic 4C: Search for Data in a Spreadsheet
- Topic 4D: Spell-Check a Spreadsheet
Lesson 5: Formatting a Spreadsheet
- Topic 5A: Format Cells
- Topic 5B: Apply Conditional Formatting
Lesson 6: Auditing Data in a Spreadsheet
- Topic 6A: Trace Cells
- Topic 6B: Troubleshoot Errors in Formulas
- Topic 6C: Add Data Validation Criteria
Lesson 7: Analyzing Data
- Topic 7A: Create Scenarios
- Topic 7B: Analyze Data Using Goal Seek
- Topic 7C: Analyze Data Using DataPilot
Lesson 8: Presenting Data Using Charts
- Topic 8A: Create a Chart
- Topic 8B: Modify a Chart
Lesson 9: Finalizing a Spreadsheet
- Topic 9A: Prepare a Spreadsheet for Distribution
- Topic 9B: Export a Spreadsheet
