Contenido del Curso

Excel Essentials

1. Introduction to Excel

Introduction Getting Acquainted with Excel Excel Interface Entering Data Challenge

2. Entering and Formatting Data

Formatting Cells Formatting Text Formatting Numbers Challenge

3. Basic Formulas and Functions

Introduction to Formulas and Functions Using Cell References Understanding Ranges Common Functions Application of INSERT FUNCTION Challenge

4. Advanced Formulas and Functions

Displaying and Highlighting Formulas IF Logical Test and Relational Operators Nested IF Statements Compound Logical Tests with AND, OR Using Auditing Tools Conditional Formatting Challenge

5. Data Management and Analysis

Sorting Data Filtering Data Using AutoFilter Clearing and Reapplying Filters Rules and Search Creating and Managing Tables Table Styles and Quick Formatting Options Using Table Tools Challenge

6. Visualizing Data with Charts and Graphs

Types of Charts Creating a Basic Chart Customizing Chart Elements Changing Chart Styles and Colors Adding and Removing Chart Elements Editing Data in Charts Adding Trendlines to Charts Challenge

7. Working with Worksheets and Workbooks

Add, Delete, Rename, and Rearrange Worksheets Grouping and Ungrouping Worksheets Using the Format Painter Inserting and Deleting Columns, Rows, and Cells Hiding and Unhiding Columns and Rows Saving Workbooks Opening and Closing Workbooks Protecting Workbooks with Passwords Using Templates Challenge Summary

Customizing Chart Elements

This chapter focuses on tweaking and fine-tuning chart elements to better tell your data's story.

You'll learn how to add, remove, and modify components like titles, legends, and labels, enhancing the clarity and impact of your charts.

Key Points

Click on the chart to activate the Chart Tools on the Ribbon;
Use the + button to open the task pane to add or modify titles, legends, and data labels;
Add, remove, or modify chart elements like titles, legends and data labels.

Tarea

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.

Tarea

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.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 6. Capítulo 3

Elige tu plan

Customizing Chart Elements

This chapter focuses on tweaking and fine-tuning chart elements to better tell your data's story.

You'll learn how to add, remove, and modify components like titles, legends, and labels, enhancing the clarity and impact of your charts.

Key Points

Click on the chart to activate the Chart Tools on the Ribbon;
Use the + button to open the task pane to add or modify titles, legends, and data labels;
Add, remove, or modify chart elements like titles, legends and data labels.

Tarea

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.

Tarea

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.

Mark tasks as Completed

¿Todo estuvo claro?

Sección 6. Capítulo 3

Elige tu plan

Customizing Chart Elements

This chapter focuses on tweaking and fine-tuning chart elements to better tell your data's story.

You'll learn how to add, remove, and modify components like titles, legends, and labels, enhancing the clarity and impact of your charts.

Key Points

Click on the chart to activate the Chart Tools on the Ribbon;
Use the + button to open the task pane to add or modify titles, legends, and data labels;
Add, remove, or modify chart elements like titles, legends and data labels.

Tarea

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.

Tarea

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.

¿Todo estuvo claro?

This chapter focuses on tweaking and fine-tuning chart elements to better tell your data's story.

You'll learn how to add, remove, and modify components like titles, legends, and labels, enhancing the clarity and impact of your charts.

Key Points

Click on the chart to activate the Chart Tools on the Ribbon;
Use the + button to open the task pane to add or modify titles, legends, and data labels;
Add, remove, or modify chart elements like titles, legends and data labels.

Tarea

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.

Sección 6. Capítulo 3

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones