What is new to analysing and managing data, and what you are missing out on by not having the latest iteration of MS Excel? This webinar will take you through some of the new features in Excel which will help you analyse and manage your data.
Key topics:
-
Web scraping with the new incorporated Get and Transform menu.
-
Explore some of the new forecasting tools which allow for seasonality.
-
Making recorded changes to the dataset so when the data is updated if flies into our file.
-
New Excel formulas IFS, CONCAT, TEXTJOIN, MAXIFS, MINIFS with some practical examples.
-
New Charting features – an inbuilt Funnel chart, waterfall chart and Pareto chart.
