Зміст курсу

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.

Завдання

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.

Завдання

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

Все було зрозуміло?

Секція 6. Розділ 3

Choose your 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.

Завдання

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.

Завдання

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

Все було зрозуміло?

Секція 6. Розділ 3

Choose your 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.

Завдання

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.

Завдання

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.

Все було зрозуміло?

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.

Завдання

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.

Секція 6. Розділ 3

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів