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 fourth 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 the Show Formulas button in the Formulas tab on the Ribbon. Or press
Ctrl
+`
. - Select
C22
. Type=IF(G8>=H8, "Target Met", "Target Not Met")
. Click and drag toC28
. - Select
C34
. Type=IF(C22="Target Met", "20%", "0%")
. Click and drag toC40
. - Type
=IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%"))))
into cellD34
. Click and drag toF40
. - Type
=AND(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Type
=OR(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Select
G34
. Type=IF(OR(C22="Target Met", G22>95), "20%", "0%")
. Click and drag toF40
. - Select
C22
. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents. - Select
C22
. Click on Trace Dependents on the Formulas tab. - Select
C22
. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate. - Click on Watch Window in the Formulas tab. Select
H34
toH40
. Click Add Watch. - Select cells
D22
toG28
. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background. - Select cells
D22
toG28
. Click Less Than. Type 70 and select a red background. - Select cells
C8
toF14
. Click Top/Bottom Rules > Bottom 10 Items. Select a red background. - Select cells
G8
toG14
. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color. - Select cells
D22
toG28
. Click Conditional Formatting > Color Scales. Choose one. - Select cells
D22
toG28
. Click Conditional Formatting > Icon Sets. Choose one of the sets. - Select cells
B8
toH41
. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type=ISFORMULA(B8)
. Click on Format, choose a color, and click OK.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click the Show Formulas button in the Formulas tab on the Ribbon. Or press
Ctrl
+`
. - Select
C22
. Type=IF(G8>=H8, "Target Met", "Target Not Met")
. Click and drag toC28
. - Select
C34
. Type=IF(C22="Target Met", "20%", "0%")
. Click and drag toC40
. - Type
=IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%"))))
into cellD34
. Click and drag toF40
. - Type
=AND(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Type
=OR(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Select
G34
. Type=IF(OR(C22="Target Met", G22>95), "20%", "0%")
. Click and drag toF40
. - Select
C22
. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents. - Select
C22
. Click on Trace Dependents on the Formulas tab. - Select
C22
. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate. - Click on Watch Window in the Formulas tab. Select
H34
toH40
. Click Add Watch. - Select cells
D22
toG28
. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background. - Select cells
D22
toG28
. Click Less Than. Type 70 and select a red background. - Select cells
C8
toF14
. Click Top/Bottom Rules > Bottom 10 Items. Select a red background. - Select cells
G8
toG14
. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color. - Select cells
D22
toG28
. Click Conditional Formatting > Color Scales. Choose one. - Select cells
D22
toG28
. Click Conditional Formatting > Icon Sets. Choose one of the sets. - Select cells
B8
toH41
. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type=ISFORMULA(B8)
. Click on Format, choose a color, and click OK.
¿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 fourth 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 the Show Formulas button in the Formulas tab on the Ribbon. Or press
Ctrl
+`
. - Select
C22
. Type=IF(G8>=H8, "Target Met", "Target Not Met")
. Click and drag toC28
. - Select
C34
. Type=IF(C22="Target Met", "20%", "0%")
. Click and drag toC40
. - Type
=IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%"))))
into cellD34
. Click and drag toF40
. - Type
=AND(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Type
=OR(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Select
G34
. Type=IF(OR(C22="Target Met", G22>95), "20%", "0%")
. Click and drag toF40
. - Select
C22
. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents. - Select
C22
. Click on Trace Dependents on the Formulas tab. - Select
C22
. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate. - Click on Watch Window in the Formulas tab. Select
H34
toH40
. Click Add Watch. - Select cells
D22
toG28
. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background. - Select cells
D22
toG28
. Click Less Than. Type 70 and select a red background. - Select cells
C8
toF14
. Click Top/Bottom Rules > Bottom 10 Items. Select a red background. - Select cells
G8
toG14
. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color. - Select cells
D22
toG28
. Click Conditional Formatting > Color Scales. Choose one. - Select cells
D22
toG28
. Click Conditional Formatting > Icon Sets. Choose one of the sets. - Select cells
B8
toH41
. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type=ISFORMULA(B8)
. Click on Format, choose a color, and click OK.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click the Show Formulas button in the Formulas tab on the Ribbon. Or press
Ctrl
+`
. - Select
C22
. Type=IF(G8>=H8, "Target Met", "Target Not Met")
. Click and drag toC28
. - Select
C34
. Type=IF(C22="Target Met", "20%", "0%")
. Click and drag toC40
. - Type
=IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%"))))
into cellD34
. Click and drag toF40
. - Type
=AND(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Type
=OR(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Select
G34
. Type=IF(OR(C22="Target Met", G22>95), "20%", "0%")
. Click and drag toF40
. - Select
C22
. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents. - Select
C22
. Click on Trace Dependents on the Formulas tab. - Select
C22
. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate. - Click on Watch Window in the Formulas tab. Select
H34
toH40
. Click Add Watch. - Select cells
D22
toG28
. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background. - Select cells
D22
toG28
. Click Less Than. Type 70 and select a red background. - Select cells
C8
toF14
. Click Top/Bottom Rules > Bottom 10 Items. Select a red background. - Select cells
G8
toG14
. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color. - Select cells
D22
toG28
. Click Conditional Formatting > Color Scales. Choose one. - Select cells
D22
toG28
. Click Conditional Formatting > Icon Sets. Choose one of the sets. - Select cells
B8
toH41
. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type=ISFORMULA(B8)
. Click on Format, choose a color, and click OK.
¿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 fourth 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 the Show Formulas button in the Formulas tab on the Ribbon. Or press
Ctrl
+`
. - Select
C22
. Type=IF(G8>=H8, "Target Met", "Target Not Met")
. Click and drag toC28
. - Select
C34
. Type=IF(C22="Target Met", "20%", "0%")
. Click and drag toC40
. - Type
=IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%"))))
into cellD34
. Click and drag toF40
. - Type
=AND(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Type
=OR(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Select
G34
. Type=IF(OR(C22="Target Met", G22>95), "20%", "0%")
. Click and drag toF40
. - Select
C22
. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents. - Select
C22
. Click on Trace Dependents on the Formulas tab. - Select
C22
. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate. - Click on Watch Window in the Formulas tab. Select
H34
toH40
. Click Add Watch. - Select cells
D22
toG28
. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background. - Select cells
D22
toG28
. Click Less Than. Type 70 and select a red background. - Select cells
C8
toF14
. Click Top/Bottom Rules > Bottom 10 Items. Select a red background. - Select cells
G8
toG14
. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color. - Select cells
D22
toG28
. Click Conditional Formatting > Color Scales. Choose one. - Select cells
D22
toG28
. Click Conditional Formatting > Icon Sets. Choose one of the sets. - Select cells
B8
toH41
. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type=ISFORMULA(B8)
. Click on Format, choose a color, and click OK.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click the Show Formulas button in the Formulas tab on the Ribbon. Or press
Ctrl
+`
. - Select
C22
. Type=IF(G8>=H8, "Target Met", "Target Not Met")
. Click and drag toC28
. - Select
C34
. Type=IF(C22="Target Met", "20%", "0%")
. Click and drag toC40
. - Type
=IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%"))))
into cellD34
. Click and drag toF40
. - Type
=AND(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Type
=OR(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Select
G34
. Type=IF(OR(C22="Target Met", G22>95), "20%", "0%")
. Click and drag toF40
. - Select
C22
. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents. - Select
C22
. Click on Trace Dependents on the Formulas tab. - Select
C22
. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate. - Click on Watch Window in the Formulas tab. Select
H34
toH40
. Click Add Watch. - Select cells
D22
toG28
. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background. - Select cells
D22
toG28
. Click Less Than. Type 70 and select a red background. - Select cells
C8
toF14
. Click Top/Bottom Rules > Bottom 10 Items. Select a red background. - Select cells
G8
toG14
. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color. - Select cells
D22
toG28
. Click Conditional Formatting > Color Scales. Choose one. - Select cells
D22
toG28
. Click Conditional Formatting > Icon Sets. Choose one of the sets. - Select cells
B8
toH41
. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type=ISFORMULA(B8)
. Click on Format, choose a color, and click OK.
¿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 fourth 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 the Show Formulas button in the Formulas tab on the Ribbon. Or press
Ctrl
+`
. - Select
C22
. Type=IF(G8>=H8, "Target Met", "Target Not Met")
. Click and drag toC28
. - Select
C34
. Type=IF(C22="Target Met", "20%", "0%")
. Click and drag toC40
. - Type
=IF(D22>=90, "20%", IF(D22>=80, "15%", IF(D22>=70, "10%", IF(D22>=60, "5%", "0%"))))
into cellD34
. Click and drag toF40
. - Type
=AND(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Type
=OR(C22="Target Met", G22>95)
into cellH22
. Click and drag toH28
. - Select
G34
. Type=IF(OR(C22="Target Met", G22>95), "20%", "0%")
. Click and drag toF40
. - Select
C22
. Click on Trace Precedents on the Formulas tab. Then, click Trace Dependents. - Select
C22
. Click on Trace Dependents on the Formulas tab. - Select
C22
. Click on Evaluate Formula on the Formulas tab. Then, click Evaluate. - Click on Watch Window in the Formulas tab. Select
H34
toH40
. Click Add Watch. - Select cells
D22
toG28
. Click Conditional Formatting > Highlight Cells Rules > Greater Than. Type 90 and select a green background. - Select cells
D22
toG28
. Click Less Than. Type 70 and select a red background. - Select cells
C8
toF14
. Click Top/Bottom Rules > Bottom 10 Items. Select a red background. - Select cells
G8
toG14
. Click Conditional Formatting > Data Bars > Solid Fill and select a blue color. - Select cells
D22
toG28
. Click Conditional Formatting > Color Scales. Choose one. - Select cells
D22
toG28
. Click Conditional Formatting > Icon Sets. Choose one of the sets. - Select cells
B8
toH41
. Click Conditional Formatting > New Rule > Use a formula to determine which cells to format. Type=ISFORMULA(B8)
. Click on Format, choose a color, and click OK.