1.25 CPD hours
May 31Wed 10:30 AM NZST - Wed 11:45 AM NZST Online
- $180.00 excl. GST
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 2017 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:
- Formula bar
- Relative and Absolute referencing
- The essence of Excel
- Basics of equations
- MAX, MIN, SUM, COUNT
- NETWORKDAYS, IF, AND, SUMIF
- An introduction to data tools
- Conditional Formatting
- An introduction to charts
It is not required that attendees have attended webinar 1 before joining this webinar, however, basic familiarity with Excel will be assumed. To learn more about the topics covered in the rest of this series, please follow these links:
To browse webinar 1 click here (Tips for Total Beginners) (On Demand)
To browse webinar 3 click here (Handling Data)
To browse webinar 4 click here (Charts & Sparklines)
To browse webinar 5 click here (Introduction to Macros)
Please note that the demonstration will be given using Excel 2013. However, the version of Excel used in the webinar itself is of very limited importance as the points made extend to all versions.
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 will be equipped to write spreadsheets more quickly and more robustly.
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.
Richard Dams, Webinar Manager, CCH Learning