Using example retailer EPOS you will learn the most relevant Excel skills for your role which will enable you to work much more quickly and accurately. You will recognise the data and be familiar working with it. This ensures that whatever you learn is relevant and you know how to apply it once you get back to your desk.
We will start with keyboard shortcuts to make you a much more efficient Excel user before moving onto some time saving techniques that will eliminate those painfully, long winded, repetitive tasks, saving you hours every month.
After that we’ll master the VLOOKUP formula before getting to grips with Pivot Tables. The combination of these two tools will revolutionise the way you work and you’ll wonder how you ever coped without them.
The courses will be held on:
Wednesday 7th October at the DoubleTree by Hilton Hotel in Leeds
Thursday 8th October at the de Vere Venues Wokefield Park Hotel near Reading.
The DoubleTree hotel is only a 7 minute walk from Leeds Railway Station or parking is available for £7.50. Wokefield Park is 3.5 miles from Junction 11 of the M4. With free parking or a 7 mile taxi ride from Reading station it’s an easily accessible location.
Training will run from 9:30am until 5:00pm with lunch included. You’ll need to bring your laptop with you but all the training files and resources you need will be provided on the day along with a comprehensive set of notes to take away.
The course costs £300 + VAT (£360 all inclusive)
Agenda Highlights:
Control & Shift Shortcuts – do you watch people zooming around their spreadsheets ridiculously quickly without ever touching their mouse and wonder ‘how do they do that’?
Separating and combining data – can you think of an instance where you’ve needed to extract a product code or a pack size from a full description? Learn how to do this in seconds and then how to combine it all back together again
Sort & Filter – how to get the most out of these familiar functions….you don’t need to tick and untick all those boxes
Better use of formulas – understand what it means to put a $ in your formulas – how do they work and why use them
Auto filter – no more dragging and scrolling through huge spreadsheets to copy formulas
VLOOKUP – the most important formula you’ll use and you’ll wonder how you ever managed without it
Pivot Tables – what they are, why you should use them and how to use them
Formatting – so much time can be lost trying to format a spreadsheet in a particular way, I will share some tips to make this a lot quicker, you’ll also learn how to save chart templates so that you don’t have to recreate your favourite each time
This is your chance to ask questions you might think are stupid without your colleagues listening. It will be a small group to allow maximum interaction between us with plenty of time to practice.
“The course was exactly what I was looking for, well structured, concise and relevant. What separates the Franklin John course from the rest is that it’s based on what you need to manage your business and the benefits are immediate. I would highly recommend this course to anyone who wants to improve individual or team efficiency”
Warwick Elliot – National Account Manager, Wessanen
