Key Training Logo

Microsoft Excel 2010: Level 1

Course Code: XL10L1

Duration: 1 Day

Aims:

This course is aimed at people who want to learn how to use Microsoft Excel 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:
▪ 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

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

Key Affiliations

 
Inspiring the future
European Union
Apprenticeships
ESFA
Matrix
REC Logo
5 Percent Club
RI Supplier Awards
Team Service Provider
Youth Employment UK
Ofsted
Investors in people
ARC
Best Company 2019
Skills for health Quality Mark
RI Top 500
AELP