Skip to main content
E-Help
You are currently using guest access (
Log in
)
Spreadsheets - Excel / Open Office
Home
Courses
SPREADSHEETS
Topic outline
Topic 1
Topic 1
Introduction Topics
Introduction to the Main Screens
File
Icons explained - Standard Icons
File
Icons explained - Formating Icons
File
Working with Cells
Selecting Cells
File
Finding and Replacing
File
Freezing Titles
File
Sorting Columns
File
Inserting Columns and Rows
File
Hiding Columns and Rows
File
Naming Ranges
File
Cut Copy Paste and Move Information
File
Editing and Deleting Cell Contents
File
Formating Cells
Basic Formating
File
Applying Colours
File
Applying Borders
File
Alignment Formating
File
Resizing Columns and Rows
File
Formulas and Functions
Working with Formulas and Functions
File
Advanced Functions and Formulas
File
Changing a Formula Result to a Value
File
Absolute References
File
Charts and Graphs
Creating Charts and Graphs in Excel
File
Creating Charts and Graphs in Open Office CALC
File
Other Instructions
Linking a Spreadsheet to a Document
File
Printing Spreadsheets
File
Opening a Text File - CSV
Saving in CSV text Format
File
Mail Merge
URL