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