Overview

This interactive webinar is ideal for those in smaller Councils who want to learn how to work with information in Excel and manage worksheets and workbooks.

There will be opportunities and time within the webinar for participation, undertaking exercises, questions and answers, to ensure you get the most from the training.

Please note that this webinar is not intended for Apple Mac users.

If you would be interested in the SLCC arranging webinar tailored specifically for using Excel on Macs, please get in touch: [email protected]

Important Prerequisites

To book and attend this training, you will need to have:

  • A Microsoft Windows computer / laptop that you are familiar with using
  • Microsoft Excel 2016 or newer installed (this includes Excel 365)

 

Topics covered

Enter & Change Information:

  • Select cells & ranges
  • Enter and change information
  • Types of information you can enter
  • Understand AutoComplete
  • Pick from a list of entries
  • Use AutoFill & FlashFill
  • Find and replace information
  • Hide data

 

Manage Worksheets:

  • Change the view of your workbook
  • Move around a worksheet
  • Move to a different sheet
  • Rename a sheet
  • Insert and delete a sheet
  • Copy and move a sheet
  • Change the colour of sheet tabs
  • Insert and delete rows and columns

 

 

Format Worksheets:

  • Format numbers and text in cells
  • Change column width and row height
  • Control the alignment of text
  • Indent text in cells
  • Change the orientation of text in cells
  • Centre text across cells
  • Add borders and colour to a range
  • Copy and clear formatting

 

Prepare and Print Workbooks:

  • Set up the page and margins
  • Set headers, footers, and sheet options
  • Preview and print
  • Print titles

Date

Thursday 8 February, 10:00am – 1:00pm

Price

Members: £120 + VAT
Non-Members: £140 + VAT

CPD points

Claim 1 CPD point for attending!

Joining instructions will be sent to you 3 weeks before the event (please check your spam inbox) and your invoice will be sent before the event. We advise that, on receipt of the joining instructions, you are liable for any fees incurred in order to attend the event.

This was an excellent course, just right for a beginner or someone looking to renew their skills. The trainer was very good and explained everything so well, would thoroughly recommend.”
Angela Howells, Westerham Town Council

About the Trainer

Sue Richardson

Sue has been in the IT industry since 1980 and is highly experienced in defining and delivering IT End-User applications in both the public and private sectors. She has an Online Learning Facilitator certification which has enabled her to provide virtual training to various clients around the world. She also works with both classroom-based instruction and 1-2-1 coaching as well as providing assistance at the desk and floor walking.

Sue is often the Lead Trainer on projects and/or rollouts, which involves developing customised training solutions for bespoke systems and defining tailored training sessions.

She always tries to make her training sessions interactive and fun, is very enthusiastic, and always wants to encourage people to learn and get the most out her the sessions she delivers.

Microsoft Excel webinar trainer - Sue Richardson

Wrong time? Wrong place?

SLCC is always keen to respond to members’ needs for training. If you would like to register an interest in having a particular course delivered via webinar or in your region, please let us know.

Express an interest in an SLCC course or webinar