Getting To Grips With Excel Course

This 2-hour standalone workshop is designed for individuals with limited Excel experience. In this online session, a teacher will guide you through examples tailored to a healthcare setting. You will learn about:

Entering & editing data Shortcuts & tips to increase productivity Introduction to Excel functions How to use SUM, MIN, MAX, AVERAGE, COUNT & COUNTA Using functions to analyse data.

Working with large spreadsheets Filtering data, Using Freeze Panes, Hiding columns and rows Using absolute cell references Copying formulas, Linking formulas across worksheets Conditional formatting.

Creating custom rules, highlighting cell colours, exploring functions like SUMIF for data analysis, and gaining an introduction to Excel charts and graphs.