EXCEL 2010 Beginner

Course Code: 4243

Overview:
In this course learners will create and edit basic Microsoft Office Excel 2010 workbooks.
Learners will be able to: - create a basic worksheet using Microsoft Office Excel 2010; perform calculations in an Excel worksheet; modify an Excel worksheet; format a worksheet; print Excel workbook contents; manage an Excel workbook.

Course Content

A selection of the following topics will be covered. Other skills not listed can be requested.

Creating a Basic Excel Worksheet
Identify the Excel User Interface
Customize the Excel Interface
Work with Cells
Enter Data in an Excel Workbook
Use Microsoft Office Help

Performing Calculations in an Excel Worksheet
Create Basic Formulas
Calculate Using Functions
Copy Formulas and Functions

Modifying an Excel Worksheet
Manipulate Worksheet Data
Modify Worksheet Elements
Search Worksheet Data
Modify Rows and Columns

Modify Fonts
Spell Check a Worksheet
Apply Number Formats
Add Borders and Colour to Cells
Align Cell Contents
Apply Cell Styles

Printing Excel Workbooks
Set Page Layout Options
Print a Workbook

Managing an Excel Workbook
Format Worksheet Tabs
Manage Worksheets
Manage Workbook Views

Entry Requirements:

Learners should be familiar with using personal computers and a mouse and a keyboard. You should be comfortable using the Windows environment and should be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Career Options:

ITQ Level 1 Award or Certificate, nationally recognised IT qualifications which can be tailored to individual and business needs.

Course Starting: Wednesday 19 Sep 2012 - Part Time - Tonbridge