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 on to some time saving techniques that will eliminate those painfully, long winded, repetitive tasks, saving you hours every month.
After that we’ll master the XLOOKUP 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:
Tuesday 10th December at The Headrow Suite, 32 Park Cross Street in Leeds
Tuesday 17th December at Perch Co-Working in Bicester, half a mile from Bicester Village station
Training will run from 9:30am until 4:30pm 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 £450 + VAT. Payment can be made with a card online or via an invoice to your company.
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
XLOOKUP – 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
“Really laid back approach throughout the day, which made you feel at ease. Emily was extremely helpful and very quick to send out notes from the training. Really enjoyed the whole day, thank you. 5* from Emily”
National Account Manager, Jack Links
