Having completed the sixth 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:

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.
Click on the Pie Chart. Click the + button near the top-right corner of the chart.
Click on the Savings chart. Go to the Design tab, hover over different styles in the Chart Styles group, and select a style.
Select the Stacked column chart. Click the title, type Income vs Expenses, and format the font color.
Select Chart Title from the menu, go to More Options, choose Solid Fill, and select a color.
Tick the Data box, choose Label Options, untick value, tick percentage, and position labels on the outside end.
Click the arrow to format the Legend, align it to the right of the Pie Chart.
Click on the Change Colors button in the Chart Design tab, and choose a color scheme.
Go to the Format tab, select individual chart elements, and adjust their fill, outline, and effects.
Click the dropdown arrow of Shape Styles, choose a theme and preset style.
Choose WordArt Styles for text, adjust colors for each element.
Reset styles if needed by pressing the Reset to Match Style button.
Click on Chart Elements, select Data Table, click the arrow menu, and go to More Options to customize the table.
Click Chart Elements. Remove the Legend and Gridlines.
Use the Align button in the Format tab, select Snap to Grid.
Select Income and Expenses Chart. Go to the Chart Design tab, click on Select Data. Click on Fixed Costs, click Edit, select Savings in F5 then select cells F6 to F17 for values, and click OK.
Click Add in Legend Entries, select Fixed Costs, select cells from E6 to E17, and click OK.
Select Savings Chart. Click Change Chart type.
Choose a Clustered Column Chart. Click OK.
Click on the Savings chart. Go to the Chart Tools Design tab, click on Add Chart Element, hover over Trendline, and choose Linear.
Right-click on the trendline, choose Format Trendline, and open the pane. Set forward forecast to 1, set Polynomial trendline to degree 4, and change the color to blue.

Task

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.
Click on the Pie Chart. Click the + button near the top-right corner of the chart.
Click on the Savings chart. Go to the Design tab, hover over different styles in the Chart Styles group, and select a style.
Select the Stacked column chart. Click the title, type Income vs Expenses, and format the font color.
Select Chart Title from the menu, go to More Options, choose Solid Fill, and select a color.
Tick the Data box, choose Label Options, untick value, tick percentage, and position labels on the outside end.
Click the arrow to format the Legend, align it to the right of the Pie Chart.
Click on the Change Colors button in the Chart Design tab, and choose a color scheme.
Go to the Format tab, select individual chart elements, and adjust their fill, outline, and effects.
Click the dropdown arrow of Shape Styles, choose a theme and preset style.
Choose WordArt Styles for text, adjust colors for each element.
Reset styles if needed by pressing the Reset to Match Style button.
Click on Chart Elements, select Data Table, click the arrow menu, and go to More Options to customize the table.
Click Chart Elements. Remove the Legend and Gridlines.
Use the Align button in the Format tab, select Snap to Grid.
Select Income and Expenses Chart. Go to the Chart Design tab, click on Select Data. Click on Fixed Costs, click Edit, select Savings in F5 then select cells F6 to F17 for values, and click OK.
Click Add in Legend Entries, select Fixed Costs, select cells from E6 to E17, and click OK.
Select Savings Chart. Click Change Chart type.
Choose a Clustered Column Chart. Click OK.
Click on the Savings chart. Go to the Chart Tools Design tab, click on Add Chart Element, hover over Trendline, and choose Linear.
Right-click on the trendline, choose Format Trendline, and open the pane. Set forward forecast to 1, set Polynomial trendline to degree 4, and change the color to blue.

Mark tasks as Completed

Everything was clear?

Section 6. Chapter 8

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 sixth 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:

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.
Click on the Pie Chart. Click the + button near the top-right corner of the chart.
Click on the Savings chart. Go to the Design tab, hover over different styles in the Chart Styles group, and select a style.
Select the Stacked column chart. Click the title, type Income vs Expenses, and format the font color.
Select Chart Title from the menu, go to More Options, choose Solid Fill, and select a color.
Tick the Data box, choose Label Options, untick value, tick percentage, and position labels on the outside end.
Click the arrow to format the Legend, align it to the right of the Pie Chart.
Click on the Change Colors button in the Chart Design tab, and choose a color scheme.
Go to the Format tab, select individual chart elements, and adjust their fill, outline, and effects.
Click the dropdown arrow of Shape Styles, choose a theme and preset style.
Choose WordArt Styles for text, adjust colors for each element.
Reset styles if needed by pressing the Reset to Match Style button.
Click on Chart Elements, select Data Table, click the arrow menu, and go to More Options to customize the table.
Click Chart Elements. Remove the Legend and Gridlines.
Use the Align button in the Format tab, select Snap to Grid.
Select Income and Expenses Chart. Go to the Chart Design tab, click on Select Data. Click on Fixed Costs, click Edit, select Savings in F5 then select cells F6 to F17 for values, and click OK.
Click Add in Legend Entries, select Fixed Costs, select cells from E6 to E17, and click OK.
Select Savings Chart. Click Change Chart type.
Choose a Clustered Column Chart. Click OK.
Click on the Savings chart. Go to the Chart Tools Design tab, click on Add Chart Element, hover over Trendline, and choose Linear.
Right-click on the trendline, choose Format Trendline, and open the pane. Set forward forecast to 1, set Polynomial trendline to degree 4, and change the color to blue.

Task

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.
Click on the Pie Chart. Click the + button near the top-right corner of the chart.
Click on the Savings chart. Go to the Design tab, hover over different styles in the Chart Styles group, and select a style.
Select the Stacked column chart. Click the title, type Income vs Expenses, and format the font color.
Select Chart Title from the menu, go to More Options, choose Solid Fill, and select a color.
Tick the Data box, choose Label Options, untick value, tick percentage, and position labels on the outside end.
Click the arrow to format the Legend, align it to the right of the Pie Chart.
Click on the Change Colors button in the Chart Design tab, and choose a color scheme.
Go to the Format tab, select individual chart elements, and adjust their fill, outline, and effects.
Click the dropdown arrow of Shape Styles, choose a theme and preset style.
Choose WordArt Styles for text, adjust colors for each element.
Reset styles if needed by pressing the Reset to Match Style button.
Click on Chart Elements, select Data Table, click the arrow menu, and go to More Options to customize the table.
Click Chart Elements. Remove the Legend and Gridlines.
Use the Align button in the Format tab, select Snap to Grid.
Select Income and Expenses Chart. Go to the Chart Design tab, click on Select Data. Click on Fixed Costs, click Edit, select Savings in F5 then select cells F6 to F17 for values, and click OK.
Click Add in Legend Entries, select Fixed Costs, select cells from E6 to E17, and click OK.
Select Savings Chart. Click Change Chart type.
Choose a Clustered Column Chart. Click OK.
Click on the Savings chart. Go to the Chart Tools Design tab, click on Add Chart Element, hover over Trendline, and choose Linear.
Right-click on the trendline, choose Format Trendline, and open the pane. Set forward forecast to 1, set Polynomial trendline to degree 4, and change the color to blue.

Mark tasks as Completed

Everything was clear?

Section 6. Chapter 8

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 sixth 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:

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.
Click on the Pie Chart. Click the + button near the top-right corner of the chart.
Click on the Savings chart. Go to the Design tab, hover over different styles in the Chart Styles group, and select a style.
Select the Stacked column chart. Click the title, type Income vs Expenses, and format the font color.
Select Chart Title from the menu, go to More Options, choose Solid Fill, and select a color.
Tick the Data box, choose Label Options, untick value, tick percentage, and position labels on the outside end.
Click the arrow to format the Legend, align it to the right of the Pie Chart.
Click on the Change Colors button in the Chart Design tab, and choose a color scheme.
Go to the Format tab, select individual chart elements, and adjust their fill, outline, and effects.
Click the dropdown arrow of Shape Styles, choose a theme and preset style.
Choose WordArt Styles for text, adjust colors for each element.
Reset styles if needed by pressing the Reset to Match Style button.
Click on Chart Elements, select Data Table, click the arrow menu, and go to More Options to customize the table.
Click Chart Elements. Remove the Legend and Gridlines.
Use the Align button in the Format tab, select Snap to Grid.
Select Income and Expenses Chart. Go to the Chart Design tab, click on Select Data. Click on Fixed Costs, click Edit, select Savings in F5 then select cells F6 to F17 for values, and click OK.
Click Add in Legend Entries, select Fixed Costs, select cells from E6 to E17, and click OK.
Select Savings Chart. Click Change Chart type.
Choose a Clustered Column Chart. Click OK.
Click on the Savings chart. Go to the Chart Tools Design tab, click on Add Chart Element, hover over Trendline, and choose Linear.
Right-click on the trendline, choose Format Trendline, and open the pane. Set forward forecast to 1, set Polynomial trendline to degree 4, and change the color to blue.

Task

Please verify that you have already completed these steps. If not, go ahead and finish your workbook:

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.
Click on the Pie Chart. Click the + button near the top-right corner of the chart.
Click on the Savings chart. Go to the Design tab, hover over different styles in the Chart Styles group, and select a style.
Select the Stacked column chart. Click the title, type Income vs Expenses, and format the font color.
Select Chart Title from the menu, go to More Options, choose Solid Fill, and select a color.
Tick the Data box, choose Label Options, untick value, tick percentage, and position labels on the outside end.
Click the arrow to format the Legend, align it to the right of the Pie Chart.
Click on the Change Colors button in the Chart Design tab, and choose a color scheme.
Go to the Format tab, select individual chart elements, and adjust their fill, outline, and effects.
Click the dropdown arrow of Shape Styles, choose a theme and preset style.
Choose WordArt Styles for text, adjust colors for each element.
Reset styles if needed by pressing the Reset to Match Style button.
Click on Chart Elements, select Data Table, click the arrow menu, and go to More Options to customize the table.
Click Chart Elements. Remove the Legend and Gridlines.
Use the Align button in the Format tab, select Snap to Grid.
Select Income and Expenses Chart. Go to the Chart Design tab, click on Select Data. Click on Fixed Costs, click Edit, select Savings in F5 then select cells F6 to F17 for values, and click OK.
Click Add in Legend Entries, select Fixed Costs, select cells from E6 to E17, and click OK.
Select Savings Chart. Click Change Chart type.
Choose a Clustered Column Chart. Click OK.
Click on the Savings chart. Go to the Chart Tools Design tab, click on Add Chart Element, hover over Trendline, and choose Linear.
Right-click on the trendline, choose Format Trendline, and open the pane. Set forward forecast to 1, set Polynomial trendline to degree 4, and change the color to blue.

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 sixth 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:

Select cells from B5 to F17. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it.
Select cells B5 to E17. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart.
Select cells B5 to B17, hold Ctrl, select F5 to F17. Choose an Area chart, resize it and move it under the dataset.
Click on the Pie Chart. Click the + button near the top-right corner of the chart.
Click on the Savings chart. Go to the Design tab, hover over different styles in the Chart Styles group, and select a style.
Select the Stacked column chart. Click the title, type Income vs Expenses, and format the font color.
Select Chart Title from the menu, go to More Options, choose Solid Fill, and select a color.
Tick the Data box, choose Label Options, untick value, tick percentage, and position labels on the outside end.
Click the arrow to format the Legend, align it to the right of the Pie Chart.
Click on the Change Colors button in the Chart Design tab, and choose a color scheme.
Go to the Format tab, select individual chart elements, and adjust their fill, outline, and effects.
Click the dropdown arrow of Shape Styles, choose a theme and preset style.
Choose WordArt Styles for text, adjust colors for each element.
Reset styles if needed by pressing the Reset to Match Style button.
Click on Chart Elements, select Data Table, click the arrow menu, and go to More Options to customize the table.
Click Chart Elements. Remove the Legend and Gridlines.
Use the Align button in the Format tab, select Snap to Grid.
Select Income and Expenses Chart. Go to the Chart Design tab, click on Select Data. Click on Fixed Costs, click Edit, select Savings in F5 then select cells F6 to F17 for values, and click OK.
Click Add in Legend Entries, select Fixed Costs, select cells from E6 to E17, and click OK.
Select Savings Chart. Click Change Chart type.
Choose a Clustered Column Chart. Click OK.
Click on the Savings chart. Go to the Chart Tools Design tab, click on Add Chart Element, hover over Trendline, and choose Linear.
Right-click on the trendline, choose Format Trendline, and open the pane. Set forward forecast to 1, set Polynomial trendline to degree 4, and change the color to blue.

Section 6. Chapter 8

Switch to desktop for real-world practiceContinue from where you are using one of the options below