Course Content
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 need more time to think about your answer, feel free to pause the quiz timer.
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 first 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:
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on the
+
sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete. - Move your cursor in-between columns
F
andG
. Double-click to adjust the size of the column. - Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill. - Highlight the cells from
L7
toL18
& click on Flash Fill.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on the
+
sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete. - Move your cursor in-between columns
F
andG
. Double-click to adjust the size of the column. - Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill. - Highlight the cells from
L7
toL18
& click on Flash Fill.
Everything was clear?
Choose your 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 need more time to think about your answer, feel free to pause the quiz timer.
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 first 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:
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on the
+
sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete. - Move your cursor in-between columns
F
andG
. Double-click to adjust the size of the column. - Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill. - Highlight the cells from
L7
toL18
& click on Flash Fill.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on the
+
sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete. - Move your cursor in-between columns
F
andG
. Double-click to adjust the size of the column. - Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill. - Highlight the cells from
L7
toL18
& click on Flash Fill.
Everything was clear?
Choose your 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 need more time to think about your answer, feel free to pause the quiz timer.
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 first 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:
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on the
+
sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete. - Move your cursor in-between columns
F
andG
. Double-click to adjust the size of the column. - Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill. - Highlight the cells from
L7
toL18
& click on Flash Fill.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on the
+
sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete. - Move your cursor in-between columns
F
andG
. Double-click to adjust the size of the column. - Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill. - Highlight the cells from
L7
toL18
& click on Flash Fill.
Everything was clear?
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 need more time to think about your answer, feel free to pause the quiz timer.
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 first 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:
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on the
+
sign to add a new worksheet. Right-click on the new worksheet to access the menu and then delete. - Move your cursor in-between columns
F
andG
. Double-click to adjust the size of the column. - Click on
B7
. Type January directly into the cell. PressEnter
. - Click on
I7
and enter the date 01/12/2024. - Click on January in
B7
& drag down toB18
to Autofill the months of the year. - Click on the date in
I7
& drag down toI18
to Autofill the dates. - Highlight the cells from
K7
toK18
& click on Flash Fill. - Highlight the cells from
L7
toL18
& click on Flash Fill.