跳至内容
首页Business Intelligence

学习路径

Excel Fundamentals

更新时间 2026年3月
Gain the essential skills you need to use Excel, from preparing data to writing formulas and creating visualizations. No prior experience is required.
免费开始学习路径
ExcelReporting16 小时83,799

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学习者的喜爱

Group

培训2人或更多？

试用DataCamp for Business

学习路径描述

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.

先决条件

此学习路径无先决条件

  • Course

    1

    Introduction to Excel

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

  • Course

    2

    Data Preparation in Excel

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

  • Course

    3

    Data Visualization in Excel

    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

    4

    Data Analysis in Excel

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

  • Skill Assessment

    额外

    Excel Fundamentals

Excel Fundamentals
5 课程
学习路径完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Excel Fundamentals ！

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。