About this Course

60,743 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

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 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 logo

University of Colorado Boulder

Syllabus - What you will learn from this course

Week
1

Week 1

6 hours to complete

Advanced Data Management

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
Week
2

Week 2

3 hours to complete

Excel for Financial Applications, Part 1

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
Week
3

Week 3

4 hours to complete

Excel for Financial Applications, Part 2

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
Week
4

Week 4

5 hours to complete

Case Studies and "What-If" Analyses

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

View all reviews

Frequently Asked Questions

  • 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.
  • 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.

More questions? Visit the Learner Help Center.