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 seventh 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 the plus icon (
+
) at the bottom of the workbook to add a new worksheet. - Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
- Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
- Right-click the worksheet tab and select Delete to remove the worksheet.
- Click the tab of the first worksheet to group. Hold down the
Shift
key and click the tab of the last worksheet to group adjacent sheets. - Hold down the
Ctrl
key and click the tabs of Section 5 and 7 to group them. - Make changes to the grouped worksheets.
- Right-click a grouped tab and select Ungroup Sheets to ungroup them.
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting. - Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row. - Select columns
H
&I
and right-click and choose Hide. - Select a row header and right-click to choose Hide.
- Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
- Select row
6
and go to the View tab and click Freeze Panes.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click the plus icon (
+
) at the bottom of the workbook to add a new worksheet. - Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
- Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
- Right-click the worksheet tab and select Delete to remove the worksheet.
- Click the tab of the first worksheet to group. Hold down the
Shift
key and click the tab of the last worksheet to group adjacent sheets. - Hold down the
Ctrl
key and click the tabs of Section 5 and 7 to group them. - Make changes to the grouped worksheets.
- Right-click a grouped tab and select Ungroup Sheets to ungroup them.
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting. - Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row. - Select columns
H
&I
and right-click and choose Hide. - Select a row header and right-click to choose Hide.
- Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
- Select row
6
and go to the View tab and click Freeze Panes.
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 seventh 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 the plus icon (
+
) at the bottom of the workbook to add a new worksheet. - Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
- Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
- Right-click the worksheet tab and select Delete to remove the worksheet.
- Click the tab of the first worksheet to group. Hold down the
Shift
key and click the tab of the last worksheet to group adjacent sheets. - Hold down the
Ctrl
key and click the tabs of Section 5 and 7 to group them. - Make changes to the grouped worksheets.
- Right-click a grouped tab and select Ungroup Sheets to ungroup them.
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting. - Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row. - Select columns
H
&I
and right-click and choose Hide. - Select a row header and right-click to choose Hide.
- Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
- Select row
6
and go to the View tab and click Freeze Panes.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click the plus icon (
+
) at the bottom of the workbook to add a new worksheet. - Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
- Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
- Right-click the worksheet tab and select Delete to remove the worksheet.
- Click the tab of the first worksheet to group. Hold down the
Shift
key and click the tab of the last worksheet to group adjacent sheets. - Hold down the
Ctrl
key and click the tabs of Section 5 and 7 to group them. - Make changes to the grouped worksheets.
- Right-click a grouped tab and select Ungroup Sheets to ungroup them.
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting. - Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row. - Select columns
H
&I
and right-click and choose Hide. - Select a row header and right-click to choose Hide.
- Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
- Select row
6
and go to the View tab and click Freeze Panes.
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 seventh 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 the plus icon (
+
) at the bottom of the workbook to add a new worksheet. - Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
- Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
- Right-click the worksheet tab and select Delete to remove the worksheet.
- Click the tab of the first worksheet to group. Hold down the
Shift
key and click the tab of the last worksheet to group adjacent sheets. - Hold down the
Ctrl
key and click the tabs of Section 5 and 7 to group them. - Make changes to the grouped worksheets.
- Right-click a grouped tab and select Ungroup Sheets to ungroup them.
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting. - Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row. - Select columns
H
&I
and right-click and choose Hide. - Select a row header and right-click to choose Hide.
- Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
- Select row
6
and go to the View tab and click Freeze Panes.
Task
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Click the plus icon (
+
) at the bottom of the workbook to add a new worksheet. - Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
- Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
- Right-click the worksheet tab and select Delete to remove the worksheet.
- Click the tab of the first worksheet to group. Hold down the
Shift
key and click the tab of the last worksheet to group adjacent sheets. - Hold down the
Ctrl
key and click the tabs of Section 5 and 7 to group them. - Make changes to the grouped worksheets.
- Right-click a grouped tab and select Ungroup Sheets to ungroup them.
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting. - Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row. - Select columns
H
&I
and right-click and choose Hide. - Select a row header and right-click to choose Hide.
- Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
- Select row
6
and go to the View tab and click Freeze Panes.
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 seventh 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 the plus icon (
+
) at the bottom of the workbook to add a new worksheet. - Double-click the worksheet tab, or right-click the tab, select Rename, type the new name, and press Enter.
- Click and hold the worksheet tab to rearrange it, then drag it to the desired position.
- Right-click the worksheet tab and select Delete to remove the worksheet.
- Click the tab of the first worksheet to group. Hold down the
Shift
key and click the tab of the last worksheet to group adjacent sheets. - Hold down the
Ctrl
key and click the tabs of Section 5 and 7 to group them. - Make changes to the grouped worksheets.
- Right-click a grouped tab and select Ungroup Sheets to ungroup them.
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting. - Right-click column
H
and select Insert. - Right-click
G6
, select Insert, and choose Entire Row. Choose to clear the formatting completely on the Insert Options button. - Right-click column
H
and select Delete. - Right-click
G6
, select Delete, and choose Entire Row. - Select columns
H
&I
and right-click and choose Hide. - Select a row header and right-click to choose Hide.
- Select the columns or rows on either side of the hidden ones, right-click, and choose Unhide.
- Select row
6
and go to the View tab and click Freeze Panes.