We start the course by showing you how to use reviewing and grouping tools, then move onto looking at ways to summarise and consolidate your data. You'll learn how to insert formula for budgeting and forecasting, and use tools to perform what-if analysis. We'll show you how managers can make use of the IF Function and conditional formatting, and how to produce charts. We'll look at ways of using Excel with other programs, then end the course by showing you how PivotTables can be used to produce managerial reports and charts.
How long does the course last?
5 hours approximately (all in 1 day, or over 5 hourly lessons).
When does the course take place?
The course can be arranged to fit in with your schedule (training sessions can be booked during the day and/or evenings, 7 days a week).
Are there any entry requirements?
Learners should have good existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate User course.
Are there any technical requirements?
You’ll need to have access to a Windows 10 PC/laptop with a reliable broadband connection. You’ll also need to have a webcam or a hands-free phone. Preferably you’ll have the latest version of Microsoft Office installed (if you do not have Microsoft Office we can still teach you).
How is the course taught?
Your EC-PC Tutor will remotely connect to your PC/laptop over the Internet. The tutor will work though each course topic and teach you on a 1-to-1 basis.
Will I receive course notes?
Yes, you’ll be able to download a PDF manual that you can use for future reference.
Will I receive a certificate?
Learners who complete the entire course will receive the following e-Certificate: EC-PC Microsoft Spreadsheets For Managers. The certificate may be used as evidence of CPD depending on the requirements of the learner’s profession.
I know some of the course topics, can you customise the course?
Yes, we can cover just the topics that you need to know over a shorter period of time.
What are the costs?
GBP £50 (per hour)
I’m a private individual, how do I make a booking/pay for the course?
For booking enquiries please e-mail firstname.lastname@example.org – payment can be made at the end of each session by bank transfer or by using PayPal (by debit/credit card). Please note that we have a 100% satisfaction guarantee – not happy, no fee!
I work for a company, how do I make a booking/pay for the course?
For booking enquiries please e-mail email@example.com – bookings made by UK companies can be confirmed by sending us a PO (invoices will be issued in accordance with our Terms & Conditions). For bookings made by companies outwith the UK please e-mail us for more details.