Course Summary
Everyday Excel Part 2 is a continuation of Everyday Excel Part 1. This course is designed to help you learn more complex Excel functions and formulas that will help you analyze data with ease.Key Learning Points
- Learn how to use advanced functions including INDEX and MATCH, VLOOKUP, and IFERROR
- Understand how to use conditional formatting to highlight important data
- Discover how to create pivot tables and charts to organize and visualize data
Related Topics for further study
Learning Outcomes
- Understand advanced Excel functions and formulas
- Create pivot tables and charts to visualize data
- Apply advanced formatting techniques to highlight important data
Prerequisites or good to have knowledge before taking this course
- Everyday Excel Part 1 or equivalent experience
- Microsoft Excel 2010 or later
Course Difficulty Level
IntermediateCourse Format
- Online
- Self-paced
Similar Courses
- Data Analysis with Excel
- Excel Skills for Business
Related Education Paths
- Data Analysis and Interpretation Specialization
- Excel to MySQL: Analytic Techniques for Business Specialization
Related Books
Description
"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)".
Knowledge
- 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
Outline
- 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
- 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
Summary of User Reviews
Read reviews of Everyday Excel Part 2 course on Coursera. Students loved how the course was structured and paced, making it easy to follow along. Many users found it to be a great way to learn Excel or brush up on their skills.Key Aspect Users Liked About This Course
Structured and paced in a way that is easy to follow alongPros from User Reviews
- Great for beginners or those looking to refresh their Excel skills
- Real-world examples and exercises help reinforce learning
- Instructors are knowledgeable and engaging
- Course materials are well-organized and easy to navigate
Cons from User Reviews
- Some users found the course to be too basic
- Not enough advanced topics covered
- Some users felt that the course could have been more interactive
- Videos can be a bit lengthy at times
- No certificate of completion offered
Charlie NuttelmanTop Instructor
4.9 Raiting
Emotional Intelligence Certification5 Management Coaching
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Emotional Intelligence Management Coaching Level 2 Grads Accredited Management Coaching Certification and Directory Why take a Certification Course to Become a Emotional Intelligence Management Coach?...
Decision Making with Excel for Managers
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Practical guide how to use Excel to make data driven, rational choices What is the aim of this course? Quite often this approach may be misleading....
Richard Schechner's Introduction to Performance Studies
- 4.9
-
![]()
![]()
![]()
![]()
![]()
Performance Studies: An Introduction explores the wide world of performance--from theatre, dance, and music to ritual, play, political campaigns, social media, and the performances of everyday life....
Analyze Data to Answer Questions
- 4.6
-
![]()
![]()
![]()
![]()
![]()
This is the fifth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs....
