Creating a Work Tracker Excel: 2. Adding Functions & Analysis

22/04/2026

1:00 pm - 2:00 pm GMT

da-logo

Who is it for?

Users with basic skills in Microsoft Excel, who are interested in creating large workbooks, or who want to become more confident in using more advanced formula and tools.

What is the objective?

To use tools within Excel to analyse and assess data, including functions, conditional formatting and sparklines.

What will be covered?

  • Functions such as XLOOKUP, SUMIF and COUNTIF
  • Absolute vs relative references
  • Using tools such as conditional formatting and sparklines to provide quick visualisation of data

A Q&A session will be available at the end of the session, if you have any questions prior to the webinar you would like answering please email them via the form below and we will answer them during the live session.

Speakers

James

James Smith

Training Manager

I've been the Training Manager at Quiss for over 13 years, working with internal and external customers to create bespoke training, Microsoft Office automation and document template solutions.

I can help with:

  • Microsoft 365 App Solutions
  • Document templates
  • SharePoint development and training
Sabrina

Sabrina Griffin

IT Trainer

I joined Quiss in 2017 and run client training, as well as developing content for our Digital Academy Portal.

I can help with:

  • Developing short videos for user training on new applications
  • Integrating Microsoft Forms with Power Automate for streamlined workflows
  • Exploring the Quiss Digital Academy Portal

Got a question about this topic?

Let us know prior to our webinar and will do our best to ensure it's answered during the session

This field is hidden when viewing the form