Excel Skills Workshop Series – Full Series

Description

Presented by First for Knowledge on behalf of API, this workshop series will consist of 3 hours filled with techniques and tips to increase your confidence and knowledge in Excel.

These workshops were held on 1 October, 21 October and 12 November 2020.

Want to register for individual workshops instead?

• Please click here to register for Workshop 1 only
• Please click here to register for Workshop 2 only
• Please click here to register for Workshop 3 only

Workshop 1

Are you a regular Excel user who is self-taught or has not had formal training in recent versions of Excel?

This workshop with help you achieve more, faster and easier. Effective, well presented Excel spreadsheets will enhance your credibility and impress your clients. Register now to catch up and brush up your skills in Excel and work smarter not harder.

What you will learn

• Pros and cons of working in different Excel environments
• Best practices for setting up Excel spreadsheets
• Creating effective formulas using cell referencing
• Working with multiple sheets
• Use Flash fill to merge or separate data

Workshop 2

Data is readily available; in fact, we’re often inundated with it. But data is meaningless unless we can interpret that data and communicate the message persuasively and confidently.

This workshop with help you tame large amounts of data so you can analyse the information and then communicate your findings with clarity and impact. Register now to increase your data analysis and presentation skills.

What you will learn

• Sorting and filtering data for analysis
• Using Conditional Formatting
• Creating Data Tables
• Getting started with Pivot Tables and Pivot Charts
• Creating charts including line, column, pie and combo

Workshop 3

Are you a ready to move beyond basic formulas and functions? Learn to create user proof spreadsheets for financial modelling.

This workshop with extend your skills and build your confidence in working with calculations. Building on basic skills you will learn techniques to create sophisticated spreadsheets. Register now to master essential skills for financial modelling.

What you will learn

• Creating and working with named ranges
• Setting up Data Validation
• Creating financial functions (PV, FV, PMT)
• Creating logical functions (IF)
• Creating a lookup functions (VLOOKUP)

What you will get for each episode

• Opportunity for hands on practice
• Exercise files for during and post-workshop practice
• Keyboard shortcuts
• Reference guide

Requirements

• Windows based PC or laptop
• Microsoft Excel
• Browser – we recommend Google Chrome
• Optional – Dual monitors – If available

Pre-Requisites

Basic computer literacy (ability to create, name, save, open and close files).