Description
Boost your Excel confidence with our practical webinar—packed with everyday tips and tricks to help you master the fundamentals and work smarter.
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.
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 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
Please note a basic familiarity with Excel will be assumed. The demonstration will be given using Excel for Office 365. However, the version of Excel used in the webinar is of very limited importance as the points made extend to all versions.
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 will be equipped to write spreadsheets more quickly and more robustly.
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.
You might be interested exploring additional titles on similar and other topics presented by this speaker.
Write Better Excel 2025 – Tips for Total Beginners
PRESENTER
Richard Dams, BI Analyst
Richard worked in the City of London for 12 years trading in the fixed income derivative markets where he used Excel every day to make his trading decisions.
He now works in business intelligence creating informative dashboards in Power BI.