00 MICROSOFT EXCEL
Difficulty
Level: Beginner Word Version:
XP Assumed Knowledge:
None
The
aim of these tutorials is to:
show students
how to use Microsoft Excel.
TUTORIALS
01 INTRODUCING EXCEL Why use Excel?
02 BOOKS AND FOLDERS
Creating a new book
03 TAKING CHARGE OF
YOUR DATA
Inserting your own data
04 FORMULAE AND FUNCTIONS
Basic Formulae
05 FORMATTING NUMERICAL
CELLS
General and Built-in Number formats
06 CHARTS
About Charts
07 ROWS, COLUMNS AND
FREEZE PANES
Inserting a row
08 WORKSHEET SETUP
09 SETTING WORKSHEET ORIENTATION
10 SETTING WORKSHEET SCALING
11 SETTING
WORKSHEET SIZE, PRINT QUALITY AND FIRST PAGE NUMBER
Introduction
12 SETTING WORKSHEET MARGINS
13 SETTING WORKSHEET
HEADERS AND FOOTERS
Worksheet Headers and Footers
14 SETTING WORKSHEET
PRINTING OPTIONS
15 FORMATTING
Using the Formatting Toolbar 16 USING AUTOFORMAT
AutoFormat 17 CUTTING, COPYING, PASTING
AND MOVING DATA
Cutting, Copying and Pasting 18 CORRECTING TEXT AND DATA
Spellings 19 FINDING AND REPLACING
TEXT OR DATA
Finding Text or Data
USING MACROS
Recording a macro
USING KEYBOARD SHORTCUTS