Essential Formulas — SUM, AVERAGE, MIN, MAX, and COUNT

In this lesson, we will learn the most essential formulas and functions in Excel. We will understand how to calculate totals, averages, minimums, maximums, and counts using SUM, AVERAGE, MIN, MAX, and COUNT through practical examples. ## Lesson objective In this lesson, we will learn basic formulas and functions in Excel. In the previous lesson, we learned about cells, rows, columns, data entry, copy-paste, AutoFill, and data ranges. Now we move to one of the most important parts of Excel: formulas and functions. The main power of Excel is not only storing data, but also calculating results from that data.