Writing Better Excel – The Fundamentals (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.

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

  • Introduction
  • Orientation, glossary, sources of help
  • Four vital concepts:
    • Relative and absolute cell referencing
    • Number and date formats
    • Copy versus cut
    • Adding and removing rows & columns
  • A brief introduction to functions
  • Case study
  • Q&A

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

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

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 2010. However, the version of Excel used in the webinar itself is of very limited importance as the points made extend to all versions.

LEARNING OUTCOMES

Attendees will gain knowledge of the key fundamentals that underpin all Excel spreadsheets. Once the content of this webinar is understood, attendees will be equipped to write more robust Excel and understand common pitfalls.

ORIGINAL BROADCAST DATE

8 May 2019

SUITED TO

Anyone who uses Excel and wants to improve their skills. Attendees should have a light familiarity with excel prior to the session. This session may also suit practice managers and administration staff.

PRESENTER

Richard Dams, Software Developer and Webinar Manager, Wolters Kluwer

1 hour 15 minutes

  • Elearning
    • PD hours: 1.25
    Complete online at your own pace (Self-paced)
    • $128.40 incl. 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.