A complete Microsoft Excel course comprising of 4 modules to take you from a beginner to an advanced user!
About the training
Microsoft Excel is the world's most popular spreadsheet software. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information in a myriad of ways.
This complete online Excel package will take your skills from beginner to advanced with the addition of a 2.5 hour data analysis module.
The course will help you:
- Design better spreadsheets and control user input.
- Use logical functions to make better business decisions.
- Construct functional and flexible lookup formulas.
- Use Excel tables to structure data and make it easy to update.
- Extract unique values from a list.
- And much more.
Most of us can use Excel to some degree but there is always more to learn. This programme, developed by Filtered, a leading provider of personalised and intelligent learning, is designed to take your Excel abilities to the next level.
How is the programme taught?
The course comprises of 4 modules, with individual video lessons and exercises. It includes downloadable course files and exercise files, so you can follow along with the instructor and then practice what you have learned at the end of each section.
It is accessible via any internet-enabled device and enables you to progress through the topic areas at your own pace.
Who is it for?
If you have some Excel experience, then this course is the perfect for you. Perhaps you have some basic Excel knowledge, and you want to upgrade from an older version of Excel or sharpen your skills. Well, this training will get you up to speed.
It will be particularly useful to finance managers, those with budgetary responsibilities and students.
Learning outcomes
This course will teach you how to use intermediate-level formulas such as IF, VLOOKUP, INDEX MATCH, and OFFSET. You'll also learn to clean and analyse data using PivotTables and Pivot Charts, control data input with validation rules, make decisions with "WhatIf" analysis tools, and learn the golden rules of spreadsheet design.
You will be able to apply these skills to your work to deliver more in-depth analyses and become more efficient in your spreadsheet use.
Through a dashboard, you will be able to monitor your progress and have the opportunity to address any areas of Excel that have caused frustration in the past.
Pre-requisites
You will need a PC or Mac with a full version of Microsoft Excel (any version from 2003 to 2013 or Microsoft 365).
Price
A 12-month subscription to the Microsoft Excel programme will cost:
- £99 for non-CIPFA members.
- FREE for all CIPFA members (including CPFA members, Affiliate and Associate members, student members and Fellows) – To make your purchase please contact customerservices@cipfa.org.