Overview
This interactive webinar is ideal if you need to be able to create and work with styles, as well as use some of Excel’s data tools to help you manipulate worksheet data.
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)
We also recommend that you should either:
- Already be comfortable using basic formatting features in Excel, including formatting numbers, text, and ranges. Or
- Have previously attended the Microsoft Excel for Beginners – PC Users: Module 1 webinar
Topics covered
Working with Styles:
- Use Format Painter
- Clear formatting
- Understand styles
- Apply a cell style
- Create a custom cell style
- Modify and delete a style
- Copy a style from another workbook
Use the Outline Tools:
- Understand Outlining
- Create an automatic outline
- Create a manual outline
- Hide and display outline levels and symbols
- Remove an outline
- Create a Subtotal Report
- Remove subtotals
Manipulate Data:
- Freeze and split your window
- Create custom views
- Performa simple and complex sort
- Filter data using AutoFilter
- Remove AutoFilter
- Create custom filters
Date
Thursday 21 November, 9:30am – 12:30pm
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.
“I’d strongly recommend this training, Sue provided a comprehensive guide to Excel, plenty of training material and answered all questions thoroughly.”
Eugene Smith, Perry Parish 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.
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.