AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

OpenOffice Calc

Print Version

Impress is the slideshow/presentation component of OpenOffice.org. It allows you to create, edit, save, and show slideshows and presentations. If you’ve ever used a presentations application like Microsoft® PowerPoint, it shouldn’t be hard to learn Impress. This course shows you the Impress way to do the most common presentation functions.

This course comes in two versions. While the training is the same each runs on a different Operating System (Linux and Windows).

3 levels - 92 training modules

 

Available Options

OpenOffice.org 1.1 Calc - Set of 3 (Individual License)
Makau Course Cover - Box Shot  
CD-ROMs, e-Study Guides$149.00Add To Cart
OpenOffice.org 1.1 Calc - Set of 3 (Library License)
Makau Course Demo  Makau Course Cover - Box Shot  
CD-ROMs, e-Study Guides$298.00Add To Cart
OpenOffice.org 1.1 Calc - Set of 3 (1 Year Access)
Makau Course Demo  Makau Course Cover - Box Shot  
1 YR ONLINE, e-Study Guides$149.00Add To Cart

Course Instructor: Dennis P. Taylor

Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars, including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books for spreadsheets. Dennis brings a combination of in-depth knowledge and training experience to his spreadsheet training courses. Watch and Learn in minutes with Dennis.

Course Outline

Level 1
The Calc Screen Environment
  • Documents & Sheets
  • Menu Bar & Context Menus
  • Columns & Rows
  • Navigation
Entering Data
  • Data Entry Techniques
  • AutoFill Entry Techniques
  • Erasing Data
  • AutoInput
  • Undo & Redo
Entering Formulas
  • Entering Formulas
  • Repeating a Formula in Adjacent Columns
  • Additional Formulas
Basic Calc Functions
  • Summation & Averaging
  • Recalculating Effects & Hierarchy of Operations
  • Other Functions—Function AutoPilot
Formatting
  • Object Toolbar
  • Adjusting Column Widths & Row Heights
Changing Worksheet Layout
  • Inserting Columns, Rows & Cells
  • Deleting Columns, Rows & Cells
  • Moving Cells
  • Copying Cells
Saving, Opening & Closing Documents
  • File Save or File Save AS
  • Opening & Closing a File
  • Creating a New Calc Document
Help System
Level Summary
Level 2
Additional Formatting
  • Cell Attributes & Alignment
  • Boarders & Gridlines
  • Numeric Formatting
  • Centering Text
  • Hiding/Unhiding
Conditional Formatting
  • Based on Values
  • Based on Formulas
Adjusting Worksheet Views
  • Freeze Layout
  • Horizontal/Vertical Split Screens
  • Show Formulas/Numbers
  • Auto-Outline
Printing
  • Using Page Bread Preview
  • Printing Controls
Find & Replace
  • Using Find & Replace
Dates & Times
  • Using the Dates & Times as Values
  • Date & Time Functions & Series
Overview of Charting
  • Quick Chart Creation
  • Chart Types
  • Titles, Gridlines & Scaling
  • Formatting Basics
  • Printing & Copying Charts
Level 3
Using Cell Reference
  • Absolute References
  • Mixed References
Naming Cells
  • Assigned Names to Cells
  • Additional Creation Methods
Formula Auditing Techniques
  • Tracing Dependent Cells
  • Tracing Precedent Cells
The IF & VLOOKUP Functions
  • IF Functions & Relational Operators
  • Logical Operators (AND & OR) with the IF Function
  • Nested IF Functions
  • Getting Data From Tables with VLOOKUP
Additional Functions
  • Statistical—COUNT, COUNTA, RANK & LARGE
  • Math—ROUND, RANDBETWEEN & COUNTBLANK
  • Financial—PMT & FV
  • Text—MD, FIND, PROPER & TRIM
  • Power Functions—COUNTIF & SUMIF
Multi-Sheet Calc Documents
  • Renaming Sheets
  • Inserting & Deleting Sheets
  • Moving, Copying & Grouping
  • Formulas Across Multiple Sheets
Overview of Database Features
  • Sorting Data
  • Creating Subtotals
  • Filtering
  • Data Pilot
  • Data Validity