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 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:
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. 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 cellsF6
toF17
for values, and click OK. - Click Add in Legend Entries, select Fixed Costs, select cells from
E6
toE17
, 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.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. 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 cellsF6
toF17
for values, and click OK. - Click Add in Legend Entries, select Fixed Costs, select cells from
E6
toE17
, 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.
¿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 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:
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. 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 cellsF6
toF17
for values, and click OK. - Click Add in Legend Entries, select Fixed Costs, select cells from
E6
toE17
, 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.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. 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 cellsF6
toF17
for values, and click OK. - Click Add in Legend Entries, select Fixed Costs, select cells from
E6
toE17
, 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.
¿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 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:
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. 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 cellsF6
toF17
for values, and click OK. - Click Add in Legend Entries, select Fixed Costs, select cells from
E6
toE17
, 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.
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. 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 cellsF6
toF17
for values, and click OK. - Click Add in Legend Entries, select Fixed Costs, select cells from
E6
toE17
, 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.
¿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 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:
Tarea
Please verify that you have already completed these steps. If not, go ahead and finish your workbook:
- Select cells from
B5
toF17
. Click on the Pie Chart button, select 3D Pie, and click OK. Move & Resize it. - Select cells
B5
toE17
. Click on Charts button > Column charts > Stacked Column. Click OK. Position it under the Pie Chart. - Select cells
B5
toB17
, holdCtrl
, selectF5
toF17
. 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 cellsF6
toF17
for values, and click OK. - Click Add in Legend Entries, select Fixed Costs, select cells from
E6
toE17
, 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.