Who is it for?
This course is suitable for complete beginners to Excel and for anyone who is self taught. It is aimed at those who need to produce and maintain spreadsheet applications regularly using simple calculations.
Description
This course focuses on quick ways to get started with Excel. You will learn about the layout of the Excel screen and be aware of the features of the workbook and worksheet structure.
You will learn quick methods for entering, editing and formatting data and understand Excel formulae and functions to a level where you will be able to compile sales figures, create purchase orders or analyse bank statements.
Course content
-
Creating new workbooks
-
Saving, opening and closing workbooks
-
Using multiple worksheets
-
Entering text and values
-
The undo and redo command
-
Using named ranges
-
Moving and copying cells
-
Data series
-
Entering a formula
-
Absolute and relative cell referencing
-
Formatting
-
Printing
Course duration
1 day, normally between 9:30 and 4:30