Microsoft Excel Advanced
Event summary
CIPFA has partnered with Filtered, a leading provider of personalised and intelligent learning to bring you Microsoft Excel Advanced.
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
Location
CIPFA E-Learning
Standard price
£35.00 excl VAT
Network Member Price
*the event has started.
About this event
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.
In this course, we build on the skills learned in the beginners' and intermediate Excel courses.
The course will help you:
- Learn to use the NEW Dynamic Array functions.
- Create advanced and flexible lookup formulas.
- Use statistical functions to rank data and calculate the MEDIAN and MODE.
- Produce accurate results when working with financial data using math functions.
- Create variables and functions with LET and LAMBDA.
- And 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.
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 advanced Excel programme will cost:
- £35 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.