Excel Fundamentals

Join us for a session on the fundamentals of Excel and learn the basics of an ever-present office tool

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 session aims to improve their knowledge of the fundamentals.

This session will cover smart ways to efficiently use Microsoft Excel and a wide variety of the most useful tips and tricks which come into use every day.

During the session we will run through brief illustrative examples to explain the content, including:

• Introduction
• Essentials

• 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 charts
• Printing
• Q&A

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 session itself is of very limited importance as the points made extend to all versions.

We are also running another session to follow on from this – Excel – Handling Data 

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 session 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.

This On Demand recording Includes: 

• Recording of the Live Webinar, which can be viewed multiple times, for as long as required 
• Presenters contact details for follow up questions 
• CPD Quiz
• CPD Certificate 
• CPD Report – Logged automatically 
• PowerPoint Presentation
• Verbatim Transcript, with Searchability
• Supporting Documentation