About this Course

327,132 recent views

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

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

Approx. 24 hours to complete

English

Subtitles: English

What you will learn

  • Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.

  • Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).

  • Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).

  • Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables).

Skills you will gain

Data ManagementSpreadsheetMicrosoft ExcelProblem SolvingReal World

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

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

Approx. 24 hours to complete

English

Subtitles: English

Offered by

University of Colorado Boulder logo

University of Colorado Boulder

Syllabus - What you will learn from this course

Week
1

Week 1

5 hours to complete

Navigating Excel

5 hours to complete
19 videos (Total 116 min), 7 readings, 3 quizzes
19 videos
What will I learn in the course?6m
Week 1 preview5m
Basic features of Excel8m
Saving and opening files1m
Sheets, cells, rows and columns: Part 15m
Sheets, cells, rows and columns: Part 27m
Moving around the worksheet7m
Editing the worksheet4m
Cell formatting and conditional formatting8m
Auto Fill and Fill Series8m
OPTIONAL Example: Gantt Chart7m
Formats for numbers, dates, and times8m
Cell addressing modes8m
Naming cells and cell ranges6m
Introduction to VBA macros7m
Excel is smart! (Quick Analysis tool and Ideas tool)3m
Setting preferences in Excel5m
Assignment 1 preview and instructions2m
7 readings
The power of Microsoft Excel10m
The importance of a Course Certificate and the future of higher education5m
For Mac users5m
Week 1 Excel files10m
Quiz 1 solutions and explanations10m
Assignment 12h
Week 2 Excel files10m
3 practice exercises
Unlock quiz for Week 1 files2m
Quiz 130m
Assignment 1 submission
Week
2

Week 2

5 hours to complete

Expression Entry and Common Excel Functions

5 hours to complete
12 videos (Total 70 min), 3 readings, 2 quizzes
12 videos
Excel syntax and order of operations8m
Troubleshooting Excel formulas6m
Introduction to functions in Excel8m
Counting, summing, and averaging in Excel, Part 17m
Counting, summing, and averaging in Excel, Part 25m
Rounding and remainders9m
Examples: Rounding and remainders7m
Random numbers, combinations, and permutations6m
The CHOOSE function2m
OPTIONAL: The CONVERT function (for engineers and scientists)2m
Assignment 2 preview and instructions3m
3 readings
Quiz 2 solutions and explanations10m
Assignment 22h
Week 3 Excel files10m
2 practice exercises
Quiz 230m
Assignment 2 submission30m
Week
3

Week 3

5 hours to complete

More Excel functions

5 hours to complete
12 videos (Total 77 min), 3 readings, 2 quizzes
12 videos
Making named ranges dynamic6m
Previewing compatibility with earlier versions4m
IF, AND, and OR8m
Advanced logical functions in Excel10m
Flash Fill: Advantages and disadvantages4m
Text functions in Excel, Part 18m
Text functions in Excel, Part 27m
Excel's financial functions8m
Introduction to array formulas7m
Introduction to VBA user-defined functions4m
Assignment 3 preview and instructions2m
3 readings
Quiz 3 solutions and explanations10m
Assignment 32h
Week 4 Excel files10m
2 practice exercises
Quiz 330m
Assignment 3 submission30m
Week
4

Week 4

5 hours to complete

Managing Data

5 hours to complete
15 videos (Total 73 min), 3 readings, 2 quizzes
15 videos
Applying a filter6m
Using the FILTER function (Office 365)3m
Creating an Excel Table6m
Data validation and drop-down lists9m
Sorting data in Excel7m
The SORT and SORTBY functions (Office 365)2m
Example: Sorting by columns2m
Cleaning your data7m
Removing duplicates6m
Consolidating data4m
One-way lookup functions, Part 14m
One-way lookup functions, Part 25m
The XLOOKUP function2m
Assignment 4 preview and instructions2m
3 readings
Quiz 4 solutions and explanations10m
Assignment 42h
Week 5 Excel files10m
2 practice exercises
Quiz 430m
Assignment 4 submission30m

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • 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. If you only want to read and view the course content, you can audit the course for free.

  • You will be eligible for a full refund until two weeks after your payment date, or (for courses that have just launched) until two weeks after the first session of the course begins, whichever is later. You cannot receive a refund once you’ve earned a Course Certificate, even if you complete the course within the two-week refund period. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You’ll be prompted to complete an application and will be notified if you are approved. Learn more.

  • This Course doesn't carry university credit, but some universities may choose to accept Course Certificates for credit. Check with your institution to learn more. Online Degrees and Mastertrack™ Certificates on Coursera provide the opportunity to earn university credit.

More questions? Visit the Learner Help Center.