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.
1 day (5 to 6 hours approx).
Learners should have experience using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate User course.
Learners will receive user-friendly course notes for future reference.
The course is delivered using Microsoft Excel Office 365. We can provide training using other versions of Microsoft Excel on request.
Learners who complete the course will receive the following e-Certificate: EC-PC Microsoft Excel Spreadsheets For Managers. The certificate may be used as evidence of CPD depending on the requirements of the learner’s profession.
Learners will receive 12 month’s complimentary membership to the EC-PC Learning Club.
The course can be delivered at locations throughout the UK including: Aberdeen, Dundee, Edinburgh, Glasgow, Inverness, Perth, Stirling, Birmingham, London, Manchester, Reading, Slough.
Please contact us for a quote.