University of Colorado Boulder - Everyday Excel, Part 2
- Offered byCoursera
Everyday Excel, Part 2 at Coursera Overview
Duration | 22 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Everyday Excel, Part 2 at Coursera Highlights
- 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
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Intermediate Level A knowledge of algebra will help for some of this course.
- Approx. 22 hours to complete
- English Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish
Everyday Excel, Part 2 at Coursera Course details
- "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.
Everyday Excel, Part 2 at Coursera Curriculum
Advanced Data Management
How to Switch Sessions of the Course
Week 1 preview
(OPTIONAL): Review of VLOOKUP, MATCH, INDEX, and OFFSET functions
Two-way lookups in Excel
Two-way conditional lookups
Finding the location of a maximum
Conditional drop-down lists (data validation)
Conditional formatting based on formula
Example: Conditional formatting to identify errors
Comparing lists
Example: Who hasn't signed up?
Managing duplicates, Part 1
Managing duplicates, Part 2
Example: Expiry dates
Most frequent text
Assignment 1 preview and instructions
More about the OFFSET function
The Power of Microsoft Excel
The importance of a Course Certificate and the future of higher education
For Mac users
Week 1 Excel files
Quiz 1 solutions and explanations
Assignment 1
Week 2 Excel files
Unlock quiz for Week 1 files
Quiz 1
Assignment 1 submission
Excel for Financial Applications, Part 1
Week 2 preview
Customizing Excel for financial applications
Time value of money
Simple and compound interest, Part 1
Simple and compound interest, Part 2
Amortized loans
Using Excel to create an amortization schedule
Amortization schedule with extra payments
Effective vs. nominal interest rate
Savings accounts with payments and disbursements
Interest-only loans
Lines of credit
Assignment 2 preview and instructions
Quiz 2 instructions
Quiz 2 solutions and explanations
Assignment 2
Week 3 Excel files
Quiz 2
Assignment 2 submission
Excel for Financial Applications, Part 2
Week 3 preview
Depreciation
Common depreciation methods, Part 1
Common depreciation methods, Part 2
Cash flows and net present value, Part 1
Cash flows and net present value, Part 2
Comparing alternatives
Internal rate of return (IRR)
More about the OFFSET function
Assignment 3 preview and instructions
Quiz 3 instructions
Quiz 3 solutions and explanations
Assignment 3
Week 4 files
Quiz 3
Assignment 3 submission
Case Studies and "What-If" Analyses
Week 4 preview
Introduction to case studies
One-way Data Tables, Part 1
One-way Data Tables, Part 2
Two-way Data Tables
Example: Two-way Data Table
Goal Seek and Solver for targeting problems, Part 1
Goal Seek and Solver for targeting problems, Part 2
Solver for optimization problems
Using the Solver with constraints, Part 1
Using Solver with constraints, Part 2
Assignment 4 preview and instructions
Quiz 4 instructions
Quiz 4 solutions and explanations
Assignment 4
Week 5 Excel files
Quiz 4
Assignment 4 submission
Model Building in Excel
Week 5 preview
Trendlines, Part 1
Trendlines, Part 2
Linear interpolation
Model building, Part 1: Simple linear regression
Model building, Part 2: General linear regression
Model building, Part 3: Multilinear regression
(OPTIONAL) Why use adjusted R-squared and not R-squared?
Introduction to nonlinear regression (logisitic regression)
Assignment 5 preview and instructions
Quiz 5 instructions
Quiz 5 solutions and explanations
Assignment 5
Be on the lookout for Part 3!
Quiz 5
Assignment 5 submission
Everyday Excel, Part 2 at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?