# 课程信息

657,541 次近期查看

## 13%

#### 初级

This Course is appropriate for anyone who is interested in learning about Microsoft Excel. You do not need previous experience with Excel.

### 您将获得的技能

GraphsMicrosoft ExcelChartSorting

## 13%

#### 初级

This Course is appropriate for anyone who is interested in learning about Microsoft Excel. You do not need previous experience with Excel.

1

# Critical Core of Excel

10 个视频 （总计 46 分钟）, 8 个阅读材料, 8 个测验
10 个视频
Week 1 Discussion3分钟
Practice Video: Taking Charge of Excel7分钟
Practice Video: Navigating and Selecting5分钟
Practice Video: View Options5分钟
Practice Video: Data Entry, Data Types, Editing and Deleting6分钟
Practice Video: Fill Handle5分钟
Week 1 Wrap-up1分钟
Copy and Paste5分钟
Templates2分钟
8 个阅读材料
Welcome to Excel Skills for Business: Essentials20分钟
Course goals and weekly learning objectives10分钟
Important information about versions and regions10分钟
Week 1: Practice Challenge20分钟
Week 1: Keyboard Shortcuts, Terminology, and Ninja Tips25分钟
Week 1: Excellent Tips and Resources25分钟
8 个练习
Are essential skills too basic for me?10分钟
Taking Charge of Excel10分钟
Navigating and Selecting10分钟
View Options10分钟
Data Entry10分钟
Fill handle10分钟
Taking Charge of Excel: Test your skills, Part 130分钟
Taking Charge of Excel: Test your skills, Part 220分钟
2

# Performing calculations

11 个视频 （总计 44 分钟）, 5 个阅读材料, 7 个测验
11 个视频
Week 2 Discussion4分钟
Practice Video: Formulas3分钟
Practice Video: Formulas in Context4分钟
Practice Video: Functions I: SUM and AUTOSUM4分钟
Practice Video: Functions II: AVERAGE, MIN and MAX4分钟
Discussion: Absolute Cell References4分钟
Practice Video: Absolute Cell References3分钟
Practice Video: Calculations across sheets4分钟
Week 2 Wrap-up1分钟
Excel Options6分钟
5 个阅读材料
Week 2: Practice Challenges1小时
Word Search Puzzle: Master ranges15分钟
Week 2: Keyboard Shortcuts, Terminology, and Ninja Tips25分钟
Week 2: Excellent Tips and Resources20分钟
7 个练习
Formulas6分钟
Formulas in Context6分钟
Functions I6分钟
Functions II6分钟
Absolute Cell References6分钟
Calculations across Sheets6分钟
3

# Formatting

10 个视频 （总计 40 分钟）, 4 个阅读材料, 7 个测验
10 个视频
Week 3 Discussion3分钟
Practice Video: Formatting3分钟
Practice Video: Borders3分钟
Practice Video: Alignment Tools4分钟
Practice Video: Format Painter3分钟
Practice Video: Number Formats5分钟
Practice Video: Styles and Themes5分钟
Week 3 Wrap-up1分钟
Graphics6分钟
4 个阅读材料
Week 3: Practice Challenge30分钟
Week 3: Keyboard Shortcuts and Ninja Tips10分钟
Week 3: Excellent Tips and Resources15分钟
7 个练习
Formatting8分钟
Borders8分钟
Alignment Tools8分钟
Format Painter12分钟
Number Formats8分钟
Styles and Themes5分钟
4

# Working with Data

9 个视频 （总计 35 分钟）, 3 个阅读材料, 6 个测验
9 个视频
Week 4 Discussion3分钟
Practice Video: Managing Rows and Columns4分钟
Practice Video: Find and Replace3分钟
Practice Video: Filtering6分钟
Practice Video: Sorting3分钟
Practice Video: Conditional Formatting5分钟
Week 4 Wrap-up1分钟
Accessibility5分钟
3 个阅读材料
Week 4: Practice Challenge30分钟
Week 4: Keyboard Shortcuts, Terminology, and Ninja Tips25分钟
6 个练习
Managing Rows and Columns10分钟
Find and Replace8分钟
Filtering8分钟
Sorting10分钟
Conditional Formatting15分钟
Working with Data: Test your skills30分钟
4.9

# 1641 条评论

### 来自Excel Skills for Business: Essentials的热门评论

The course was defiantly more than I expected. It not only strengthened what I did know about Excel but it showed me several options that I was not using or haven't found. I would highly recommend it.

A great course for beginners in MS Excel. Introduces one to the various functionalities that Excel has to offer. Course content and structure are excellent and helps one to learn at an optimal rate.

### Dr Yvonne Breyer

Program Director, Design and Experience, Global MBA

### 关于 麦考瑞大学

Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society....