Excel TutorialLesson 20Free preview

Excel Functions

This lesson is part of Excel · All levels

Summary

Functions are ready-made formulas that speed up calculations, for example SUM to sum and AVERAGE to average. The structure is always a function name followed by an argument containing a curve, such as =SUM(A1:A10). When confused about selecting a function, the Insert window (fx) provides a search along with a brief explanation of each function.

Key points

The structure of the function:
Sums up, averages count the mean, max and min look for extreme values
COUNT counting cells that contain numbers, COUNT counting cells that are not empty
Dialog Insert Function helps to find and arrange functions

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.