Skip to main content
HomeExcel

track

Excel Fundamentals

Gain the essential skills you need to use Excel, from preparing data to writing formulas and creating visualizations. No prior experience is required.
Start Track for Free

Included withPremium or Teams

ExcelReporting16 hours25,536

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Track Description

Excel Fundamentals

Unlock the power of one of the world’s most popular spreadsheet tools, Excel! Best of all, no prior experience or knowledge is required! Throughout this track, you’ll learn how to prepare, visualize and analyze data through hands-on exercises. You’ll learn valuable skills such as preparing your data for further analysis through features such as PivotTables, V-Lookups, and Excel formulas before creating presentation-ready visualizations and dashboards. You’ll then take advanced skills one step further by utilizing powerful features such as the What-if tool for sensitivity and scenario analysis before dipping into predictive analysis with the power of Excel’s forecasting features. By the end of this track, you’ll have gained the knowledge and skills to carry out analysis in Excel on real-world scenarios.

Prerequisites

There are no prerequisites for this track
  • Course

    1

    Introduction to Excel

    Master the Excel basics and learn to use this spreadsheet tool to conduct impactful analysis.

  • Course

    Understand how to prepare Excel data through logical functions, nested formulas, lookup functions, and PivotTables.

  • Course

    Learn how to create a range of visualizations in Excel for different data layouts, ensuring you incorporate best practices to help you build dashboards.

  • Course

    Learn how to analyze data with PivotTables and intermediate logical functions before moving on to tools such as what-if analysis and forecasting.

Excel Fundamentals
5 courses
Track
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll Now

FAQs

Join over 15 million learners and start Excel Fundamentals today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.