This course is part of the Everyday Excel Specialization

4.7
stars
225 ratings

Charlie Nuttelman

19,778 already enrolled

Offered By

Everyday Excel SpecializationUniversity of Colorado Boulder

About this Course

29,125 recent views

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2".  It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways).
Each learner must complete 3"warm-up" projects (chosen from 3), 3 intermediate projects (chosen from 6), and 3 main (more difficult) projects (chosen from 5).  The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds.

It is hoped that this project-based courses will dramatically reinforce the application of Excel tools, techniques, and functions to real-world projects.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 3 in the

Everyday Excel Specialization

Advanced Level

A working knowledge of Excel is required, including dynamic array functions (Office 365). It is recommended to take Parts 1 and 2 of Everyday Excel.

Approx. 14 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will learn

In this course, you'll apply Excel functions and tools to solving broad, somewhat open-ended problems through a wide variety of "guided" projects.

Skills you will gain

Data Management
Spreadsheet
Microsoft Excel
Real-world projects
computing

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 3 in the

Everyday Excel Specialization

Advanced Level

A working knowledge of Excel is required, including dynamic array functions (Office 365). It is recommended to take Parts 1 and 2 of Everyday Excel.

Approx. 14 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.9/5 (68 Ratings)

Charlie Nuttelman

Senior Instructor

Chemical and Biological Engineering

343,918 Learners

6 Courses

Offered by

University of Colorado Boulder

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

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week

Week 1

2 hours to complete

Introduction and General Course Information

2 hours to complete

2 videos (Total 7 min), 12 readings, 1 quiz

2 videos

Course Overview and Introduction6m

How to Switch Sessions of the Course46s

12 readings

Is This Course For You?10m

Subscribe to "Everyday Excel VBA" YouTube Channel!2m

Office 365 is Required For This Course!10m

Take Your Time!5m

For Mac Users10m

The Importance of a Course Certificate and the Future of Higher Education10m

Auditing the Course vs. Purchasing a Course Certificate10m

How to get help2m

If you enjoy Excel... you'll love VBA!10m

How to Unlock the Course Files10m

Opening macro-enabled workbooks10m

Course Files10m

1 practice exercise

Unlock Quiz for Course Files5m

Week

Week 2

3 hours to complete

WARM-UP PROJECTS (Choose Three)

3 hours to complete

7 videos (Total 31 min), 5 readings, 5 quizzes

7 videos

Nearest Eighth of an Inch Preview1m

World Bank Lookup Preview1m

Dynamic Amortization Schedule Hints and Preview9m

Introduction to Dynamic Array Functions8m

Longest Ladder Around the Corner Preview1m

Dynamic Temperature Lookup Preview1m

Introduction to Dynamic Array Functions8m

5 readings

Nearest Eighth of an Inch Problem Statement10m

World Bank Lookup Problem Statement10m

Dynamic Amortization Schedule Problem Statement10m

Longest Ladder Around the Corner Problem Statement10m

Dynamic Temperature Lookup Problem Statement10m

5 practice exercises

Nearest Eighth of an Inch Submission Quiz5m

World Bank Lookup Submission Quiz5m

Dynamic Amortization Schedule Submission Quiz5m

Longest Ladder Around the Corner Submission Quiz5m

Dynamic Temperature Lookup Submission Quiz30m

Week

Week 3

3 hours to complete

INTERMEDIATE PROJECTS (Choose Three)

Now that you're warmed up, let's transition to some more challenging projects! There are six possible projects for you to choose from for the Intermediate Projects, and you must complete three of them. The Sensitivity Analysis and Historical Weather Lookup (Part A) projects are perhaps the easier projects of the bunch, but the Dynamic Data Cleaning is not far behind. The Friday the 13th project is interesting but possibly a tad bit more challenging. The Bakery Shopping List and Dinner Sign-Up projects are somewhere in between. Have fun!

3 hours to complete

10 videos (Total 51 min), 6 readings, 6 quizzes

10 videos

How to Perform a Sensitivity Analysis11m

Sensitivity Analysis Hints and Preview2m

Friday the 13th Preview1m

Dynamic Data Cleaning Preview and Hints8m

Introduction to Dynamic Array Functions8m

Filtering for Multiple Criteria4m

Historical Weather Lookup (Part A) Preview2m

Bakery Shopping List Preview1m

Dinner Sign-Up preview1m

An Introduction to Dynamic Array Functions8m

6 readings

Sensitivity Analysis Problem Statement10m

Friday the 13th Problem Statement10m

Dynamic Data Cleaning Problem Statement10m

Historical Weather Lookup (Part A) Problem Statement10m

Bakery Shopping List Problem Statement10m

Dinner Sign-Up Problem Statement1m

6 practice exercises

Sensitivity Analysis Submission Quiz5m

Friday the 13th Submission Quiz5m

Dynamic Data Cleaning Submission Quiz5m

Historical Weather Lookup (Part A) Submission Quiz5m

Bakery Shopping List Submission Quiz30m

Dinner Sign-Up Submission Quiz5m

Week

Week 4

4 hours to complete

MAIN PROJECTS (Choose Three)

Now for the heart of the course - the Main Projects! You'll implement many of the techniques and tools that you've learned in Parts 1 and 2 of "Everyday Excel". These projects are more involved than the intermediate projects. However, in many cases I provide significant hints and suggestions (mainly through screencasts). Therefore, I "guide" you through these projects. You'll be left with a proud, well-earned sense of accomplishment after having done these projects! There are 5 projects to choose from, and you need to complete 3 of them. Good luck!

4 hours to complete

17 videos (Total 114 min), 5 readings, 5 quizzes

17 videos

Distance Calculator Preview3m

Dealing with Multiple Table Lookups9m

How to Reset Conditional Drop-Down Lists9m

Rental Center Inventory Preview4m

An Introduction to Dynamic Array Functions 8m

Dynamic Filtering for Multiple Constraints12m

How to Reset Conditional Drop-Down Lists9m

Matrix Approach to Regression, Part 16m

Matrix Approach to Regression, Part 27m

Real-Time Regression Preview2m

Dynamic Array Hints for Real-Time Regression 7m

How to Calculate Standard Error and Adjusted R-Squared7m

Amortization Schedule with Extra Payments, Part 110m

Amortization Schedule with Extra Payments, Part 26m

Amortization Schedule with Extra Payments Preview1m

Historical Weather Lookup (Part B) Preview2m

To Get You Pumped Up for VBA (Preview for My Specialization "Excel/VBA for Creative Problem Solving")3m

5 readings

Distance Calculator Problem Statement10m

Rental Center Inventory Problem Statement10m

Real-Time Regression Problem Statement10m

Amortization Schedule with Extra Payments Problem Statement10m

Historical Weather Lookup (Part B) Problem Statement10m

5 practice exercises

Distance Calculator Submission Quiz5m

Rental Center Inventory Submission Quiz5m

Real-Time Regression Submission Quiz5m

Amortization Schedule with Extra Payments Submission Quiz5m

Historical Weather Lookup (Part B) Submission Quiz30m

Reviews

4.7

54 reviews

5 stars
80.08%
4 stars
16.37%
3 stars
1.32%
2 stars
0.44%
1 star
1.76%

TOP REVIEWS FROM EVERYDAY EXCEL, PART 3 (PROJECTS)

by KRMay 14, 2021

Really good projects to evaluate what you learnt, some were very difficult to pass the grader although the project answer was correct and it took some time to get pass the grader.

by QMar 12, 2021

Very useful and informative, but I still don't see the honor on my certificate even after completing the honor part

by JMJun 10, 2021

Nice training and real life challenges. Well worth it!

by WIMay 22, 2022

I enjoyed this course. Would have been nice to have more interaction wiht the instructor as many of the projects needed further clairification to complete.

View all reviews

About the Everyday Excel Specialization

This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. 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.
Is financial aid available?
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.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Everyday Excel, Part 3 (Projects)

About this Course

What you will learn

Skills you will gain