Level:
For intermediate levels

Audience:
Most suitable for Excel users who need to learn how to create formulas and functions in order to book into another Excel course.

Aim:
of this course is to provide students with an introduction to formulas, functions, the difference between these, and different types of cell addressing. This course or equivalent knowledge is a prerequisite for Excel – Core Knowledge.

Overview:

• Creating a formula
• Copying a formula across other cells
• Modifying an existing formula
• Understanding the difference between formula and functions
• Using the basic five functions (Sum, Average, Min, Max, Count)
• Understanding the difference between relative and absolute cell references
• Performing calculation with percentages

DOWNLOAD OVERVIEW