Write Better Excel 2020 – The Fundamentals - 20 May 2020 (On Demand)

Description

Excel spreadsheets can be an incredibly powerful tool. Many office-based roles provide dozens of opportunities to employ Excel, whether to manage simple lists or to create complex models.

For the many people who get thrown into the deep end by using Excel before properly learning the basics, this practical webinar aims to improve their knowledge of the fundamentals.

This is the second part of 5 popular webinars in 2020 covering smart ways to efficiently use Microsoft Excel. This webinar will cover a wide variety of the most useful tips and tricks which come into use every day.

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

  • Introduction
  • Recap
    • Formula bar
    • Relative and Absolute referencing
  • The essence of Excel
  • Functions
    • Basics of equations
    • MAX, MIN, SUM, COUNT
    • NETWORKDAYS, IF, AND, SUMIF
  • An introduction to data tools
    • Sort
    • Filter
    • Conditional Formatting
  • An introduction to charts
  • Printing
  • 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
Handling Data
Charts & Sparklines
Introduction to Macros

Please note that this webinar (The Fundamentals) has some overlap with some of the other webinars in the series (webinars 1, 2 and 4) as it tries to cover the essentials of several topics.

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 webinar 1 before joining this webinar, however, basic 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 all versions.

ORIGINAL BROADCAST DATE

20 May 2020

LEARNING OUTCOMES

Attendees will gain knowledge of many key fundamentals that underpin all Excel spreadsheets and will be taught to use several incisive tools and functions. Once the content of this webinar is understood, attendees.

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, Director, PepTalks Online Limited

1.25 CPD Hours

  • On Demand Event
    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.