Analyse and manage your data with key features in Excel 2016.
Overview
This webinar will take you through some key features in Excel 2016 which will help you analyse and manage your data.
Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Web scraping with the new incorporated Get and Transform menu
- Tools to forecast seasonally
- Making recorded changes to the dataset
- Learn to use formulas, IFS, CONCAT, TEXTJOIN, MAXIFS, MINIFS, with practical examples
- Charts: inbuilt Funnel chart, Waterfall chart and Pareto chart
As part of this webinar you will receive,
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step by step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.
Course updated: 2020
Objectives
- Familiarise yourself with Excel 2016
- Generate a seasonal forecast using Excel tools
- Edit data and ranges using six formulas available in Excel 2016 onwards
- Build three types of charts: Funnel, Waterfall and Pareto
Audience
Professionals working in SME or Corporate entities in specialist or analyst roles, and mid-level career roles working in job functions such as external reporting, financial control and management accounting.