Description
COURSE OBJECTIVE:
This online Excel course is designed for anyone who wants to build
confidence in creating and using formulas.
Participants will learn how to perform basic calculations, understand
the difference between relative and absolute cell references, and use
common functions such as SUM, AVERAGE, MIN, and MAX to analyse data
efficiently.
The course also covers how to calculate percentages, helping users
develop the essential skills needed to work accurately and effectively
with spreadsheets.
COURSE FORMAT:
The course involves explanation, demonstration and hands-on practice,
working through exercises that build on your existing skills and
increase the functionality of spreadsheet formulae.
PREREQUISITES:
To get the most from this course, participants should be comfortable
using a computer and have a basic understanding of Microsoft Excel, such
as opening, saving and navigating between worksheets. No prior
experience of creating formulas is required, making this an ideal course
for beginners who want to develop their spreadsheet skills and gain
confidence working with calculations and functions.
CONTENT
• Basic Calculations (add, subtract, multiply & divide)
• Using static values and cell references in formula
• Absolute v Relative referencing
• Common Functions (SUM, AVERAGE, MIN, MAX)
• Calculating Percentages
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
