Microsoft Excel 2007 / 2010 Level 1

Excel 2007 / 2010 Level 1

Course Aims:

This course is aimed at people who want to learn how to use Microsoft Excel 2007 / 2010 to carry out basic spread sheet tasks including the creation of simple formulas and functions. The course is suitable for either beginners or people with limited experience of the product.

Course Pre-requisites:

Students who wish to attend this course need to be familiar with the use of a PC keyboard and mouse.

Course Objectives:

On completion of this course delegates will be able to:

• Understand the concepts of spread sheets
• Create, edit and format a worksheet
• Use formulas for basic calculations
• Copy and move data
• Preview and print worksheets
• Use Page Setup to edit page margins, headers and footers
• Apply automatic formatting
• Insert columns and rows
• Use automatic formatting
• Create and edit basic charts

Course Content:

Introduction and Objectives

Exploring Excel

• Starting & Exiting Excel
• Microsoft Office Backstage
• Working with Excel Windows, Worksheets & Menu Commands
• Displaying & Hiding Toolbars

Using Basic Workbook Skills

• Creating & Saving a New Workbook
• Selecting Cells, Entering & Editing Data
• Opening an Existing Workbook
• Using Data Entry Shortcuts
• Renaming an Existing Workbook

Working with Ranges

• Selecting Adjacent & Non-Adjacent Ranges
• Entering Values Into a Range
• Using the Auto Fill Feature

Creating Simple Formulas

• Using Formulas, AutoSum Button
• Using the AutoSum List
• Entering & Editing Basic Functions
• Inserting Functions in Formulas
• Using the AutoCalculate Feature
• Using Range Borders to Modify Formulas

Copying & Moving Data

• Copying/Cutting & Pasting Data
• Using the Paste Options Smart Tag
• Using the Paste List
• Using the Clipboard Task Pane
• Creating an Absolute Reference
• Using Undo & Redo

Printing & Previewing Worksheets

Using Page Setup

• Editing Margins, Orientation, Alignment, Headers & Footers, Printing Gridlines, Repeating Row & Columns Labels Scaling a Worksheet, Page Break Preview & Setting/Removing a Print Area

Formatting Numbers & Text

• Applying Number Styles & Decimal Places
• Character Formatting
• Rotating, Wrapping & Shrinking Text in a Cell
• Merging Cells & Changing Text Indent
• Text Alignment & Borders & Fill

Formatting Cells

• Changing Cell Alignment
• Creating Cell Borders
• Using the Fill Colour Button
• Using the Format Painter Button
• Inserting & Deleting Selected Cells

Working with Columns & Rows

• Inserting, Deleting, Adjusting, Hiding & Unhiding Rows & Columns

Using Automatic Formatting

• Cell Styles
• Themes

Action planning

Review of Programme

Related Courses

Excel 2007/2010: Level 2  Microsoft® Certified Application Specialist: Using Microsoft® Office Excel 2007/2010