Writing Better Excel - Handling Data (On Demand)
76.png

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.

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
  • Four major data tools:
    • Sort
    • Filter
    • Find & Replace
    • Duplicates
  • Two useful functions for handling data:
    • Choose
    • Vlookup
  • Pivot Tables (and why they are not perfect!)
  • Charts
  • Case Study
  • Q&A

LEARNING OUTCOMES

Attendees will gain knowledge, by example, of many of the tools offered by Excel for managing data. They will also understand the application of several of those techniques in a small case study.

DATE OF ORIGINAL BROADCAST

25 July 2018

SUITED TO

Anyone who uses Excel and wants to improve their skills. Attendees should have some familiarity with excel prior to the session, but this session is not targeted at highly advanced users.

PRESENTER

Richard Dams, CCH NZ.

1 hour 15 mins

  • Elearning
    • $128.40 e-Learning 20% Discount - Apply Promotional Code: OEC20 $102.72incl. GST (7%)
    • PD hours: 1.25
    Complete online at your own pace (Self-paced)
    • $128.40 e-Learning 20% Discount - Apply Promotional Code: OEC20 $102.72incl. GST (7%)

Coming Soon

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 together in a boardroom setting for one cost effective price, using one registered log-in connection. The registered attendee will receive a CPD certificate.

Recordings

Like the topic but can’t make the time? Register for the Live Session and you’ll receive the Recording regardless! Recordings are provided for webinars with a duration of 3 hours and less.