DURATION:- Two days
PARTICIPANTS:- Beginners and those with some experience of other spreadsheets
OVERVIEW:- This course is designed to familiarise the beginner with the basic concepts of Excel worksheets. Delegates learn how to create, change, manipulate and print data from the worksheet.
OBJECTIVES:- At the end of the course the delegates will be able to:
understand the Windows environment and the Excel screen
initiate and end a working session
create a worksheet and save it
enter data into worksheets and control alignment
move easily and quickly around worksheets
enhance text with the use of different fonts
move and copy data
apply headers and footers
draw lines and add borders
print the worksheet
create formulas to make calculations
use the split screen
name cells and ranges
link information from one worksheet to another
manage files
use functions
protect the worksheet
create and print graphs from worksheets
create a database within the worksheet
sort, search for and retrieve specific data
create simple macros to speed up tasks within the worksheet
FURTHER TRAINING:- Creative Connections Advanced Course
Consultancy to assist with specific requirements