INTRODUCTION
MOVING BETWEEN WORKSHEETS & CELLS
HIGHLIGHTING & COPYING
CREATING A WORKBOOK
AUTO & MANUAL INSERT
ORGANISING SHEETS
MERGING INSERTING HIDING
WRAPPING TEXT
INSERTING GRAPHICS
NAMING & DEFINING TITLES
NAMING & DEFINING CELL RANGES
CREATING FORMULAE
CALCULATING USING NAME RANGES
TITLES COLOUR BORDERS
FORMATTING STYLES
CREATING HEADERS & FOOTERS
USING DATA LISTS AS TEMPLATES
WORKBOOKS
LINKING WORKBOOKS
BREAKING & FIXING LINKS
USING CHART WIZARD
PRINTING THE WORKSHEET
HYPERLINKS
EXCEL AS A WEB PAGE
CONSTRUCTING A SPREADSHEET
FORMULAE IN CELLS
FORMATTING & CREATING CHARTS
CALCULATING SUMS
FUNCTIONS
RELATIVE CELL REFERENCES
ABSOLUTE CELL REFERENCES
FORMATTING SPREADSHEETS
USING SORT ASCEND BUTTON
SORT BY DIALOG BOX
CUSTOM SORTING
ORGANISING DATA INTO LEVELS