Description

Users of previous versions of Excel will notice a dramatic difference to the general appearance of the Excel interface. The previous familiar menu, toolbar and task pane layout has been replaced in the majority of circumstances with a tab based Ribbon structure which is part of the new Microsoft Office fluent user interface. Each tab on the command Ribbon, which appears when MS Excel 2007 is opened, provides access to a more graphical interface to help users quickly locate the command or action that they are seeking.
It is advised that before you continue with this opportunity that you view the short introductory videos to the Office 2007 interface. These will provide you with a clear overview of the major changes which have appeared in Office 2007. As always, each application within Office complies to a basic structure so having engaged with Excel 2007 many of its features will appear in the other Office applications.

Content:

1. Use available Help functions
2. Use and understand different views, ribbons, groups and dialogue boxes
3. Customise the Quick Access Toolbar
4. Format data using some of the new features of Excel 2007
5. Save a worksheet
6. Prepare a worksheet for printing
7. Use simple formulae
8. Sort data
9. Use Conditional Formatting
10. Create charts from data
11. Use Chart Layouts and Styles
12. Insert Headers and Footers

Level: Beginner

Audience: All education staff

Pre Skills:

1. Basic mouse and keyboard skills
2. Competence in the basic skills in a Windows environment

Hardware: Personal computer (PC)

Software: Microsoft Excel 2007