Course
Introduction to Excel
BasicSkill Level
Updated 09/2025Start Course for Free
Included withPremium or Teams
ExcelData Manipulation4 hr13 videos36 Exercises2,800 XP210K+Statement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Training 2 or more people?
Try DataCamp for BusinessCourse Description
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 insightsLearn 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.Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Identify Excel’s core components, including cells, worksheets, tables, formulas, and charts.
- Define and apply aggregation functions such as SUM, AVERAGE, and COUNT to analyze worksheet data.
- Recognize methods to format, manage, and validate data using named ranges, conditional formatting, and data validation rules.
- Differentiate between visualization options (e.g., bar, line, sunburst charts) and assess which is most appropriate for a dataset.
- Evaluate the role of formulas, cell references, and arithmetic operations in performing accurate calculations.
Prerequisites
There are no prerequisites for this course1
Getting started with Excel
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.
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
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.
Introduction to Excel
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance review
Included withPremium or Teams
Enroll NowFAQs
Join over 19 million learners and start Introduction to Excel today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.