Basic Introduction to Excel
The
elements of the Excel Screen
Spreadsheet Functions
Creating a Workbook
Create a New Workbook
Save and Name Workbook
Open Existing Workbook
Using Zoom
Entering and Editing Data
Enter
Text and Numbers
Edit Cell Contents
Selecting Cells
Moving around a Spreadsheet
Delete Data
Use AutoFill
Drag and Drop
Cut, Copy and Paste
Find and Replace
Check Spelling
Basic Formulae
Use
AutoSum
Enter Simple Formulae
Edit a Formula
Understanding Error Messages
Absolute and Relative Cell Referencing
Formatting Worksheets
Insert and Delete Rows and Columns
Resize Rows and Columns
Using Autofit
Insert and Delete Cells
Changing the Font Type, Size and Colour
Changing the Number Format
Currency and Date Formats
Changing Alignment
Rotating Text
Printing Workbooks
Set
Page Margins and Orientation
Scale Print Output
View Worksheet in Print Preview
Set Up Headers and Footers
Add Fields in Headers and Footers
Print Worksheet
Charts
Types
of Chart
Creating a Chart