search our courses:
Quick Navigation
Microsoft Excel 2007 Introduction course
Download PDF version of Excel 2007 Introduction course outline
Overview
This course introduces the basic skills necessary to create and manipulate Excel spreadsheets. It includes basic tasks such as: using shortcuts, working with ranges, building formulae, editing and formatting data, printing and the creation of graphs.
Audience
Users new to spreadsheets.
Course Objectives
The objectives of the course are to:
- Provide new users with the knowledge to create and edit basic spreadsheets.
- To introduce the basics related to creating formulae
- To teach users how to create and edit basic graphs
Prerequisites
Delegates should be familiar with Windows.
Course Contents (1 day)
- Basic principles
- Understanding the screen layout
– ribbons, toolbars etc. - Cursor shapes and their actions
- Compatibility issues with older versions
- Understanding the screen layout
- Working with cells
- Data entry and editing
- Using shortcut menus
- Autofill (and options)
- Copying and Moving data
- Undo & ReDo
- Clear formats
- Formulae
- Setting up a basic worksheet
- Order of calculation - BODMAS
- Creating your own formulae
(Some basic maths is covered) - Using in-built functions
e.g. sum, average, count - Relative v Absolute referencing
- Formatting
- Using the formatting toolbar
- Inserting/Deleting rows & columns
- Hide & Unhide Rows/Columns
- Altering column widths and row heights
- Adding Colours/Borders/Shading
- Alignment & Merge
- Number formatting
- Format painter and Autoformat
- Printing
- Print preview
- Working with Page Break Preview
- Headers and Footers
- Adjusting Margins
- Shrink to fit
- Setting different Print areas
- Larger documents
- Splitting and freezing
- Zoom
- Graphs
- Insert Chart v Quick chart
- Bar/Line/Pie charts
- Adding/Editing Titles, borders,
scales and legends - Printing Charts
- Print sheets & charts on the same page