Everyday Excel, Part 2 by Coursera
Course Highlights
- 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 learn!
Curriculum
33 Topics
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
Auditing the course vs. purchasing a Course Certificate
What version of Excel do you need for this course?
For Mac users
How to get help
Opening macro-enabled workbooks
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
What about you?
Assignment 1 discussion
20 Topics
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
Assignment 2 discussion
17 Topics
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
Assignment 3 discussion
19 Topics
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
Assignment 4 discussion
17 Topics
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
Assignment 5 discussion
Everyday Excel, Part 2
Related Excel Courses
Thank You!
Your review has been submitted successfully.