Understanding Excel

基础技能水平

更新时间 2026年4月

Master Excel basics quickly: navigate spreadsheets, apply formulas, analyze data, and create your first charts!

创建您的免费帐户

或

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

课程描述

New to Microsoft Excel? In this beginner course, you’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. The course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn how to use formulas in your data to provide new insights, and you'll create your first charts!

先决条件

本课程无先修要求

Getting started with Excel

Take your first steps in Excel! Learn how to open Excel files, copy and paste data, and write your first Excel formula.

Introduction to Excel

50 经验值

The possibilities of Excel

100 经验值

Navigating Excel

50 经验值

Loading workbooks

100 经验值

Working with data

100 经验值

Creating your first formula

100 经验值

开始章节

Data Analysis in Excel

Excel mainly is a data analysis tool. In this chapter, you'll get to apply basic formulae to summarize data. Additionally, you’ll learn how to create your first bar and line charts.

Aggregate and arithmetic operations

50 经验值

Averaging stock prizes

100 经验值

Counting the days

100 经验值

Visualizing data in Excel

50 经验值

Visualizing categories

100 经验值

Capturing a trend

100 经验值

开始章节

Understanding Excel

课程完成

获得成就证明

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

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

创建您的免费帐户

或

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

Understanding Excel

创建您的免费帐户

培训2人或更多？

课程描述

先决条件

Getting started with Excel

Data Analysis in Excel

获得成就证明

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

创建您的免费帐户

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

课程描述

获得成就证明

加入超过.css-nklxlk{color:var(--wf-brand--main, #03EF62);}19百万学习者，今天就开始Understanding Excel！

创建您的免费帐户

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

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