Write Better Excel 2023 – Charts and Sparklines - 15 August 2023 (On Demand)

Description

Excel spreadsheets can be an incredibly powerful tool. Many office-based roles provide dozens of opportunities to employ Excel to express obscure data by the appropriate use of charts.

For the many people who get thrown into the deep end by using Excel without formal training, this practical webinar aims to improve their knowledge of charts and sparklines.

This is the fourth part of 5 popular webinars in 2023 covering smart ways to efficiently use Microsoft Excel. This webinar will provide a deeper look into the most effective ways to create and edit charts to best represent various sets of data.

During the webinar we will run through brief illustrative examples to explain the content. The session will include:

  • Introduction
  • Case Study 1
  • Charts:
    • Appropriate chart choices
    • Using Excel’s in-built tools to create/edit charts quickly
    • Understanding the individual elements of a chart
    • Creating Templates
  • Case Study 1 - Answers
  • Case Study 2
  • Sparklines:
    • Using Excel’s in-built tools to create/edit sparklines quickly
    • Understanding scale on sparklines
  • Case Study 2 - Answers
  • Q&A

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

  • Tips for Total Beginners
  • The Fundamentals
  • Charts & Sparklines
  • Introduction to Macros

If you have missed a webinar, you may well find it available in our On Demand section.

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

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

ORIGINAL BROADCAST DATE

15 August 2023

LEARNING OUTCOMES

Attendees will gain knowledge how to produce charts and sparklines in Excel which are relevant to the data they are intending to explain. Once the content of this webinar is understood, attendees will be able to quickly select the right chart or sparkline to express some data and will be able to create it quickly.

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, BI Analyst/Consultant.

1.25 CPD Hours

  • On Demand Event
    • $195.00 excl. GST
    Complete online in your own time (Self-paced)
    • $195.00 excl. GST

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 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.