Workshop - Microsoft Excel, Wellington

Microsoft Excel is a common tool used by many to better understand and analyse data. This workshop will show you how to take raw data, clean and prepare it, then manipulate and analyse it to create useful information.

Workshop details

This workshop will cover the following:

  • Formulas vs functions
  • Absolute referencing and naming ranges
  • Navigating around large spreadsheets
  • Find and Replace
  • Flash Fill
  • Keyboard navigation
  • Filtering and Sorting
  • Conditional Formatting
  • Data cleansing using formulas and functions
  • Freeze Rows
  • Tables – Creating, Formatting, and Using
  • Pivot Tables
  • Pivot Charts
  • You will get the opportunity to consolidate your learning through practical exercises.

Audience

Excellent for people familiar with Excel and want to take it to an intermediate/advanced level.

What you will need

You will need to bring your own laptop with Excel 2019/Office 365. Earlier versions of Excel will be OK but may not have all the features shown.

Cost

Costs for the workshop are:

  • Members: $320.00 plus GST
  • Student members: $220.00 plus GST
  • Non-members: $475.00 plus GST.

Note: Members = members of TechCommNZ and affiliated organisations: NZATD, ASTC. Cost covers tea/coffee, a light lunch and course materials.

Please read our payment terms and conditions.

Session details

Wellington

Thursday 27 June 2019 Time: 9:00am - 4:30pm Tea and coffee will be served on arrival from 8:30am.

Location: Meetings on the Terrace, 152 The Terrrace Wellington ( location map )

Please review the map or directions to the venue you will be visiting. You might find it useful to print them out for reference on the day of the workshop.

About the presenter

Peter studied zoology at university and has taught science and biology at secondary school level. His current role is "Manager of Computing for Free" at Ara Institute of Canterbury (formerly CPIT). In 2001, while doing part-time study in ICT, he worked as a full-time facilitator. This involved helping students to learn, understand and problem solve mostly Microsoft office products (Word, Excel, Access, PowerPoint, and Publisher) and HTML and Photoshop too.

In his current role he manages 20-25 staff in Christchurch, Ashburton,Timaru and Oamaru at Ara community computing sites. He also looks after a team of three tutors in the Youth Transitions team (teaching digital technology to school students), a Digital Boost team (business training in Microsoft Office products) and supports their Head of Department in managing the operations of the department. He admits that he loves technology and gadgets and likes to keep up with latest in apps, tools and toys!

Event Registration