Identifier: 83501522

Duration: 1 hour

Subscription Period: 365 Days

Language: English

Cost: NZD 66.37

 

Action

Add To Cart

Overview

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.

Objectives

Audience

Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.

loading...