Excel 2007 Essential Skills
Course Information
This one day course is designed to introduce delegates to the concepts and functionality of an electronic spreadsheet.
Delegates will be able to use Excel efficiently and confidently by creating spreadsheets encompassing simple financial and mathematical functions.
Pre-requisites
Those attending this course should have a basic understannding of the WIndows environment and be comfortable with a mouse.
Course Objectives
By the end of the course delegates will be able to:
- Recognise the different elements that comprise an Excel workbook
- Create and save Excel workbooks
- Manipulate worksheets in terms of naming, moving, adding and deleting
- Enter data into a new and existing worksheet
- Apply formatting to change the appearance of text
- Apply cell borders and shading
- Change the appearance of numeric data using shortcut icons and menus
- Calcualte using simple mathematical functions
- Calcualate using built-in functions
- Modify page margins, orientation and scaling
- Apply headers and footers to the printed page
- Print the whole worksheet or specific areas of the worksheet only
- Utilise the Office Assistant & Help features
What you will learn:
Lesson 1 – Tour of Excel
The Office Button
Ribbons
Groups
Clipboard
Lesson 2 – Creating and Saving a Workbook
Autofill and Editing Data
Row & Column widths
Inserting Rows & Columns
Selecting / Deselecting
Organising Sheets
Renaming Worksheets
Inserting Blank Worksheets
Moving Worksheets
Copying and Deleting Worksheets
Lesson 3 – Entering and Editing Data
Creating and Editing Custom Lists
Cut, Copy and Paste
Creating a New Workbook
Lesson 4 – Creating Formulae
Creating simple calculations
AutoSum
Numeric Order – BODMAS
Absolute Cell Referencing
Lesson 5 – Functions
Sum
Average
Max
Min
Lesson 6 – Formatting
Themes
Quick Format icons
Currency Formatting
Formatting Fractions
Formatting as a Table
Cell Styles
Cell & Font Formatting
Alignment
Lesson 7 – Preparing to Print
Page Setup
Page Background
Page Breaks
Print Titles
Scale to Fit
Printing
