Everyday Excel, Part 2 from Coursera

What's inside

Syllabus

Advanced Data Management

In Week 1 you will learn all about advanced data management strategies in Excel. These techniques include two-way look-ups, two-way conditional look-ups, how to find the maximum or minimum location in an array, conditional drop-down lists, advanced conditional formatting strategies, how to compare lists (for unique, duplicates, and absent items), advanced duplicate management, and how to work with expiry dates. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. For paid learners, the Week 2 Excel files will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!

Excel for Financial Applications, Part 1

In Weeks 2 and 3 you will learn all about advanced financial functions and applications in Excel. In Week 2, you will first learn about the concepts of and how to implement Excel formulas for the time value of money, simple and compound interest, and various loans (amortized, interest-only, and line of credit loans). You will learn how to create amortization schedules in Excel for these loans. Week 2 concludes with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 2, you will be given a "completion code", which you can input into the Assignment 2 submission quiz to earn credit for the assignment. For paid learners, the Week 3 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!

Excel for Financial Applications, Part 2

In Week 3, you will continue learning about advanced financial features of Excel. First, you will learn about depreciation and how to calculate depreciation and implement depreciation schedules in Excel. Next, you will learn about cash flows and net present value, and how to implement Excel functions to analyze cash flows. Then, you will learn how to compare financial alternatives. Finally, you'll learn about internal rate of return (IRR) and how to implement the IRR function in Excel. The week concludes with Quiz 3 and Assignment 3. When you successfully complete Assignment 3, you will be given a "completion code", which you can input into the Assignment 3 submission quiz to earn credit for the assignment. For paid learners, the Week 4 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!

Case Studies and "What-If" Analyses

One of the most valuable aspects of Excel is that it can be used nicely for case studies and "what-if" analyses. In Week 4, you'll learn about case studies, one-way and two-way data tables, and how to use the Goal Seek and Solver tools for targeting calculations. You'll also learn to use the Solver tool for optimization problems and problems for which you have constraints. The week concludes with Quiz 4 and Assignment 4. When you successfully complete Assignment 4, you will be given a "completion code", which you can input into the Assignment 4 submission quiz to earn credit for the assignment. For paid learners, the Week 5 Excel files will be released when you have successfully passed Quiz 4 and Assignment 4. Good luck!

Model Building in Excel

Week 5 of the course is all about creating mathematical models for experimental data. In this week, you'll first learn about how to insert trendlines into Excel plots and how to linearly interpolate between data points. Next, you'll learn about simple linear regression, general linear regression, and multilinear regression models and how to use Excel's Regression tool to create these regression models. The week concludes with an introduction to the logistic regression model, which is a type of nonlinear regression model. The week concludes with Quiz 5 and Assignment 5. When you successfully complete Assignment 5, you will be given a "completion code", which you can input into the Assignment 5 submission quiz to earn credit for the assignment. Then, you can pat yourself on the back for completing "Everyday Excel, Part 2!"

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Builds a foundation for intermediate users who want to strengthen their understanding and applications in MS Excel

Develops a mastery of fundamental to advanced techniques and tools in MS Excel, including data management, financial calculations, what-if analyses, and model building

Provides hands-on training through weekly assignments completed in-application on your own computer

Taught by Charlie Nuttelman, who is recognized for their work in the topic that the course teaches

Explores methods for case studies, what-if analyses, and financial modeling

Teaches practical applications of MS Excel in financial settings, including time value of money, loans, depreciation, and cash flow analysis

Reviews summary

Advanced everyday excel course

Learners say this is an engaging course with difficult exams. The lectures are well explained and cover various concepts from statistics, finance, and data analysis. The course also includes challenging assignments that help learners apply their knowledge. Overall, this is a well received course that can help learners improve their Excel skills.

Learners appreciate that the course uses real-world examples to illustrate the concepts.

"I have enjoyed both part 1 and part 2 of Every Day Excel. The screencasts are informative and easy to watch."

"I am really Thankful to the University of Colorado Boulder, especially Mr. Charlie Nuttelman."

"Very interesting and challenging course. I have learned so much more about Excel that I did not know before."

Learners note that the course covers finance and statistics concepts, which are useful for various fields.

" Great course, with in depth explanation of very topic which can be used in different fields such as engineering, finance, etc."

"It's very interesting course! It's challenging, so I wasn't bored even for one minute. And it's also useful, I brought some triks to my job."

"This part of the course mainly deals with financial functions, optimization (solver tool) and regression models."

Learners find the lectures to be well explained and easy to follow.

"Very Clearly explained! very good examples and exercises!"

"Excellent presentation of the information!"

"The learning experience is directly related to the challenge presented on course."

Learners appreciate the challenging assignments as they help them test their understanding of the concepts.

"The assignments are great and a good tool to test what you have learned."

"A very intricately designed course on the advanced functions of Excel."

"This course supplies transparent information that helps to provide financial and data analysises as well as presents new facts about INDEX, OFFSET, MATCH functions and DATA VALIDATION to create vivid automatic tables."

Learners highly praise the instructor's expertise and teaching style.

"Charlie is an AMAZING instructor - I learned a lot, and I wouldn't have if it weren't for his teaching style!"

"Amazing and wonderful and you can enjoy with assignments and quizzes and the instructor Explain well!"

"Charlie Nuttelman is the Excel guy. His explanations are great and clear."

Some learners find the content of the course to be difficult, especially in later weeks.

"Very Hard"

"This course is for mathematics, banking operations, and finance only"

"Horrible course. Instead of focusing on excel skills, it tries to confuse and toughen the course by using financial jargons and causing unnecessary confusions by using complicated interest rates with complex compounding periods."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Everyday Excel, Part 2 with these activities:

Review your high school level statistics knowledge

Show steps

Familiarizing yourself with basic statistical concepts will help you succeed in this course.

Browse courses on Statistics

Show steps

Review your notes and textbooks from your statistics class.
Take practice quizzes and tests to assess your knowledge.
Watch online videos or tutorials on basic statistical concepts.

Find a mentor who can guide you in your Excel journey

Show steps

Having a mentor who has experience with Excel can provide valuable insights and support.

Show steps

Identify individuals in your professional network or online communities who have expertise in Excel.
Reach out to them and express your interest in mentorship.
Set up regular meetings or calls to discuss your Excel goals and progress.

Complete practice exercises and assignments

Show steps

Regular practice will help you develop proficiency in using Excel and applying the concepts covered in this course.

Browse courses on Data Analysis

Show steps

Download the practice exercises and assignments provided by your instructor.
Work through the exercises and assignments step-by-step.
Check your answers against the provided solutions.
Seek help from your instructor or classmates if you encounter difficulties.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Create a cheat sheet of Excel formulas

Show steps

Creating a cheat sheet will help you memorize and quickly reference important Excel formulas.

Browse courses on Excel Formulas

Show steps

Gather a list of the most important Excel formulas.
Create a table or spreadsheet with the formulas and their descriptions.
Add examples and explanations to help you understand how each formula works.
Print or save your cheat sheet for easy reference.

Participate in peer study sessions

Show steps

Collaborating with peers will provide diverse perspectives and enhance your understanding of Excel concepts.

Show steps

Form a study group with classmates who are also taking this course.
Meet regularly to discuss course topics, work on projects together, and quiz each other.
Share your knowledge and help others understand difficult concepts.

Follow online tutorials to learn advanced Excel techniques

Show steps

Following tutorials will expose you to new and advanced Excel techniques that you can apply in this course.

Browse courses on Data Management

Show steps

Search for online tutorials on specific Excel topics that interest you.
Watch the tutorials and take notes on the steps and techniques demonstrated.
Practice applying the techniques in your own Excel workbooks.
Share your learnings and ask questions in online forums or discussion groups.

Participate in Excel competitions and challenges

Show steps

Participating in competitions will push you to apply your Excel skills in a competitive environment and learn from others.

Browse courses on Problem Solving

Show steps

Research and identify upcoming Excel competitions or challenges.
Register and prepare for the competition by practicing and honing your skills.
Participate in the competition and give your best effort.
Analyze your performance and identify areas for improvement.

Volunteer your Excel skills to non-profit organizations

Show steps

Applying your Excel skills to real-world projects can deepen your understanding and make a positive impact.

Show steps

Identify non-profit organizations that could benefit from Excel assistance.
Contact the organizations and offer your services.
Work with the organizations to understand their needs and develop Excel solutions.
Implement the solutions and provide training to the organization's staff.

Career center

Learners who complete Everyday Excel, Part 2 will develop knowledge and skills that may be useful to these careers:

Statistician

Statisticians use their skills in data analysis and interpretation to help businesses and organizations make informed decisions. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in data analysis and interpretation. You will learn how to use Excel to clean and organize data, perform statistical analysis, and create data visualizations. This course will also help you develop the problem-solving and critical thinking skills that are essential for success in this field.

See salaries and explore the career path for Statistician

Data Analyst

Data Analysts use their skills in data analysis and interpretation to help businesses make informed decisions. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in data management and analysis. You will learn how to use Excel to clean and organize data, perform statistical analysis, and create data visualizations. This course will also help you develop the problem-solving and critical thinking skills that are essential for success in this field.

See salaries and explore the career path for Data Analyst

Quantitative Analyst

Quantitative Analysts use their skills in mathematics and statistics to develop and implement financial models. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in financial modeling and analysis. You will learn how to use Excel to create and solve complex financial models, analyze risk, and make investment recommendations. This course will also help you develop the problem-solving and critical thinking skills that are essential for success in this field.

See salaries and explore the career path for Quantitative Analyst

Financial Analyst

Financial Analysts use their knowledge of finance and economics to assist businesses in making informed decisions about their investments. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in financial calculations and analysis. You will learn how to use Excel to create financial models, analyze cash flows, and perform "what-if" analyses. This course will also help you develop the problem-solving and critical thinking skills that are essential for success in this field.

See salaries and explore the career path for Financial Analyst

Actuary

Actuaries use their skills in mathematics and statistics to assess and manage risk. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in risk assessment and management. You will learn how to use Excel to create and solve actuarial models, analyze data, and make recommendations for risk mitigation. This course will also help you develop the problem-solving and critical thinking skills that are essential for success in this field.

See salaries and explore the career path for Actuary

Risk Manager

Risk Managers use their skills in risk assessment and management to help organizations identify and mitigate risks. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in risk assessment and management. You will learn how to use Excel to create and solve risk models, analyze data, and make recommendations for risk mitigation. This course will also help you develop the problem-solving and critical thinking skills that are essential for success in this field.

See salaries and explore the career path for Risk Manager

Business Analyst

Business Analysts use their skills in data analysis and interpretation to help businesses improve their performance. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in data management and analysis. You will learn how to use Excel to identify and solve business problems, develop process improvements, and make recommendations for change. This course will also help you develop the problem-solving and critical thinking skills that are essential for success in this field.

See salaries and explore the career path for Business Analyst

Investment Analyst

Investment Analysts use their skills in financial analysis and investment management to help individuals and institutions make informed investment decisions. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in financial analysis and investment management. You will learn how to use Excel to analyze financial statements, evaluate investment opportunities, and make investment recommendations. This course will also help you develop the interpersonal and communication skills that are essential for success in this field.

See salaries and explore the career path for Investment Analyst

Financial Planner

Financial Planners help individuals and families manage their finances and plan for their financial future. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in financial planning and analysis. You will learn how to use Excel to create financial plans, analyze investment options, and develop retirement strategies. This course will also help you develop the interpersonal and communication skills that are essential for success in this field.

See salaries and explore the career path for Financial Planner

Auditor

Auditors are responsible for examining and evaluating the financial records of organizations to ensure that they are accurate and compliant with regulations. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a deep understanding of accounting principles and financial analysis. You will learn how to use Excel to perform audits, analyze financial statements, and identify areas of risk. This course will also help you develop the attention to detail and analytical skills that are essential for success in this field.

See salaries and explore the career path for Auditor

Market Researcher

Market Researchers use their knowledge of market trends and consumer behavior to help businesses develop and market their products and services. The course "Everyday Excel, Part 2" can help you develop the skills necessary to succeed in this role by providing you with a solid foundation in data analysis and interpretation. You will learn how to use Excel to conduct market research surveys, analyze data, and create market forecasts. This course will also help you develop the communication and presentation skills that are essential for success in this field.

See salaries and explore the career path for Market Researcher

Data Scientist

Data Scientists use their skills in data analysis and interpretation to help businesses and organizations make informed decisions. The course "Everyday Excel, Part 2" can help you build a foundation for this role by providing you with a solid foundation in data management and analysis. You will learn how to use Excel to clean and organize data, perform statistical analysis, and create data visualizations. This course will also help you develop the programming skills that are essential for success in this field.

See salaries and explore the career path for Data Scientist

Machine Learning Engineer

Machine Learning Engineers use their skills in machine learning and artificial intelligence to develop and implement machine learning solutions. The course "Everyday Excel, Part 2" may be useful for this role by providing you with a foundation in data analysis and interpretation. You will learn how to use Excel to clean and organize data, perform statistical analysis, and create data visualizations. This course may also help you develop the programming skills that are essential for success in this field.

See salaries and explore the career path for Machine Learning Engineer

Web Developer

Web Developers use their skills in web design and development to create and maintain websites. The course "Everyday Excel, Part 2" may be useful for this role by providing you with a foundation in data analysis and interpretation. You will learn how to use Excel to clean and organize data, perform statistical analysis, and create data visualizations. This course may also help you develop the programming skills that are essential for success in this field.

See salaries and explore the career path for Web Developer

Software Engineer

Software Engineers use their skills in computer science and software development to design, develop, and maintain software applications. The course "Everyday Excel, Part 2" may be useful for this role by providing you with a foundation in data analysis and interpretation. You will learn how to use Excel to clean and organize data, perform statistical analysis, and create data visualizations. This course may also help you develop the programming skills that are essential for success in this field.

See salaries and explore the career path for Software Engineer