Everyday Excel, Part 2
"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.
Buy Now AED 170.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- Duration 22 hours
- Course by University of Colorado Boulder
-
Offered by
About
"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.Modules
Welcome!
-
1
Videos
-
8
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Unlock quiz for Week 1 files
1
Discussions
- What about you?
1
Videos
- How to Switch Sessions of the Course
8
Readings
- 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
Screencasts
-
14
Videos
14
Videos
- 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
Quiz 1 and Assignment 1
-
2
Videos
-
3
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 1
- Assignment 1 submission
1
Discussions
- Assignment 1 discussion
2
Videos
- Assignment 1 preview and instructions
- More about the OFFSET function
3
Readings
- Quiz 1 solutions and explanations
- Assignment 1
- Week 2 Excel files
Screencasts
-
12
Videos
12
Videos
- 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
Quiz 2 and Assignment 2
-
1
Videos
-
4
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 2
- Assignment 2 submission
1
Discussions
- Assignment 2 discussion
1
Videos
- Assignment 2 preview and instructions
4
Readings
- Quiz 2 instructions
- Quiz 2 solutions and explanations
- Assignment 2
- Week 3 Excel files
Screencasts
-
8
Videos
8
Videos
- 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)
Quiz 3 and Assignment 3
-
2
Videos
-
4
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 3
- Assignment 3 submission
1
Discussions
- Assignment 3 discussion
2
Videos
- More about the OFFSET function
- Assignment 3 preview and instructions
4
Readings
- Quiz 3 instructions
- Quiz 3 solutions and explanations
- Assignment 3
- Week 4 files
Screencasts
-
11
Videos
11
Videos
- 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
Quiz 4 and Assignment 4
-
1
Videos
-
4
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 4
- Assignment 4 submission
1
Discussions
- Assignment 4 discussion
1
Videos
- Assignment 4 preview and instructions
4
Readings
- Quiz 4 instructions
- Quiz 4 solutions and explanations
- Assignment 4
- Week 5 Excel files
Screencasts
-
9
Videos
9
Videos
- 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)
Quiz 5 and Assignment 5
-
1
Videos
-
4
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 5
- Assignment 5 submission
1
Discussions
- Assignment 5 discussion
1
Videos
- Assignment 5 preview and instructions
4
Readings
- Quiz 5 instructions
- Quiz 5 solutions and explanations
- Assignment 5
- Be on the lookout for Part 3!
Auto Summary
"Everyday Excel, Part 2" is an engaging course designed for intermediate to advanced users, aiming to enhance Excel skills. Guided by Coursera, this 5-week course delves into advanced data management, financial calculations, and predictive regression models. Learners will utilize tools like Data Tables, Goal Seek, and Solver for practical, hands-on experience. With mastery quizzes and problem-solving assignments, the course promises to be both fun and thought-provoking, catering to a wide range of abilities. Subscription options include Starter, Professional, and Paid, making it accessible to a broad audience.
Charlie Nuttelman