Key Training Logo

Microsoft Excel 2019/365 Level 1

Course Code: XL19L1

Duration: 1 Day

Course Aims:

This Microsoft Excel 2019/365 Level 1 course is aimed at people who want to learn how to use Microsoft Excel to carry out basic spreadsheet 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:

No previous knowledge of Excel is required. Students must have experience, however, of using the Windows environment to launch programs and access files.

Course Objectives:

On completion of this course delegates will be able to:
▪ Insert and Edit formulas and functions
▪ Copy and move data
▪ Insert and delete columns and rows
▪ Format numbers, text and dates
▪ Format cells
▪ Preview and print worksheets
▪ Use Page Setup to edit page margins, headers and footers
▪ Apply automatic cell formatting

 

Course Content:

Introduction and Objectives

Workbook Skills
▪ Selecting cells, entering & editing data
▪ Using data entry shortcuts (AutoComplete, Pick from List)
▪ The ‘Mini Toolbar’ and ‘Shortcut Menus’
▪ Saving and closing a new workbook
▪ Version compatibility issues
▪ Creating a new workbook
▪ Opening an existing workbook
▪ Renaming an existing workbook

Working with Ranges
▪ Selecting adjacent & non-adjacent ranges
▪ Entering values into a range (text, numbers,
dates)
▪ Using the AutoFill feature

Previewing Worksheets
▪ Using Print Preview, Page Layout View
▪ Viewing & hiding gridlines, headings and the Formula Bar
▪ Adding & removing page breaks

Printing
▪ Printing multiple copies
▪ Printing pages or a selection

Using Page Setup
▪ Page orientation
▪ Scaling a worksheet
▪ Editing margins
▪ Centring on page
▪ Headers & footers
▪ Repeating row & columns labels
▪ Setting & removing a print area
▪ Using Page Break Preview to adjust pages and
layout

Formatting Numbers & Text
▪ Applying number styles & controlling decimal
places
▪ Character formatting

Copying & Moving Data
▪ Copying/cutting & pasting data
▪ Using Paste Options
▪ Using the Paste List
▪ Using the Clipboard
▪ Drag & Drop editing
▪ Using Undo & Redo

Working with Columns & Rows
▪ Inserting, deleting & adjusting
▪ Hiding & un-hiding rows & columns

Creating Formulas and Functions

▪ How to start a formula using the equal sign
▪ How to create formulas using multiplication,
Division, Addition and Subtraction
▪ How to finish a formula
▪ How to edit formulas using the formula bar
▪ Using range borders to modify formulas
▪ How to create formulas where you can lock a
cell reference (Absolute cell reference)
▪ Entering Excel functions (e.g., Sum, Average,
Max, Min, Count and Counta)
▪ The Function Library (List of Functions)
▪ Using the Auto-Calculate feature
▪ How to search for formulas and functions in an existing spreadsheet

Formatting Cells
▪ Changing cell alignment
▪ Merging cells & changing text indent
▪ Rotating, wrapping & shrinking text in a cell
▪ Creating cell borders
▪ Using fills
▪ Using the Format Painter
▪ Inserting & deleting cells
▪ Clearing formatting

Using Automatic Formatting
▪ Cell styles
▪ Data Tables

Sharing Data
▪ Connecting and saving to SkyDrive
▪ Sending a workbook as an email attachment
▪ Creating PDF/XPS files
Appendix (if time)
▪ Selecting a ‘Recommended Chart’

Action planning

Review of Programme

Key Affiliations

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