Excel Western - Regional workshops 2018

Identifier: 83345209

Duration: 3.5 hours per session

Language: English

Cost:

Action

Overview

These half day workshops are designed for finance professionals to increase your skills in Excel at an intermediate and advanced level.

Intermediate Excel is aimed at helping you use Excel and gain a better understanding of your data, including how to and use and present your data. 

Key topics:

  • General spreadsheet guidelines and shortcuts
  • Data handling – Format as table, sorting and filtering techniques. Data validations and Custom Lists
  • PivotTables – an introduction to PivotTables
  • Functions – 3D SUM, SUMIF, SUBTOTAL, COUNTIF, IF, TRIM, LEN, LEFT, RIGHT, MID, SEARCH, IFERROR and VLOOKUP functions
  • Conditional formats – automatically adjust formats based on a cells content
  • Charts – charts to use and avoid. Before and after examples to improve your charts. What structures to use and guidelines on creating more readable charts. Sparkline charts – small cell-based charts

Advanced Excel and Dashboards in Excel covers advanced Excel techniques including how to complete dashboards in Excel.

Key topics:

  • Introduction to Power Query – automated data cleansing and combining
  • Excel Relationships – report on multiple tables with a single PivotTable
  • Advanced PivotTables techniques – perform calculations within your PivotTable
  • Advanced functions including INDEX, MATCH, SUMIFS, SUMPRODUCT, INDIRECT plus logic and text functions
  • Dashboard charting techniques - using sparklines, textboxes and creating small charts
  • Advanced Conditional Formatting techniques including using formulas

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.

Objectives

Audience

Course Structure

Title
Status
loading data
loading...