This course is part of the Everyday Excel Specialization

4.8
stars
483 ratings

Charlie Nuttelman

40,819 already enrolled

Offered By

Everyday Excel SpecializationUniversity of Colorado Boulder

About this Course

35,203 recent views

"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1".  Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel.  This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel.  By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)".
This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel.  In this course (Part 2), you will: 1) learn advanced data management techniques; 2) learn how to implement financial calculations in Excel; 3) use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses; 4) learn how to create mathematical predictive regression models using the Regression tool in Excel.

This course is meant to be fun and thought-provoking.  I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!"  Given the wide range in experience and abilities of learners, the goal of the course is to appeal to a wide audience.  The course is organized into 5 Weeks (modules). 

To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment.  This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

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 2 of 3 in the

Everyday Excel Specialization

Intermediate Level

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

Approx. 22 hours to complete

English

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

Try Coursera for Business

What you will learn

Advanced data management techniques
How to implement financial calculations in Excel
How to use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses
How to create mathematical predictive regression models using the Regression tool in Excel

Skills you will gain

Data Management
Spreadsheet
Microsoft Excel
Problem Solving
Real World

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 2 of 3 in the

Everyday Excel Specialization

Intermediate Level

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

Approx. 22 hours to complete

English

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

Try Coursera for Business

Instructor

Instructor rating

4.84/5 (164 Ratings)

Charlie Nuttelman

Senior Instructor

Chemical and Biological Engineering

351,352 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

Content Rating95%(2,662 ratings)

Week1

Week 1

7 hours to complete

Advanced Data Management

In Week 1 you will learn all about advanced data management strategies in Excel. These techniques include two-way look-ups, two-way conditional look-ups, how to find the maximum or minimum location in an array, conditional drop-down lists, advanced conditional formatting strategies, how to compare lists (for unique, duplicates, and absent items), advanced duplicate management, and how to work with expiry dates. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. For paid learners, the Week 2 Excel files will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!

7 hours to complete

17 videos (Total 127 min), 12 readings, 3 quizzes

17 videos

How to Switch Sessions of the Course46sWeek 1 preview5m(OPTIONAL): Review of VLOOKUP, MATCH, INDEX, and OFFSET functions10mTwo-way lookups in Excel9mTwo-way conditional lookups9mFinding the location of a maximum10mConditional drop-down lists (data validation)9mConditional formatting based on formula8mExample: Conditional formatting to identify errors7mComparing lists9mExample: Who hasn't signed up?6mManaging duplicates, Part 18mManaging duplicates, Part 210mExample: Expiry dates7mMost frequent text3mAssignment 1 preview and instructions2mMore about the OFFSET function7m

12 readings

The Power of Microsoft Excel10mSubscribe to "Everyday Excel VBA" YouTube Channel!2mThe importance of a Course Certificate and the future of higher education10mAuditing the course vs. purchasing a Course Certificate10mWhat version of Excel do you need for this course?10mFor Mac users10mHow to get help2mOpening macro-enabled workbooks10mWeek 1 Excel files10mQuiz 1 solutions and explanations10mAssignment 12hWeek 2 Excel files10m

3 practice exercises

Unlock quiz for Week 1 files2mQuiz 130mAssignment 1 submission

Week2

Week 2

3 hours to complete

Excel for Financial Applications, Part 1

In Weeks 2 and 3 you will learn all about advanced financial functions and applications in Excel. In Week 2, you will first learn about the concepts of and how to implement Excel formulas for the time value of money, simple and compound interest, and various loans (amortized, interest-only, and line of credit loans). You will learn how to create amortization schedules in Excel for these loans. Week 2 concludes with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 2, you will be given a "completion code", which you can input into the Assignment 2 submission quiz to earn credit for the assignment. For paid learners, the Week 3 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!

3 hours to complete

13 videos (Total 82 min), 4 readings, 2 quizzes

13 videos

Week 2 preview2mCustomizing Excel for financial applications3mTime value of money3mSimple and compound interest, Part 19mSimple and compound interest, Part 29mAmortized loans5mUsing Excel to create an amortization schedule11mAmortization schedule with extra payments2mEffective vs. nominal interest rate9mSavings accounts with payments and disbursements9mInterest-only loans5mLines of credit9mAssignment 2 preview and instructions1m

4 readings

Quiz 2 instructions2mQuiz 2 solutions and explanations10mAssignment 21hWeek 3 Excel files10m

2 practice exercises

Quiz 230mAssignment 2 submission2m

Week3

Week 3

4 hours to complete

Excel for Financial Applications, Part 2

In Week 3, you will continue learning about advanced financial features of Excel. First, you will learn about depreciation and how to calculate depreciation and implement depreciation schedules in Excel. Next, you will learn about cash flows and net present value, and how to implement Excel functions to analyze cash flows. Then, you will learn how to compare financial alternatives. Finally, you'll learn about internal rate of return (IRR) and how to implement the IRR function in Excel. The week concludes with Quiz 3 and Assignment 3. When you successfully complete Assignment 3, you will be given a "completion code", which you can input into the Assignment 3 submission quiz to earn credit for the assignment. For paid learners, the Week 4 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!

4 hours to complete

10 videos (Total 73 min), 4 readings, 2 quizzes

10 videos

Week 3 preview2mDepreciation9mCommon depreciation methods, Part 19mCommon depreciation methods, Part 28mCash flows and net present value, Part 18mCash flows and net present value, Part 27mComparing alternatives8mInternal rate of return (IRR)9mMore about the OFFSET function7mAssignment 3 preview and instructions1m

4 readings

Quiz 3 instructions2mQuiz 3 solutions and explanations10mAssignment 32hWeek 4 files10m

2 practice exercises

Quiz 330mAssignment 3 submission2m

Week4

Week 4

5 hours to complete

Case Studies and "What-If" Analyses

One of the most valuable aspects of Excel is that it can be used nicely for case studies and "what-if" analyses. In Week 4, you'll learn about case studies, one-way and two-way data tables, and how to use the Goal Seek and Solver tools for targeting calculations. You'll also learn to use the Solver tool for optimization problems and problems for which you have constraints. The week concludes with Quiz 4 and Assignment 4. When you successfully complete Assignment 4, you will be given a "completion code", which you can input into the Assignment 4 submission quiz to earn credit for the assignment. For paid learners, the Week 5 Excel files will be released when you have successfully passed Quiz 4 and Assignment 4. Good luck!

5 hours to complete

12 videos (Total 67 min), 4 readings, 2 quizzes

12 videos

Week 4 preview2mIntroduction to case studies8mOne-way Data Tables, Part 16mOne-way Data Tables, Part 27mTwo-way Data Tables6mExample: Two-way Data Table2mGoal Seek and Solver for targeting problems, Part 17mGoal Seek and Solver for targeting problems, Part 25mSolver for optimization problems4mUsing the Solver with constraints, Part 16mUsing Solver with constraints, Part 25mAssignment 4 preview and instructions1m

4 readings

Quiz 4 instructions2mQuiz 4 solutions and explanations10mAssignment 41h 30mWeek 5 Excel files10m

2 practice exercises

Quiz 430mAssignment 4 submission1h

Reviews

4.8

126 reviews

5 stars
84.29%
4 stars
11.98%
3 stars
2.06%
1 star
1.65%

TOP REVIEWS FROM EVERYDAY EXCEL, PART 2

by WMAug 12, 2022

I have enjoyed both part 1 and part 2 of Every Day Excel. The screencasts are informative and easy to watch. I am looking forward to part 3!

by CPNov 2, 2020

Buen curso, aprendes el uso de funciones para el manejo de datos avanzado y métodos financieros. Thank you so much.

by HTNov 25, 2020

A very intricately designed course on the advanced functions of Excel. The expertise of the instructor is visible in his teachings and explanations! Enjoyed the course very much!

by MAOct 7, 2020

This part of the training was little dificult as Stats are not used by me regularly. The stat concepts were also learned in this session

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 2

About this Course

What you will learn

Skills you will gain