## 课程信息

520,041 次近期查看

100% 在线

A knowledge of algebra will help for some of this course.

### 您将获得的技能

100% 在线

A knowledge of algebra will help for some of this course.

1

## Navigating Excel

19 个视频 （总计 116 分钟）, 8 个阅读材料, 3 个测验
19 个视频
What will I learn in the course?6分钟
Week 1 preview5分钟
Basic features of Excel8分钟
Saving and opening files1分钟
Sheets, cells, rows and columns: Part 15分钟
Sheets, cells, rows and columns: Part 27分钟
Moving around the worksheet7分钟
Editing the worksheet4分钟
Cell formatting and conditional formatting8分钟
Auto Fill and Fill Series8分钟
OPTIONAL Example: Gantt Chart7分钟
Formats for numbers, dates, and times8分钟
Naming cells and cell ranges6分钟
Introduction to VBA macros7分钟
Excel is smart! (Quick Analysis tool and Ideas tool)3分钟
Setting preferences in Excel5分钟
Assignment 1 preview and instructions2分钟
8 个阅读材料
The power of Microsoft Excel10分钟
I can't open the assignments nor starter .xlsx files - I thought the course was free?5分钟
The importance of a Course Certificate and the future of higher education5分钟
For Mac users5分钟
Week 1 Excel files10分钟
Quiz 1 solutions and explanations10分钟
Assignment 12小时
Week 2 Excel files10分钟
3 个练习
Unlock quiz for Week 1 files2分钟
Quiz 130分钟
Assignment 1 submission
2

## Expression Entry and Common Excel Functions

12 个视频 （总计 70 分钟）, 3 个阅读材料, 2 个测验
12 个视频
Excel syntax and order of operations8分钟
Troubleshooting Excel formulas6分钟
Introduction to functions in Excel8分钟
Counting, summing, and averaging in Excel, Part 17分钟
Counting, summing, and averaging in Excel, Part 25分钟
Rounding and remainders9分钟
Examples: Rounding and remainders7分钟
Random numbers, combinations, and permutations6分钟
The CHOOSE function2分钟
OPTIONAL: The CONVERT function (for engineers and scientists)2分钟
Assignment 2 preview and instructions2分钟
3 个阅读材料
Quiz 2 solutions and explanations10分钟
Assignment 22小时
Week 3 Excel files10分钟
2 个练习
Quiz 230分钟
Assignment 2 submission30分钟
3

## More Excel functions

12 个视频 （总计 77 分钟）, 3 个阅读材料, 2 个测验
12 个视频
Making named ranges dynamic6分钟
Previewing compatibility with earlier versions4分钟
IF, AND, and OR8分钟
Text functions in Excel, Part 18分钟
Text functions in Excel, Part 27分钟
Excel's financial functions8分钟
Introduction to array formulas7分钟
Introduction to VBA user-defined functions4分钟
Assignment 3 preview and instructions2分钟
3 个阅读材料
Quiz 3 solutions and explanations10分钟
Assignment 32小时
Week 4 Excel files10分钟
2 个练习
Quiz 330分钟
Assignment 3 submission30分钟
4

## Managing Data

15 个视频 （总计 73 分钟）, 3 个阅读材料, 2 个测验
15 个视频
Applying a filter6分钟
Using the FILTER function (Office 365)3分钟
Creating an Excel Table6分钟
Data validation and drop-down lists9分钟
Sorting data in Excel7分钟
The SORT and SORTBY functions (Office 365)2分钟
Example: Sorting by columns2分钟
Removing duplicates6分钟
Consolidating data4分钟
One-way lookup functions, Part 14分钟
One-way lookup functions, Part 25分钟
The XLOOKUP function2分钟
Assignment 4 preview and instructions2分钟
3 个阅读材料
Quiz 4 solutions and explanations10分钟
Assignment 42小时
Week 5 Excel files10分钟
2 个练习
Quiz 430分钟
Assignment 4 submission30分钟