Description
COURSE OBJECTIVE:
This course will furnish you with the skills to build formula using the
built in functions and explores how you can use the formula auditing
tools to help you identify errors in your formula. This course is the
first in the series of formula courses.
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:
As the course involves creating calculations, participants should posses
basic skills in Excel. This course is not suitable for complete
beginners in Excel.
CONTENT
• Basic Calculations
• Absolute v Relative referencing
• Common Functions (SUM, AVERAGE, MIN, MAX)
• Calculating Percentages
• Use the Formula Auditing Tools
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
