Microsoft Excel Introduction

A one day training programme

This one-day Microsoft Excel Introduction training programme, available to be split over two half-days, is designed to give a basic understanding of how to create, edit, print and calculate within Microsoft Excel.

By the end of the course you will be able to carry out the following functions:

  • create a basic WorkSheet
  • enter calculations using various methods
  • change the format and layout of the WorkSheet
  • set up WorkSheet protection
  • print a WorkSheet, changing layout and headers and footers
  • create a basic chart

The course style is relaxed, informative and interesting, including lots of practice exercises that are easy to follow.

Course Content

The following topics are covered over the course of the programme:

  • The Basics

    • Understanding and moving through the WorkSheet
    • Using Flash Fill
    • Understanding the ribbon of tools
    • Customising the quick start bar
    • Using the formula bar

  • Formatting and Layout

    • Formatting a WorkSheet
    • Formatting numbers
    • Repeating a format
    • Adding borders and shading
    • Using auto formats and cell styles

  • Charts

    • Adding data to a graph
    • Selecting and amending chart items
    • Adding an arrow and adding text
    • Changing the chart type
    • Creating a chart using the chart wizard

  • Printing a WorkSheet

    • Creating a Header & Footer
    • Setting printing title
    • Freezing panes

  • Creating Calculations

    • Create series of data
    • Sum/Average/Min/Max
    • Using the AutoSum tool
    • Absolute cell addressing
    • Using quick analysis tools
a person is sitting at a table with a laptop and a calculator

Who is it for?

All staff

Duration

One day

Open Courses

27th & 28th January 2027, 9.30am - 1pm

20th & 21st April 2027, 9.30am - 1pm

£195 + VAT per person

Get in touch to talk about arranging an in-organisation Microsoft Excel Introduction training course

Share this course

Testimonials

The trainer was excellent, ensuring the pace was tailored to the ability of the group. She was knowledgeable about the topic and was patient with our questions. Great introduction.

Delegate

The trainer was a great teacher. I learnt many new things and shortcuts that you can use in Excel that I was not aware of before. I will continue to apply them to my work going forward.

Delegate

Other courses to check out

Related Courses