Data Processing with Excel

8 Days Left! Get $70+ in savings and build skills with Coursera Plus. Save 40% for 3 months.

Data Processing with Excel

Instructor: You-Yu Lin

Included with Learn more

7 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

9 hours to complete

Flexible schedule

Learn at your own pace

7 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

9 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Become proficient in using Excel and apply its features to data formatting, calculation, filtering, analysis, and presenting results.

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 7 modules in this course

Data processing is essential in all research fields, and Excel is one of the most widely used general-purpose tools for data processing on personal computers. Through lectures and hands-on practice, this course introduces both fundamental and advanced Excel functions for data processing.

Students will learn the essential background knowledge, including supporting documentations, definitions of input, return and display values, and useful tools and hotkeys, essential for completion of this course.

What's included

5 videos

This module introduces Excel cell references, value types, formula auto-adjustment, and absolute references. It also covers key functions such as INDIRECT, ADDRESS, and INDEX.

What's included

7 videos1 reading1 assignment

7 videosTotal 58 minutes

2-1 Cell reference format7 minutes
2-2 Different types of values7 minutes
2-3 Different ways to input values into cells10 minutes
2-4 Copy/paste and auto-adjustment4 minutes
2-5 Absolute cell reference5 minutes
2-6 ROW, COLUMN, ADDRESS, and INDIRECT19 minutes
2-7 INDEX and OFFSET6 minutes

1 readingTotal 5 minutes

⚠️ Required Download: Course Dataset (MOOC_Excel_Question_Bank_Data.xlsx)5 minutes

1 assignmentTotal 30 minutes

W2 Quiz30 minutes

Students will learn the fundamentals of the conditional IF function and the logical TRUE/FALSE. This module will also introduce other conditional and logical functions, including AND, OR, and IFS, and essential concepts for parameter input.

What's included

6 videos1 assignment

This module introduces basic Excel statistical and mathematical functions, including COUNT, SUM, AVERAGE, LARGE, and RANK. Students will also learn how value of different types and array formulas affect calculations.

What's included

9 videos1 assignment

9 videosTotal 60 minutes

4-1 COUNT and value type conversion9 minutes
4-2 COUNTA, SUM, AVERAGE, AVERAGEA9 minutes
4-3 MEDIAN, MOD, MODE4 minutes
4-4 MODE.MULT and a peak into array formula7 minutes
4-5 MAX, MIN, LARGE, SMALL, RANK4 minutes
4-6 LARGE + AVERAGE + array formula combo4 minutes
4-7 ROUND, ROUNDUP, ROUNDDOWN, INT, ABS, MROUND6 minutes
4-8 Euler’s number e and π3 minutes
4-9 RAND, RANDBETWEEN12 minutes

1 assignmentTotal 30 minutes

W4 Quiz30 minutes

Students will learn to use conditional-based statistical functions such as COUNTIF, SUMIF, SUMIFS, and AVERAGEIFS. Students will be introduced to the limitations and exceptions of Excel.

What's included

5 videos1 assignment

This module introduces Excel lookup functions for finding and retrieving data from tables. Students will learn how to use VLOOKUP, LOOKUP, XLOOKUP, and MATCH+INDEX. The module also compares different lookup methods and their practical limitations.

What's included

6 videos1 assignment

Students will be introduced to Excel array formulas and their applications. Students will learn how arrays work and how to apply them with other functions.

What's included

9 videos1 assignment

9 videosTotal 64 minutes

7-1 What is an array5 minutes
7-2 Differences between 365/2021 and prior versions9 minutes
7-3 Array formula in practice6 minutes
7-4 Potential errors6 minutes
7-5 Incorporation into other functions14 minutes
7-6 INDEX+MATCH+array formula4 minutes
7-7 */+ instead of AND/OR6 minutes
7-8 TRUE/FALSE = 1/0 as filter instead of IF2 minutes
7-9 EXCEL is not perfect12 minutes

1 assignmentTotal 30 minutes

W7 Quiz30 minutes

Instructor

You-Yu Lin

National Taiwan University

0 Courses0 learners

Offered by

National Taiwan University

Explore more from Data Analysis

Coursera
Advanced Excel Data Processing and VBA Automation
Course
Status: Free trial
IBM
Excel Basics for Data Analysis
Course
Status: Free trial
Rice University
Introduction to Data Analysis Using Excel
Course
Status: Free trial
Corporate Finance Institute
Fundamentals of Data Analysis in Excel
Course
Status: Free trial

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Break down barriers to learning with big savings
Get Coursera Plus
Start with easy savings for hard-working teams
Save 30% today

Frequently asked questions

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.