Interested in attending? Have a suggestion about running this course near you?
Register your interest now

Description

Excel spreadsheets can be an incredibly powerful tool for analysing data. Many office-based roles provide dozens of opportunities to employ Excel to make sense of muddled data, whether it be removing duplicates from disparate lists or creating powerful management reports from lengthy tables of numbers.

This practical webinar aims to help people who are familiar with Excel, but want to improve their knowledge around data handling.

This is the third part of 5 popular webinars in 2019 covering smart ways to efficiently use Microsoft Excel. This webinar will provide a deeper look into the most effective methods and tactics for handling large sets of data.

During the webinar we will run through brief illustrative examples of several of the tools, functions and techniques which can be used to manage unwieldy sets of data. The session will include:
• Introduction
• Variable names, range names and layout considerations
• A brief look at conditional formatting
• Flash fill
• Four major data tools:
o Sort
o Filter
o Find & Replace
o Duplicates
• Two useful functions for handling data:
o If
o Vlookup
• Pivot Tables (and why they are not perfect!)
• Charts
• Case Study
• Q&A

The 5 webinars in the Write Better Excel series 2019 (in the order presented and the order of difficulty) will be as follows:

Tips for Total Beginners (March)
The Fundamentals (May)
Handling Data (July)
Charts & Sparklines (Sept)
Introduction to Macros (Nov)

If you would like to view a recording from last year, before the 2019 live sessions run, you can find them in our On Demand section.

It is not required that attendees have attended webinars 1 and 2 before joining this webinar, however, some familiarity with Excel will be assumed.

Please note that the demonstration will be given using Excel 2013. However, the version of Excel used in the webinar itself is of very limited importance as the points made extend to all versions.

Coming Soon

  • Tue 08 Feb 10:30 AM NZDT
    Mandating Vaccinations for Employees – Legal Developments 2022
  • Tue 08 Feb 2:30 PM NZDT
    Leading a Team 2022
  • Wed 09 Feb 10:30 AM NZDT
    Trust Series 2022 - Trust Fundamentals
  • Wed 09 Feb 2:30 PM NZDT
    Year-End Tax Planning 2022
  • Thu 10 Feb 2:30 PM NZDT
    Tax Residence Update 2022
All Coming Soon >>

One-connection-one-fee

Our webinars operate on a 'one-connection-one-fee' basis so you can have your whole team participate for one cost effective price and claim CPD points.

Recordings

All registrants to a live webinar will automatically be sent a recording at the end of that week along with a full transcript of the webinar, regardless of whether you attended or not.

Sole practitioners

A discount on webinars is available for sole practitioners. Please contact us at NZ‑learning@wolterskluwer.com to confirm eligibility.