Contenido del Curso
Excel Essentials
Excel Essentials
Challenge
Quiz
It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.
Note
If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.
Completing the Workbook
Having completed the third section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier.
If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on
F8
. Type=E8*C17
. Press Enter. - Click on
G8
. Type=(E8+F8)*D8
. - Click on
G8
and drag down the fill handle toG14
. - Click on
F8
. Add dollar signs before theC
and before17
. Press Enter. Drag fill handle toF14
. - 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.
- Select
G29
. Click Fx. SelectSUM
function, clickOK
. - Select from
C22
toC28
. Click on Number 2. - Select
D22
toD28
. Click on Number 3. - Select
E22
toE28
. Click Number 4. - Select
F22
toF28
. Click ΟΚ.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on
F8
. Type=E8*C17
. Press Enter. - Click on
G8
. Type=(E8+F8)*D8
. - Click on
G8
and drag down the fill handle toG14
. - Click on
F8
. Add dollar signs before theC
and before17
. Press Enter. Drag fill handle toF14
. - 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.
- Select
G29
. Click Fx. SelectSUM
function, clickOK
. - Select from
C22
toC28
. Click on Number 2. - Select
D22
toD28
. Click on Number 3. - Select
E22
toE28
. Click Number 4. - Select
F22
toF28
. Click ΟΚ.
¿Todo estuvo claro?
Elige tu plan
Challenge
Quiz
It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.
Note
If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.
Completing the Workbook
Having completed the third section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier.
If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on
F8
. Type=E8*C17
. Press Enter. - Click on
G8
. Type=(E8+F8)*D8
. - Click on
G8
and drag down the fill handle toG14
. - Click on
F8
. Add dollar signs before theC
and before17
. Press Enter. Drag fill handle toF14
. - 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.
- Select
G29
. Click Fx. SelectSUM
function, clickOK
. - Select from
C22
toC28
. Click on Number 2. - Select
D22
toD28
. Click on Number 3. - Select
E22
toE28
. Click Number 4. - Select
F22
toF28
. Click ΟΚ.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on
F8
. Type=E8*C17
. Press Enter. - Click on
G8
. Type=(E8+F8)*D8
. - Click on
G8
and drag down the fill handle toG14
. - Click on
F8
. Add dollar signs before theC
and before17
. Press Enter. Drag fill handle toF14
. - 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.
- Select
G29
. Click Fx. SelectSUM
function, clickOK
. - Select from
C22
toC28
. Click on Number 2. - Select
D22
toD28
. Click on Number 3. - Select
E22
toE28
. Click Number 4. - Select
F22
toF28
. Click ΟΚ.
¿Todo estuvo claro?
Elige tu plan
Challenge
Quiz
It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.
Note
If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.
Completing the Workbook
Having completed the third section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier.
If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on
F8
. Type=E8*C17
. Press Enter. - Click on
G8
. Type=(E8+F8)*D8
. - Click on
G8
and drag down the fill handle toG14
. - Click on
F8
. Add dollar signs before theC
and before17
. Press Enter. Drag fill handle toF14
. - 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.
- Select
G29
. Click Fx. SelectSUM
function, clickOK
. - Select from
C22
toC28
. Click on Number 2. - Select
D22
toD28
. Click on Number 3. - Select
E22
toE28
. Click Number 4. - Select
F22
toF28
. Click ΟΚ.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on
F8
. Type=E8*C17
. Press Enter. - Click on
G8
. Type=(E8+F8)*D8
. - Click on
G8
and drag down the fill handle toG14
. - Click on
F8
. Add dollar signs before theC
and before17
. Press Enter. Drag fill handle toF14
. - 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.
- Select
G29
. Click Fx. SelectSUM
function, clickOK
. - Select from
C22
toC28
. Click on Number 2. - Select
D22
toD28
. Click on Number 3. - Select
E22
toE28
. Click Number 4. - Select
F22
toF28
. Click ΟΚ.
¿Todo estuvo claro?
Quiz
It's time to assess your theoretical knowledge. Watch the video below and try to answer all the questions within the allotted time.
Note
If you find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.
Completing the Workbook
Having completed the third section, it's now time to put your skills to the test. Your initial task is to complete all the exercises in the workbook provided earlier.
If you can't find it or if it's been corrupted during your training, don't worry. You can download it again here:
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on
F8
. Type=E8*C17
. Press Enter. - Click on
G8
. Type=(E8+F8)*D8
. - Click on
G8
and drag down the fill handle toG14
. - Click on
F8
. Add dollar signs before theC
and before17
. Press Enter. Drag fill handle toF14
. - 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.
- Select
G29
. Click Fx. SelectSUM
function, clickOK
. - Select from
C22
toC28
. Click on Number 2. - Select
D22
toD28
. Click on Number 3. - Select
E22
toE28
. Click Number 4. - Select
F22
toF28
. Click ΟΚ.