Overview

Functions and formulas are the heart of Excel, enabling you to perform calculations, manipulate data, and automate tasks. There are five functions that are the most common when it comes to using Excel, and these are SUM, AVERAGE, MIN, MAX and COUNT.

In this course, we'll tackle these functions, and learn how to use absolute cell references when you need a certain cell to remain constant. This short, 30-minute course will help you get to grips with Excel effectively and efficiently.  

Learning Outcomes

• Understand how to use the five most common functions, SUM, AVERAGE, MIN, MAX, and COUNT to construct some basic formulas.
• Practice using Absolute and Mixed references in formulas to lock columns and rows when copying a formula.

Audience

Anyone looking to explore the basics of Excel.