Aims

This course is designed for those delegates who wish to acquire the basic skills to use Excel effectively. It would benefit anyone wishing to learn the basics of creating spreadsheets.

Objectives

On completion of this course, attendees will be able to create a spreadsheet, format text and numbers, perform basic calculations and present data in a graphical format.

Prerequisites

Attendees do not need any previous experience of Excel but must have a basic understanding of PCs, including familiarity with a keyboard and mouse.

Versions

Courses are delivered in 2010, 2013, 2016, 2019 & O365

What will I learn?

The Excel Screen

  • Spreadsheet terminology explained
  • Navigate the Excel environment
  • How to get help

Create Basic Spreadsheets

  • Enter and edit text, numbers and dates
  • Delete and clear data and formats
  • Different methods of selecting cells
  • Change column widths and row heights
  • AutoFill and custom lists
  • Use cut, copy and paste

Work with Flash Fill

  • Allow Excel to complete data entry for you
  • Change Case
  • Split data into columns

Format a Spreadsheet

  • Apply different formatting to text
  • Apply different number formats
  • Apply borders and shading
  • Merge cells and wrap text
  • Insert and delete rows and columns
  • Hide and unhide rows and columns

Create Basic Formulae

  • Create basic calculations (add, subtract, multiply and divide)
  • Understand the use of brackets () within formulas
  • Copy formulae
  • Relative and Absolute Cell References

Introduction to Functions

  • The AutoSum Function
  • The Max, Min, Average & Count Functions

Worksheet Views and Print Settings

  • Workbook views
  • Page Set-up options
  • Print worksheets/workbooks

Manage Worksheets

  • Insert and delete worksheets
  • Copy and move worksheets
  • Rename worksheets
  • Reorder worksheets
  • Apply Tab Colour

Work with Larger Spreadsheets

  • Use the zoom control
  • Apply Freeze Panes
  • Sort and Filter a list
  • Print Titles
  • Set Print Areas/Print Selection

Comments

  • Insert and edit Comments
  • View and print Comments

Introduction to Charts

  • Create a chart such as Pie, Column or Line
  • Print Charts

How we deliver

Training can be delivered at your offices in either of the following ways:

  • Online

    Online training is ideal if you have staff in different geographical locations who have the same Microsoft or Adobe training requirements.

    Our expert trainers can deliver Watch and Learn sessions to up to 100 people. Alternatively, they can produce an interactive session that allows delegates to complete practical exercises within the Microsoft or Adobe apps of your choosing.

  • Face to face

    Choose from one or half day training sessions or our popular 90-minute Sprint sessions, which can be delivered in your offices or at another location of your choice.

    All we need is a room with a table and chairs and we look after the rest. We can even provide laptops and a projector should you not have spare IT equipment to use.

Sprint learning

Short on time, but still want to boost staff performance?
Book a Sprint Session!

Each Sprint Session follows a 90-minute format for ultra-focused team learning.

Pick a topic, tell us what you want to achieve from your session, and we’ll put together a short, fun, entirely bespoke programme that meets the needs of your team.

Designed to cater for 10-15 delegates at a time

Developed by our team to cover the subject matter of your choice

Delivered online or face-to-face

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)