MICROSOFT EXCEL

CONTENTS

INTRODUCING EXCEL

Introducing Excel
Opening up Excel
Using pop-down menus
Short-cut menus
Activating and moving through cells
Understanding toolbars and how they work
Using the Standard toolbar
Inserting, Deleting and Renaming Worksheets

FORMATTING YOUR WORKSHEET

Adding Rows and Columns
Changing the sizes of rows and columns
Selecting cells
Using Freeze Panes
Setting preferred worksheet margins
Setting the worksheet size and orientation

FORMATTING YOUR WORKSHEET CONTENTS (PART 1)

Using the Formatting toolbar
Using the Format Cells box
Using Styles on a Worksheet
Creating your own Style
Using the Format Painter
Using AutoFormat

FORMATTING YOUR WORKSHEET CONTENTS (PART 2)

Inserting, Amending and Deleting Headers and Footers
Finding Content
Replacing Content
Checking and Correcting Spellings and Grammar
Using the Thesaurus facility

USING FORMULAE AND FUNCTIONS

Formulae and Functions
Formulae
Linking Formulae across Worksheets

CREATING A CHART IN YOUR WORKSHEET

INSERTING GRAPHICS INTO A WORKSHEET

Using Clip Art
Inserting an image from a file
Editing a graphic
Using AutoShapes

TABLES

Inserting a table
Drawing a table
Inserting rows and columns
Moving and resizing a table
Using the Tables and Borders toolbar
Understanding table properties

USING MACROS

Recording a macro
Running a macro

WORD AND THE WEB

Using the Web Wizard

CREATING A WEB PAGE

Using hyperlinks in your Web Page
Saving your Web Page
Using a Web Page template
Web Page themes
Previewing your Web Page

USING KEYBOARD SHORTCUTS