Learn to transform data into insightful visuals. Explore chart creation and formatting to effectively communicate your findings and enhance data-driven decision-making.

Introduction to Data Visualization

Different Types of Charts

Adding Data Labels

Additional Customizations for Charts

Creating and Formatting Sparklines

5. Managing Data

Efficiently manage and organize data within Excel. Discover techniques for data sorting, filtering, and handling large datasets with ease.

Creating and Managing Tables

Importing and Exporting Data

Working with Databases

Sorting and Filtering Data

6. Advanced Topics

Dive deep into Excel's advanced capabilities. Explore topics such as pivot tables, macros, and data analysis tools to elevate your Excel proficiency.

Using Pivot Tables

Visualizing Data with PivotCharts

Macros and VBA

Working with Large Datasets

Mathematical Functions

Let's consider some mathematical functions. In the second section, we already used the SUM function and made a custom formula for calculating percentage.

Task:

Calculate the area and circumference of circle given its radii.

Prepare Your Excel Sheet:
- Create a table with the first column labeled "Radius";
- Add two more columns labeled "Area" and "Circumference";
Enter Radii equal to 5;
In the "Area" column, use the formula: =PI() * POWER(A2, 2);
In the "Circumference" column, use the formula: = PI() * A2 * 2;
Additionally, you can round the results using the =ROUND() function.

Note
In different versions of Excel or Sheets, commas (,) are used to separate function arguments, while in other versions, semicolons (;) are expected. You can verify this in the syntax hints that appear when entering a formula.

1. What is the area of the circle with a radius equal to 5, rounded to two decimal places?

2. What is the circumference of the circle with a radius equal to 5, rounded to two decimal places?

¿Todo estuvo claro?

Sección 3. Capítulo 4

Contenido del Curso

Excel Beginner Course

1. Getting Started with Excel

What is Excel?The Excel Interface Entering Data Formatting Data Using Keyboard Shortcuts Printing Worksheets

2. Working with Formulas

Creating Formulas Relative, Absolute, and Mixed References Understanding Excel Errors

3. Working with Functions

Using Functions Different Types of Functions Debugging Formulas Mathematical Functions Statistical Functions Logical Functions

4. Creating and Formatting Charts

Introduction to Data Visualization Different Types of Charts Adding Data Labels Additional Customizations for Charts Creating and Formatting Sparklines