Excel Foundation
THIS COURSE CAN BE RUN AS A CLOSED COURSE FOR YOUR COMPANY OR AS A 1 TO 1 COURSE FOR INDIVIDUALS. PLEASE CALL FOR INFORMATION AND DATES
This course is to introduce the user to the fundamental principles of using Excel 2007 and to give an understanding of the power of the Excel 2007 spreadsheet system. Can be followed by Excel 2007 Intermediate and Excel 2007 Advanced, also one day courses.
Sorry, there are currently no dates scheduled for this course.
Course outline
User Interface
Use the Office Button, Ribbons, Command Tabs and Sets and Contextual Tabs; Customise the Quick Access Toolbar.
Creating Workbooks
Open electronic workbooks; Enter text and numbers; Enter formulas; Rename worksheets; Colour tabs; Save workbooks; Close workbooks.
Formatting Worksheets
Modify cell size and alignment; Apply number formats; Apply font formats; Apply outlines; Border drawing.
Modifying Workbooks
Delete cell contents; Delete worksheets; Revise text and numbers; Rotate and indent text; Revise formulas; Copy and move data; Insert, modify, and delete rows and columns; Using multiple worksheets.
Smart Tags
Context sensitive buttons to choose different options.
Functions
Use simple functions; Extend AutoSum.
Printing Workbooks
Preview and print worksheets; Print the screen and ranges; Print headers and footers, including pictures.