Write Better Excel 2024 – Tips for Total Beginners - 8 February 2024 (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 from the very beginning.

This is the first part of 5 popular webinars in 2024 covering smart ways to efficiently use Microsoft Excel. This session will cover the first steps to understanding many of the key areas of Excel which regularly pop up as issues in understanding small spreadsheets.

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

  • Introduction
  • Orientation
  • Case Study
  • Entering data & selecting cells
  • An introduction to equations & functions
    • The vital concepts:
    • Relative and absolute cell referencing
    • Copy versus cut
    • Adding and removing rows & columns
  • Printing
  • Getting help
  • Q&A

This webinar will not teach attendees to blindly click on functions and hope for the best, but will arm them to understand what is happening within their spreadsheets at a more fundamental level. An understanding of some general Microsoft Office products (e.g. Word documents) will be an advantage.

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

If you have missed a webinar, you may well find it available in our On Demand section.
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

8 February 2024

LEARNING OUTCOMES

Attendees will gain knowledge of many key fundamentals that underpin all Excel spreadsheets. Once the content of this webinar is understood, attendees will be better equipped to understand spreadsheets they are given and be able to start to write their own spreadsheets, while understanding common pitfalls.

SUITED TO

Anyone wanting to begin understanding Excel. The session will also suit administrative staff required to handle simple spreadsheets.

PRESENTER

Richard Dams, BI Analyst.

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.