|
|
|
|
Lesson 1: Opening
Spreadsheet
|
Lesson 9: Working with
Formulas
|
|
Uses of Spreadsheets
|
Creating Formulas
|
|
Toolbars and menus
|
Relative and Absolute Formulas
|
|
|
|
|
Lesson 2: How to get Help
|
Lesson 10: Auto Calculate
and Data Sorting
|
|
Getting Help
|
Auto Calculation
|
|
|
Data Sorting
|
|
Lesson 3: Entering Data
in Spreadsheet
|
|
|
Entering Data
|
Lesson 11: Charts
|
|
|
Chart terminology
|
|
Lesson 4: Navigating,
Inserting, Deleting,
Worksheet
|
|
|
Opening Worksheets
|
Lesson 12: Importing and
Exporting Data
|
|
Adding and Deleting
|
Importing & exporting from Writer
|
|
Insert and Delete
|
|
|
|
|
|
Lesson 5: Formatting
Worksheet
|
|
|
Column width and row height
|
|
|
Numeric formats
|
|
|
|
|
|
Lesson 6: Alignment of Data
and Naming
Ranges
|
|
|
Alignment of data
|
|
|
Naming ranges
|
|
|
|
|
|
Lesson 7: Changing
appearance of cell
|
|
|
Fonts and Merging
|
|
|
Borders
|
|
|
|
|
|
Lesson 8: Printing
Workbooks
|
|
|
Print options
|
|
|
Headers and Footers
|
|
|
|
|
|
|
|