Overview
These half day workshops are designed for finance professionals to increase your skills in Excel at an advanced level.
Advanced Excel covers advanced Excel topics and techniques.
Key topics:
- Summing functions that can handle complex conditions SUMIFS and SUMPRODUCT
- Logic functions that enable you to build complex decision-making capabilities into your files IF, AND OR, IFS
- Text functions including new functions in Excel 2016
- Error handling functions IFERROR and IFNA
- Lookup functions INDEX and MATCH
- Chart formatting and design tips
- Creating charts that auto update
- New charts in Excel 2016 – Pareto and Waterfall
- How to create a High Low chart plus a Variance chart
- Introduction to Power Query (Get & Transform Data ribbon) – Data cleansing & importation
- Advanced PivotTables – grouping and additional calculation options, how to use the Show Values As options
- Using Slicers and Timelines for an easier and more comprehensive filtering interface
- How to create Relationships between tables
Excel 2016 Dashboards covers the techniques you need to create dashboard reports in Excel.
Key topics:
- General visualisation guidelines for dashboards
- Excel's chart interface and shortcuts
- The best structures to use with charts
- The functions you need to master to extract chart data
- How to perfectly line up and re-size charts
- The charts to avoid and the ones to use
- Hacks to add functionality to charts
- Tips to reduce clutter
- How to use textboxes with dashboards
- Sparkline charts
- Conditional formatting techniques for dashboards
- How to use bullet charts as a replacement for gauge charts
- How to use PivotTables and PivotCharts in Dashboard
Click on the here for Neale Blackwood’s biography.
This workshop is offered in Excel 2016 with some compatibility with Excel 2010 and 2013.
Please note you will need access to Power Query to participate in this workshop.
You will need to bring your own laptop.
Please enrol at least 3 working days prior to the workshop to ensure any dietary and special requirements can be accommodated.
Looking for a customised learning solution for your organisation or team? Contact us today to discuss in-house learning options.