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
Monday 7 July, 10:00 – 13:00
Price
Members: £120 + VAT
Non-Members: £140 + VAT
CPD points
Claim 1 CPD point for attending!
Accessing your joining link
You can now login to your SLCC portal to access training materials, including joining information, certificates, recordings, and presentations—all in one place.
We will no longer send joining instructions via email. Instead, we invite all delegates to log into their SLCC account, ‘Training & Events’ section, to access their joining link.
“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
“This course has given me so much more confidence when using Excel, I made do before and fluffed my way through it but now have the skills to take it to the next level.”
Rebecca Duffus, Sheerness Town Council
About the Trainer
Lynne began training in 1987 as a Commercial Skills Instructor, initially delivering a range of courses in typing, shorthand, office practice and word processing enabling young adults and adults returning to work to achieve various Royal Society of Arts (RSA) qualifications.
Since 1990 Lynne has dedicated her career to delivering a variety of end-user software applications from both Adobe and Microsoft. Specialising in documentation, she has delivered training around the world both face-to-face and in the past two years, online via zoom and teams.
She has been involved in many projects and rollouts in both the public and private sectors, designing and delivering both scheduled and bespoke courses and one-to-one coaching sessions. She has also created accompanying course materials.
Lynne studied part-time to achieve a BA (Hons) 2:1 in Educational Practice at Oxford Brookes University, graduating in 2009.
Her strengths combine organisation, planning, communication and being able to work well in a team or unsupervised. She always tries to make her training sessions relevant, interactive, and fun. She is very enthusiastic and always encourages people to learn and in doing so, to take an active part in 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.
