Rafał Alitojć has completed

# Introduction to Excel

4 hours
2,800 XP

## Getting started with Excel

In this Excel course, you’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn how to manage tables and apply calculations to your data to provide new insights

## Learn Functions

You’ll learn about the many available functions in Excel that can help you to perform calculations, analyze data and, in some cases, automate tasks. We’ll start your journey into understanding the full potential of Excel’s functions and leverage built-ins such as SUM, AVERAGE, COUNT, UPPER, LEFT, and more.

## Visualizing data

We’ll finish this course by explaining the basics of using Excel to effectively communicate data through compelling visuals. You’ll explore the versatility of area, column, and pie charts to help tell a story to bring your analysis to life.

### .css-1goj2uy{margin-right:8px;}Group.css-gnv7tt{font-size:20px;font-weight:700;white-space:nowrap;}.css-12nwtlk{box-sizing:border-box;margin:0;min-width:0;color:#05192D;font-size:16px;line-height:1.5;font-size:20px;font-weight:700;white-space:nowrap;}Training 2 or more people?

Try DataCamp for BusinessFor a bespoke solution book a demo.
1. 1

### Getting started with Excel

Free

In this chapter, you’ll learn how to navigate Excel and understand how best to work with tables. You will cover topics such as navigating the grid layout, importing data, manipulating data with tables, and creating basic formulas.

Play Chapter Now
Introduction to Excel
50 xp
The possibilities of Excel
100 xp
Navigating Excel
50 xp
100 xp
Working with data
100 xp
Creating first formula
100 xp
Working with tables
50 xp
Referencing cells
50 xp
Managing data with tables
50 xp
Working with structured cell references
100 xp
Filtering data
100 xp
LAST STEP INSTRUCTIONS Formatting tables
100 xp
2. 2

### Managing data and applying aggregate functions

In this chapter, you’ll learn how to work with data in a tabular layout. You will cover topics such as creating named ranges, using subtotals to summarize groups of data, and applying data validation rules. Additionally, you’ll learn how to use aggregate functions in Excel to help summarize your data.

3. 3

### Other functions and visualizing data

Finally, in this chapter, we’ll finish by looking at the various functions available within Excel and learn how to start visualizing basic data. You will cover text, date and time, statistical functions, and learning to use built-in Excel features to visualize your data.

### GroupTraining 2 or more people?

datasets

Excel Function TranslationsExercises and Datasets

collaborators

Jess Ahmet

Content Developer at DataCamp

Jess is a Content Developer at DataCamp. Prior to joining DataCamp, she worked in various analyst roles within healthcare and most recently online gambling. She has a passion for education, data, and business which she has been able to combine in her role at DataCamp. Outside of work, you can often find her in front of a TV watching Soccer and Formula 1.
See More