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 find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.
Completing the Workbook
Having completed the second 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 Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align. - Select cell
B3
. Go to the Font style drop-down menu and choose a font from the list. - Select cell
B3
. Click on the Font size button and choose14
. - Click on
B3
. Go to the Font section, click on the Font color and select one. - Select cells from
B5
toB8
. Go to the Font section and choose a different font. - Select cells from
B11
toI11
and click the Bold button. Or use the shortcutCtrl + B
. - Click on
G5
and click the Underline and Italic buttons. - Select cells
B11
toI11
. Go to the Orientation button and choose Rotate Text Up. - Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align. - Select cell
B3
. Go to the Font style drop-down menu and choose a font from the list. - Select cell
B3
. Click on the Font size button and choose14
. - Click on
B3
. Go to the Font section, click on the Font color and select one. - Select cells from
B5
toB8
. Go to the Font section and choose a different font. - Select cells from
B11
toI11
and click the Bold button. Or use the shortcutCtrl + B
. - Click on
G5
and click the Underline and Italic buttons. - Select cells
B11
toI11
. Go to the Orientation button and choose Rotate Text Up. - Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
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 find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.
Completing the Workbook
Having completed the second 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 Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align. - Select cell
B3
. Go to the Font style drop-down menu and choose a font from the list. - Select cell
B3
. Click on the Font size button and choose14
. - Click on
B3
. Go to the Font section, click on the Font color and select one. - Select cells from
B5
toB8
. Go to the Font section and choose a different font. - Select cells from
B11
toI11
and click the Bold button. Or use the shortcutCtrl + B
. - Click on
G5
and click the Underline and Italic buttons. - Select cells
B11
toI11
. Go to the Orientation button and choose Rotate Text Up. - Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align. - Select cell
B3
. Go to the Font style drop-down menu and choose a font from the list. - Select cell
B3
. Click on the Font size button and choose14
. - Click on
B3
. Go to the Font section, click on the Font color and select one. - Select cells from
B5
toB8
. Go to the Font section and choose a different font. - Select cells from
B11
toI11
and click the Bold button. Or use the shortcutCtrl + B
. - Click on
G5
and click the Underline and Italic buttons. - Select cells
B11
toI11
. Go to the Orientation button and choose Rotate Text Up. - Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
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 find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.
Completing the Workbook
Having completed the second 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 Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align. - Select cell
B3
. Go to the Font style drop-down menu and choose a font from the list. - Select cell
B3
. Click on the Font size button and choose14
. - Click on
B3
. Go to the Font section, click on the Font color and select one. - Select cells from
B5
toB8
. Go to the Font section and choose a different font. - Select cells from
B11
toI11
and click the Bold button. Or use the shortcutCtrl + B
. - Click on
G5
and click the Underline and Italic buttons. - Select cells
B11
toI11
. Go to the Orientation button and choose Rotate Text Up. - Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click on Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align. - Select cell
B3
. Go to the Font style drop-down menu and choose a font from the list. - Select cell
B3
. Click on the Font size button and choose14
. - Click on
B3
. Go to the Font section, click on the Font color and select one. - Select cells from
B5
toB8
. Go to the Font section and choose a different font. - Select cells from
B11
toI11
and click the Bold button. Or use the shortcutCtrl + B
. - Click on
G5
and click the Underline and Italic buttons. - Select cells
B11
toI11
. Go to the Orientation button and choose Rotate Text Up. - Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
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 find you've missed some topics and answered incorrectly, consider revisiting the relevant section to review the material.
Completing the Workbook
Having completed the second 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 Row
3
& drag the boundary to show the title header in full. - Click on Column
B
. Double click the boundary on the right to automatically adjust the width. - Select columns
C
through toI
. Right click for menu. Enter11
in Column Width. Press Enter. - Select cells from
C12
toI18
. Click the Borders button to add borders to all sides of the cells. - Select cells from
C20
toI20
. Click the Borders button to add borders to all sides of the cells. - Select cells from
B11
toI11
. Click the Fill Color button. Choose a color. Repeat with cellsB19
toI19
andB12
toB18
. - Select cells from
B3
toE3
. Go to the Alignment group and click the Merge & Center button. - Select cells from
C11
toI11
. Go to the Alignment group and click the Wrap Text button. - Select cells from
C11
toI21
. In the Alignment group click Middle Align and then click on Centre align. - Select cell
B3
. Go to the Font style drop-down menu and choose a font from the list. - Select cell
B3
. Click on the Font size button and choose14
. - Click on
B3
. Go to the Font section, click on the Font color and select one. - Select cells from
B5
toB8
. Go to the Font section and choose a different font. - Select cells from
B11
toI11
and click the Bold button. Or use the shortcutCtrl + B
. - Click on
G5
and click the Underline and Italic buttons. - Select cells
B11
toI11
. Go to the Orientation button and choose Rotate Text Up. - Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.