Learn Excel
Master the Excel basics and learn to use this spreadsheet tool to conduct impactful analysis.
Start Course for Free4 hours13 videos36 exercises81,323 learnersStatement 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.Training 2 or more people?
Try DataCamp for BusinessLoved by learners at thousands of companies
Course 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.For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Excel Fundamentals
Go To Track- 1
Getting started with Excel
FreeIn 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.
Introduction to Excel50 xpThe possibilities of Excel100 xpNavigating Excel50 xpLoading workbooks100 xpWorking with data100 xpCreating first formula100 xpWorking with tables50 xpReferencing cells50 xpManaging data with tables50 xpWorking with structured cell references100 xpFiltering data100 xpLAST STEP INSTRUCTIONS Formatting tables100 xp - 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.
Other functions in Excel50 xpTo the left, to the left50 xpApplying formatting functions50 xpProduct profiles100 xpProfit performance100 xpFormatting with functions100 xpVisualizing data in Excel50 xpDo you know the meaning of data viz?50 xpHow to visualize data50 xpVisualizing categories100 xpCapturing parts of a whole100 xpCapturing a trend100 xpCongratulations!50 xp
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Excel Fundamentals
Go To Trackcollaborators
Jess Ahmet
See MoreContent 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.
FAQs
Join over 14 million learners and start Learn 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.