Excel 2007/2010 Foundation Overview
| One Day Course
Minimum of 1 Attendee – Maximum of 10 Attendees |
|
| Who should attend | Anyone who has never used Excel before (or any other spreadsheet package) or has some experience but is unfamiliar with using the software to perform calculations and create charts. |
| Requirements | Delegates must be confident in using Windows and a mouse. Delegates must be confident with basic maths i.e. addition, subtraction, multiplication, division. |
| Aim | By the end of the course, you will be able to use the main features of Excel to create and alter simple spreadsheets, use formulae and develop charts. |
| What you will learn | In particular you will be able to:
|
| 09:00-10:30 | Getting familiar with the user interface Ribbon at the top of the window; What is a Spreadsheet; Entering Text and Numbers; The Mouse and Excel; Saving a Spreadsheet; Using the Autofill feature; |
| 10:45-12:15 | Creating Formulas; Using the Autosum feature; Inserting and Deleting Rows and Columns; Good Spreadsheet Practice; Copying Formulae; Cell Referencing; Printing a Spreadsheet |
| 13:00-14:30 | Formatting: Alignment; Number Formats; Column Widths; Borders: Shading; Bold; Italics; Underline; Fonts; Use ThemesPrint Preview; Page Setup; Paper Orientation; Scaling; Headers and Footers; Margins |
| 14:45-15:45 | Types of Charts; Creating Charts using the Keyboard |
| 15:45-16:00 | Q&A; Course close |
All courses are delivered on clients premises or at selected locations throughout the UK. We can provide training rooms at several partner sites.
All times used are approximate and are dependant on the number of attendees.
Download the PDF copy Excel Foundation Overview (110)
