Course Content
Excel Essentials
Excel Essentials
Common Functions
Excel functions are the secret sauce that turns a simple spreadsheet into a powerful data analysis tool.
This chapter will introduce you to some of the most common and versatile functions: SUM
, AVERAGE
, MIN
, MAX
, and COUNT
.
We'll also explore how to use the AutoSum feature, combine functions for complex calculations, and handle error checking in formulas.
Key Points
- The
SUM
function add up a range of numbers, perfect for calculating totals; - The
AVERAGE
function finds the average value in a range, ignoring empty cells and text; - The
MAX
function identifies the largest number in a range; - The
MIN
function finds the smallest number in a range; - The
COUNT
function tallies the number of cells that contain numbers in a range; - AutoSum quickly adds up a range of cells and can also be used for
AVERAGE
,COUNT
,MAX
, andMIN
; - You can combine functions to perform more complex calculations;
- Excel has multiple Error Checking tools for you to utilise.
Task
- Click on
F15
. Type in=SUM
. Double-clickSUM
function in menu. SelectF8
toF14
. Press Enter. - Click on
G15
. Type in=SUM
. Double-clickSUM
function in the menu. SelectG8
toG14
individually. Press Enter. - Click on
C31
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
. Press Enter. - Click on
C32
. Type=MAX
. Double-clickMAX
function in menu. SelectC22
toC28
. Press Enter. - Click on
C33
. Type=MIN
. Double-clickMIN
function in menu. SelectC22
toC28
. Press Enter. - Select
C31
,C32
andC33
. Click and drag fill handle to columnG
. - Select
D15
. Type=COUNT
. Double-clickCOUNT
function in menu. SelectD8
toD14
. Press Enter. - Select
F29
. Click the AutoSum button (Σ
) button. Press Enter. - Click on
C34
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
then type=MIN
Double clickMIN
function and selectC22
toC28
. Press Enter. - Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Task
- Click on
F15
. Type in=SUM
. Double-clickSUM
function in menu. SelectF8
toF14
. Press Enter. - Click on
G15
. Type in=SUM
. Double-clickSUM
function in the menu. SelectG8
toG14
individually. Press Enter. - Click on
C31
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
. Press Enter. - Click on
C32
. Type=MAX
. Double-clickMAX
function in menu. SelectC22
toC28
. Press Enter. - Click on
C33
. Type=MIN
. Double-clickMIN
function in menu. SelectC22
toC28
. Press Enter. - Select
C31
,C32
andC33
. Click and drag fill handle to columnG
. - Select
D15
. Type=COUNT
. Double-clickCOUNT
function in menu. SelectD8
toD14
. Press Enter. - Select
F29
. Click the AutoSum button (Σ
) button. Press Enter. - Click on
C34
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
then type=MIN
Double clickMIN
function and selectC22
toC28
. Press Enter. - Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Everything was clear?
Choose your plan
Common Functions
Excel functions are the secret sauce that turns a simple spreadsheet into a powerful data analysis tool.
This chapter will introduce you to some of the most common and versatile functions: SUM
, AVERAGE
, MIN
, MAX
, and COUNT
.
We'll also explore how to use the AutoSum feature, combine functions for complex calculations, and handle error checking in formulas.
Key Points
- The
SUM
function add up a range of numbers, perfect for calculating totals; - The
AVERAGE
function finds the average value in a range, ignoring empty cells and text; - The
MAX
function identifies the largest number in a range; - The
MIN
function finds the smallest number in a range; - The
COUNT
function tallies the number of cells that contain numbers in a range; - AutoSum quickly adds up a range of cells and can also be used for
AVERAGE
,COUNT
,MAX
, andMIN
; - You can combine functions to perform more complex calculations;
- Excel has multiple Error Checking tools for you to utilise.
Task
- Click on
F15
. Type in=SUM
. Double-clickSUM
function in menu. SelectF8
toF14
. Press Enter. - Click on
G15
. Type in=SUM
. Double-clickSUM
function in the menu. SelectG8
toG14
individually. Press Enter. - Click on
C31
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
. Press Enter. - Click on
C32
. Type=MAX
. Double-clickMAX
function in menu. SelectC22
toC28
. Press Enter. - Click on
C33
. Type=MIN
. Double-clickMIN
function in menu. SelectC22
toC28
. Press Enter. - Select
C31
,C32
andC33
. Click and drag fill handle to columnG
. - Select
D15
. Type=COUNT
. Double-clickCOUNT
function in menu. SelectD8
toD14
. Press Enter. - Select
F29
. Click the AutoSum button (Σ
) button. Press Enter. - Click on
C34
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
then type=MIN
Double clickMIN
function and selectC22
toC28
. Press Enter. - Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Task
- Click on
F15
. Type in=SUM
. Double-clickSUM
function in menu. SelectF8
toF14
. Press Enter. - Click on
G15
. Type in=SUM
. Double-clickSUM
function in the menu. SelectG8
toG14
individually. Press Enter. - Click on
C31
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
. Press Enter. - Click on
C32
. Type=MAX
. Double-clickMAX
function in menu. SelectC22
toC28
. Press Enter. - Click on
C33
. Type=MIN
. Double-clickMIN
function in menu. SelectC22
toC28
. Press Enter. - Select
C31
,C32
andC33
. Click and drag fill handle to columnG
. - Select
D15
. Type=COUNT
. Double-clickCOUNT
function in menu. SelectD8
toD14
. Press Enter. - Select
F29
. Click the AutoSum button (Σ
) button. Press Enter. - Click on
C34
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
then type=MIN
Double clickMIN
function and selectC22
toC28
. Press Enter. - Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Everything was clear?
Choose your plan
Common Functions
Excel functions are the secret sauce that turns a simple spreadsheet into a powerful data analysis tool.
This chapter will introduce you to some of the most common and versatile functions: SUM
, AVERAGE
, MIN
, MAX
, and COUNT
.
We'll also explore how to use the AutoSum feature, combine functions for complex calculations, and handle error checking in formulas.
Key Points
- The
SUM
function add up a range of numbers, perfect for calculating totals; - The
AVERAGE
function finds the average value in a range, ignoring empty cells and text; - The
MAX
function identifies the largest number in a range; - The
MIN
function finds the smallest number in a range; - The
COUNT
function tallies the number of cells that contain numbers in a range; - AutoSum quickly adds up a range of cells and can also be used for
AVERAGE
,COUNT
,MAX
, andMIN
; - You can combine functions to perform more complex calculations;
- Excel has multiple Error Checking tools for you to utilise.
Task
- Click on
F15
. Type in=SUM
. Double-clickSUM
function in menu. SelectF8
toF14
. Press Enter. - Click on
G15
. Type in=SUM
. Double-clickSUM
function in the menu. SelectG8
toG14
individually. Press Enter. - Click on
C31
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
. Press Enter. - Click on
C32
. Type=MAX
. Double-clickMAX
function in menu. SelectC22
toC28
. Press Enter. - Click on
C33
. Type=MIN
. Double-clickMIN
function in menu. SelectC22
toC28
. Press Enter. - Select
C31
,C32
andC33
. Click and drag fill handle to columnG
. - Select
D15
. Type=COUNT
. Double-clickCOUNT
function in menu. SelectD8
toD14
. Press Enter. - Select
F29
. Click the AutoSum button (Σ
) button. Press Enter. - Click on
C34
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
then type=MIN
Double clickMIN
function and selectC22
toC28
. Press Enter. - Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Task
- Click on
F15
. Type in=SUM
. Double-clickSUM
function in menu. SelectF8
toF14
. Press Enter. - Click on
G15
. Type in=SUM
. Double-clickSUM
function in the menu. SelectG8
toG14
individually. Press Enter. - Click on
C31
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
. Press Enter. - Click on
C32
. Type=MAX
. Double-clickMAX
function in menu. SelectC22
toC28
. Press Enter. - Click on
C33
. Type=MIN
. Double-clickMIN
function in menu. SelectC22
toC28
. Press Enter. - Select
C31
,C32
andC33
. Click and drag fill handle to columnG
. - Select
D15
. Type=COUNT
. Double-clickCOUNT
function in menu. SelectD8
toD14
. Press Enter. - Select
F29
. Click the AutoSum button (Σ
) button. Press Enter. - Click on
C34
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
then type=MIN
Double clickMIN
function and selectC22
toC28
. Press Enter. - Accept the Excel correction in the dialog box to add a closing bracket to the formula.
Everything was clear?
Excel functions are the secret sauce that turns a simple spreadsheet into a powerful data analysis tool.
This chapter will introduce you to some of the most common and versatile functions: SUM
, AVERAGE
, MIN
, MAX
, and COUNT
.
We'll also explore how to use the AutoSum feature, combine functions for complex calculations, and handle error checking in formulas.
Key Points
- The
SUM
function add up a range of numbers, perfect for calculating totals; - The
AVERAGE
function finds the average value in a range, ignoring empty cells and text; - The
MAX
function identifies the largest number in a range; - The
MIN
function finds the smallest number in a range; - The
COUNT
function tallies the number of cells that contain numbers in a range; - AutoSum quickly adds up a range of cells and can also be used for
AVERAGE
,COUNT
,MAX
, andMIN
; - You can combine functions to perform more complex calculations;
- Excel has multiple Error Checking tools for you to utilise.
Task
- Click on
F15
. Type in=SUM
. Double-clickSUM
function in menu. SelectF8
toF14
. Press Enter. - Click on
G15
. Type in=SUM
. Double-clickSUM
function in the menu. SelectG8
toG14
individually. Press Enter. - Click on
C31
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
. Press Enter. - Click on
C32
. Type=MAX
. Double-clickMAX
function in menu. SelectC22
toC28
. Press Enter. - Click on
C33
. Type=MIN
. Double-clickMIN
function in menu. SelectC22
toC28
. Press Enter. - Select
C31
,C32
andC33
. Click and drag fill handle to columnG
. - Select
D15
. Type=COUNT
. Double-clickCOUNT
function in menu. SelectD8
toD14
. Press Enter. - Select
F29
. Click the AutoSum button (Σ
) button. Press Enter. - Click on
C34
. Type=AVE
. Double-clickAVERAGE
function in menu. SelectC22
toC28
then type=MIN
Double clickMIN
function and selectC22
toC28
. Press Enter. - Accept the Excel correction in the dialog box to add a closing bracket to the formula.