Course details
Fee	£115
Days	1
Code	EX071

Course dates
Feb
Mar	2
Apr
May
Jun
Jul

Click on a course date to book
e-mail us
or call us on
0845 650 6500

Excel 2007 Introduction

The Excel 2007 Introduction training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South Wales

Overview

This course introduces the skills necessary for productive development of workbooks. It includes tasks to explore Excel, create simple formulas, copy and move data, and print worksheets. The student will also learn how to work with ranges and use the Office Assistant, basic workbook skills and page set up

Examination information

There is currently no examination associated with this course

Prerequisites

Before attending this course, students must have:

Knowledge and experience in using a Windows environment

Course outline

Module 1: Exploring Excel

Using the Ribbon
Working with Worksheets
Using the Task pane
Changing Toolbare and Menu Options

Module 2: Using Basic Workbook Skills

Selecting a Cell
Scrolling
Entering Text and Numbers
Data Shortcuts

Module 3: Working with Ranges

Using Ranges
Selecting Ranges
Using Autofill Features

Module 4: Creating Simple Formulas

Entering Formulas
Using Functions
AutoSum
Checking Errors

Module 5: Copying and Moving Data

Copying/Cutting and Pasting
Using the Clipboard Task Pane
Creating an Absolute Reference

Module 6: Printing

Previewing A Worksheet
Printing a Range

Module 7: Using Page Set up

Setting Margins
Creating Headers and Footers

Module 8: Formatting Numbers

Using Number Formats

Module 9: Formatting Text

Formatting Cell Text
Wrapping Text
Aligning Text

Module 10: Working with Columns and Rows

Changing Width and Height
Adjusting Automatically
Inserting and Deleting Rows and Columns

Module 11: Formatting Cells

Formatting Borders and Colours
Clearing Formats
Using the Format Painter

Module 12: Using Automatic Formatting and Styles

Using the Auotmatic Formatting Features
Creating a Style
Merging Styles

Module 13: Using Large Worksheets

Increasing Magnification
Splitting the Window
Freezing Panes