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:

  • Familiarise with the new screen, such as the Ribbon at the top of the window
  • Create, save, close, open and print spreadsheets
  • Insert and delete rows or columns in your spreadsheet
  • Get Excel to automatically add up numbers using AutoComplete
  • Copy formulae in your spreadsheet whilst keeping one of the cell references constant
  • Alter the look of the numbers and text, to make parts of the spreadsheet stand out using Themes
  • Visually represent numbers and text (as a chart) in your spreadsheet, to make them stand out and easy to understand
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)

Categories
Testimonials

“Found it really useful – short and sharp and suited my needs”

Employees @ Goodyear Dunlop UK Ltd
Goodyear Dunlop UK Ltd