Microsoft Excel Introduction

New to Excel and not sure how to use features such as entering data, sorting and filtering, create a simple calculation, or how to print a worksheet?

Our one-day beginner Excel courses are specifically designed to get you using Excel with confidence. Explore the important tools for use in Excel.

Gain practical skills from our experienced trainers with plenty of real-world examples. Experience one on one training or have colleagues join you in a private training session.

Who Is This Course For?

This beginner Excel course is suited to those who have little to no experience in using Microsoft Excel but want to learn how to navigate and use Excel with confidence.

Course Description

Our beginner Excel course is part of a 3-level study program. This course aims to give participants a thorough understanding of the basics of creating and working with spreadsheets using Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting.

Learning Outcomes

At the completion of Microsoft Excel Introduction you should be able to:

• navigate your way around Microsoft Excel

• open and navigate within workbooks and worksheets

• understand and work with ranges in a worksheet

• use the fill operations available to fill a data series

• understand, create and work with formulas and functions

• understand and use formula cell referencing

• understand and use the number formatting features in Excel

• sort data in a list in a worksheet

• filter data in a table

• print your workbook data

• create effective charts in Microsoft Excel

Prerequisites

Our beginner Excel course assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.

Course Overview

Getting to know Excel

• The Excel Workbook Screen

• Using the Ribbon

• Access Backstage View

• Use Shortcut Menus

• Use the Quick Access Toolbar

Create a new workbook

• Entering Text, Numbers and Dates

• Saving a New Workbook

• Check Spelling

Work with workbooks

• Open an existing workbook

• Navigate a workbook

• Navigate using the keyboard

• Using Go To

• View Recent Files and Folders

Edit a workbook

• Overwrite Cell Contents

• Edit Longer Cells

• Edit Formulas

• Clear cell contents

• Delete Data

• Use Undo and Redo

Select ranges

• Select Adjacent Ranges

• Select Non-Adjacent Ranges

• Select Larger Ranges

• Select Rows

• Select Columns

Copy Data

• Use AutoFill for Quick Copying

• Copy from One Cell to Another

• Copy from One Cell to a Range

• Copy from One Range to Another

Fill Data

• Fill a Data Series

• Filling a Growth Series

• Extract data using Flash Fill

Formula and Functions

• Create Basic Arithmetic Formulas

• Use the SUM Function

• Sum Non-Adjacent Ranges

• Calculate an Average

• Find a Maximum & Minimum Value

• Create More Complex Formulas

Cell Referencing

• Use Relative cell refences in formulas

• Identify issues with Relative formulas

• Create Absolute cell references

Font Formatting

• Apply fonts and font size

• Use various formatting techniques

• Customise colours

• Use Format Painter

Number Formatting

• Apply General Number Formats

• Format Currency and Percentages

• Format Dates

• Increase and decrease decimal places

Sort Data

• Perform alphabetical data sorts

• Perform number based data sorts

• Sort by more than one column

Filter Data

• Apply and use a filter

• Clear a filter

• Apply filters on multiple values

• Filter by colour

• Create custom filters

Printing

• Use Print Preview

• Print a specific range of data

• Print an entire worksheet

• Use Print Options

Create Charts

• Create a new chart

• Edit chart elements

• Customise chart options

Course Inclusions

Skills Analysis

Take advantage of our free online skills analysis prior to your training to ensure have are undertaking the correct course.

Certificate

After completing the course you’ll receive a certificate to show off your new-found knowledge and skills.

We Come To You

To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.

Hands-on Training

We’re big believers in hands-on learning so you’ll be on a computer and building your skills in real-time.

Email Support

Access unlimited support following your training course to build on your learning and ask any burning questions.

Real-world Examples

You'll work through real-world examples to reinforce learning and increase your confidence.