Have you unlocked your potential?
Satisfaction Guaranteed.
Here at LearnLocker, we are committed to providing the best possible experience we can. If at any time you are not completely satisfied, we invite you to contact us with your comments and feedback. In addition, you have the right to cancel your membership at anytime. You can even cancel online through our website. Our cancellation policy and terms are covered in detail in the terms and conditions found in the LearnLocker Subscription Membership Agreement.

OpenOffice.org - Calc

Course Outlines
Level 1
Introduction
1.0 The Calc Screen Environment
1.1 Document and Sheets
1.2 Menu Bar and Context Menus
1.3 Columns & Rows
1.4 Navigation
Questions
2.0 Entering Data
2.1 Data Entry Techniques
2.2 AutoFill Entry Techniques
2.3 Erasing Data
2.4 AutoInput
2.5 Undo and Reset
Questions
3.0 Entering Formulas
3.1 Entering Formulas
3.2 Repeating a Formula
3.3 Additional Formulas
Questions
4.0 Basic Calc Functions
4.1 Data Entry Techniques
4.2 AutoFill Entry Techniques
4.3 Erasing Data
Questions
5.0 Formatting
5.1 Data Entry Techniques
5.2 AutoFill Entry Techniques
Questions
6.0 Changing Worksheet Layout
6.1 Inserting Columns/Rows and Cells
6.2 Deleting Columns/Rows and Cells
6.3 Moving Cells
6.4 Copying Cells
Questions
7.0 Saving/Opening and Closing Documents
7.1 File Save or File Save As
7.2 Opening and Closing a File
7.3 Creating a New Calc Document
Questions
8.0 Help System
8.1 Data Entry Techniques
Questions
Level Summary
Post Course Exam
Level 2
1.0 Additional Formatting
1.1 Cell Attributes and Alignment
1.2 Borders and Gridlines
1.3 Numeric Formatting
1.4 Centering Text
1.5 Hiding/Unhiding
Questions
2.0 Conditional Formatting
2.1 Based on Values
2.2 Based on Formulas
Questions
3.0 Adjusting Worksheet Views
3.1 Freeze Layout
3.2 Horizontal/Vertical Split Screens
3.3 Show Formulas/Numbers
3.4 Auto-Outline
Questions
4.0 Printing
4.1 Using Page Break Preview
4.2 Printing Controls
Questions
5.0 Find & Replace
5.1 Using Find and Replace
Questions
6.0 Dates and Time
6.1 Using Dates and Times as Values
6.2 Date and Time Functions and Series
Questions
7.0 Overview of Charting
7.1 Quick Chart Creation
7.2 Chart Types
7.3 Titles/Gridlines and Scaling
7.4 Formatting Basics
7.5 Printing and Copying Charts
Questions
Post Course Exam
Level 3
Introduction
1.0 Using Cell Reference
1.1 Absolute References
1.2 Mixed References
Questions
2.0 Naming Cells
2.1 Assigned Names to Cells
2.2 Additional Creation Methods
Questions
3.0 Formula Auditing Techniques
3.1 Tracing Dependent Cells
3.2 Tracing Precedent Cells
Questions
4.0 The IF and VLOOKUP Functions
4.1 IF Functions and Relational Operators
4.2 Logical Operators
4.3 Nested IF Functions
4.4 Getting Data From Tables
Questions
5.0 Additional Functions
5.1 Statistical
5.2 Math
5.3 Financial
5.4 Text
5.5 Power Functions
Questions
6.0 Multi-sheet Calc Documents
6.1 Renaming Sheets
6.2 Inserting and Deleting Sheets
6.3 Moving/Copying and Grouping
6.4 Formulas Across Multiple Sheets
Questions
7.0 Overview of Database Features
7.1 Sorting Data
7.2 Creating Subtotals
7.3 Filtering
7.4 Data Pilot
7.5 Data Vailidity
Questions
Post Course Exam
Reset Password
Sign In:


You will be sent a link to the Reset Password page. Please note that the link may only be used today.