"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)".
Offered By
Everyday Excel, Part 2
University of Colorado BoulderAbout this Course
63,996 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.
Intermediate Level
A knowledge of algebra will help for some of this course.
Approx. 21 hours to complete
English
Subtitles: English
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.
Intermediate Level
A knowledge of algebra will help for some of this course.
Approx. 21 hours to complete
English
Subtitles: English
Offered by
University of Colorado Boulder
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
Syllabus - What you will learn from this course
6 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!
6 hours to complete
16 videos (Total 127 min), 7 readings, 3 quizzes
16 videos
(OPTIONAL): Review of VLOOKUP, MATCH, INDEX, and OFFSET functions10m
Two-way lookups in Excel9m
Two-way conditional lookups9m
Finding the location of a maximum10m
Conditional drop-down lists (data validation)9m
Conditional formatting based on formula8m
Example: Conditional formatting to identify errors7m
Comparing lists9m
Example: Who hasn't signed up?6m
Managing duplicates, Part 18m
Managing duplicates, Part 210m
Example: Expiry dates7m
Most frequent text3m
Assignment 1 preview and instructions2m
More about the OFFSET function7m
7 readings
The Power of Microsoft Excel10m
The importance of a Course Certificate and the future of higher education10m
For Mac users10m
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
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
Customizing Excel for financial applications3m
Time value of money3m
Simple and compound interest, Part 19m
Simple and compound interest, Part 29m
Amortized loans5m
Using Excel to create an amortization schedule11m
Amortization schedule with extra payments2m
Effective vs. nominal interest rate9m
Savings accounts with payments and disbursements9m
Interest-only loans5m
Lines of credit9m
Assignment 2 preview and instructions1m
4 readings
Quiz 2 instructions2m
Quiz 2 solutions and explanations10m
Assignment 21h
Week 3 Excel files10m
2 practice exercises
Quiz 230m
Assignment 2 submission2m
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
Depreciation9m
Common depreciation methods, Part 19m
Common depreciation methods, Part 28m
Cash flows and net present value, Part 18m
Cash flows and net present value, Part 27m
Comparing alternatives8m
Internal rate of return (IRR)9m
More about the OFFSET function7m
Assignment 3 preview and instructions1m
4 readings
Quiz 3 instructions2m
Quiz 3 solutions and explanations10m
Assignment 32h
Week 4 files10m
2 practice exercises
Quiz 330m
Assignment 3 submission2m
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
Introduction to case studies8m
One-way Data Tables, Part 16m
One-way Data Tables, Part 27m
Two-way Data Tables6m
Example: Two-way Data Table2m
Goal Seek and Solver for targeting problems, Part 17m
Goal Seek and Solver for targeting problems, Part 25m
Solver for optimization problems4m
Using the Solver with constraints, Part 16m
Using Solver with constraints, Part 25m
Assignment 4 preview and instructions1m
4 readings
Quiz 4 instructions2m
Quiz 4 solutions and explanations10m
Assignment 41h 30m
Week 5 Excel files10m
2 practice exercises
Quiz 430m
Assignment 4 submission1h
Reviews
TOP REVIEWS FROM EVERYDAY EXCEL, PART 2
by FVJul 19, 2020
Good course. A few inaccuracies in terminology for finance, and the use of Imperial units of measurement (old feet, US gallons and others), are the shadows I can see from the bright picture.
by RWJul 15, 2020
Very well designed course. There are some very challenging assignments that really improved my understanding of excel. I'm looking forward to Part 3.
by MPJun 5, 2020
The learning experience is directly related to the challenge presented on course. Good content and quality assignments for all excel level users.
by SNJun 25, 2020
Excellent learning. Learnt lot of things. Thanks to the instructor. Only suggestion is to provide simple tasks at the end of each screen casts.
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 purchase the 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. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
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.
Will I earn university credit for completing the Course?
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.
