Everyday Excel, Part 3 (Projects) from Coursera

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways).

Each learner must complete 3"warm-up" projects (chosen from 3), 3 intermediate projects (chosen from 6), and 3 main (more difficult) projects (chosen from 5). The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds.

It is hoped that this project-based courses will dramatically reinforce the application of Excel tools, techniques, and functions to real-world projects.

What's inside

Syllabus

Introduction and General Course Information

This module contains introductory information regarding the course requirements, how to obtain a Course Certificate, and information for Mac users.

WARM-UP PROJECTS (Choose Three)

For the Warm-Up Projects, you must select three of five projects to complete. If you are more math-inclined, you might appreciate the "Nearest Eighth of an Inch" and "Ladder Around the Corner" projects. If you are not so math-inclined, you will gravitate towards the "World Bank Lookup", "Dynamic Temperature Lookup", and the "Dynamic Amortization Schedule" projects.

INTERMEDIATE PROJECTS (Choose Three)

Now that you're warmed up, let's transition to some more challenging projects! There are six possible projects for you to choose from for the Intermediate Projects, and you must complete three of them. The Sensitivity Analysis and Historical Weather Lookup (Part A) projects are perhaps the easier projects of the bunch, but the Dynamic Data Cleaning is not far behind. The Friday the 13th project is interesting but possibly a tad bit more challenging. The Bakery Shopping List and Dinner Sign-Up projects are somewhere in between. Have fun!

MAIN PROJECTS (Choose Three)

Now for the heart of the course - the Main Projects! You'll implement many of the techniques and tools that you've learned in Parts 1 and 2 of "Everyday Excel". These projects are more involved than the intermediate projects. However, in many cases I provide significant hints and suggestions (mainly through screencasts). Therefore, I "guide" you through these projects. You'll be left with a proud, well-earned sense of accomplishment after having done these projects! There are 5 projects to choose from, and you need to complete 3 of them. Good luck!

For Honors!

Are you chomping at the bit to apply more of your vast Excel knowledge to some more challenging problems?! If so, the Honors Certificate is for you! For Honors distinction on your Course Certificate, complete both projects. The two projects are Francesca's French Bakery and the Top Hat Consolidator. Peruse the information below for project descriptions and requirements for these two projects. Far fewer hints and tips are provided for these projects, so it is up to you to utilize what you've learned in these courses to solve these open-ended problems!

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches hands-on skills with tools that are standard in industry

Projects offer experience with a range of business applications

Develops skills that are useful for personal growth and development

Taught by instructors who have extensive experience in the field

Projects are complex and open-ended, allowing for creativity and innovation

Taught by Charlie Nuttelman, who is an adjunct professor at Duke University and was formerly a data analyst and product manager at Google

Reviews summary

High-quality excel projects

Learners say this course is a great opportunity to practice Excel skills on real-world projects. Challenging assignments in this course are engaging and fun, and students feel satisfied completing them. Students say earning an honor's certificate for completing these hands-on projects is worthwhile. Overall, students feel this course is well-received.

Excellent instructor who is knowledgeable and engaging

"Great professor, very rich courses, thanks you"

"I really enjoyed the course. The fact that you had to develop solutions with limited guidance was challenging at times and has helped a lot to make excel concepts more permanent and deeply understood. Good job Charlie!"

"A great conclusion to the trilogy. Charlie is a wonderful teacher and does a great job putting it all together."

Course is challenging but worthwhile for those looking to improve their Excel skills

"Very Challenging and satisfying at the same time. The explanations and techniques were concise and straight to the point."

"What can I say, incredible teacher! His teaching style is organized, thorough, engaging, and extremely challenging, to say the least."

"I enjoyed this course. Would have been nice to have more interaction wiht the instructor as many of the projects needed further clairification to complete. "

Course contains high-quality, challenging projects that mimic real-life work scenarios

"I found the excercises to be challenging, I enjoyed my way through the course and I put in practice several things I had learned in the previous courses, even more, I learned new things too!"

"This is the most exciting part of the course especially if you have completed the first two parts. The assignments are really interesting and allows a learner to use all their skills learned so far."

"The projects are very interactive and hands on, with just enough guidance to keep one on track!"

Office 365 is recommended but not required to complete the course

"Office 365 is required............."

"Very good course overall. I have to say that Office 365 is actually not required to finish the course."

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 3 (Projects) with these activities:

Excel Resource Compilation

Show steps

Organize your notes, assignments, quizzes, and exams to enhance your understanding of the course material.

Show steps

Gather all your course materials
Organize the materials by topic
Create a system for reviewing the materials regularly

Review Intermediate Excel

Show steps

Brush up on your Intermediate Excel skills from Part 2 to ensure you are ready for the projects.

Show steps

Review the syllabus for Part 2 of Everyday Excel
Complete the warm-up and intermediate projects from Part 2

Excel Practice Problems

Show steps

Complete practice problems to improve your proficiency in using Excel

Show steps

Find practice problems online or in textbooks
Solve the problems using Excel
Check your answers and identify areas for improvement

Five other activities

Expand to see all activities and additional details

Show all eight activities

Excel Project Tutorials

Show steps

Seek out and complete tutorials on more advanced Excel topics to solidify your understanding

Show steps

Search for tutorials on specific Excel functions or techniques
Follow along with the tutorials and complete the exercises
Apply the techniques you learned to your own projects

Excel Study Group

Show steps

Join or create a study group with other learners to discuss course concepts and work on projects together

Show steps

Find or create a study group
Meet regularly to discuss course material
Work together on projects and assignments
Provide feedback and support to each other

Excel Dashboard

Show steps

Create an Excel dashboard to visualize and analyze data relevant to your interests or field of study.

Show steps

Identify the data you want to visualize
Design the layout of your dashboard
Create charts and graphs to represent the data
Add interactivity to your dashboard (optional)

Excel Blog or Video Series

Show steps

Create a blog or video series to share your knowledge of Excel with others.

Show steps

Choose a topic or niche for your blog or video series
Create high-quality content that provides value to your audience
Promote your blog or video series to reach a wider audience

Excel Competition

Show steps

Participate in an Excel competition to test your skills and learn from others.

Show steps

Find an Excel competition that aligns with your interests
Prepare for the competition by practicing your skills and studying relevant materials
Compete in the competition and give it your best effort
Reflect on your performance and identify areas for improvement
Network with other participants and learn from their experiences

Career center

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

Operations Analyst

Operations Analysts use Excel for data analysis, process optimization, and performance management. The "Everyday Excel, Part 3 (Projects)" course provides a comprehensive overview of Excel functions and tools that are specifically relevant to operations analysis. Learners will gain hands-on experience in data analysis, process mapping, and scenario planning, which are key skills for Operations Analysts.

See salaries and explore the career path for Operations Analyst

Risk Analyst

Risk Analysts use Excel for data analysis, risk assessment, and mitigation planning. The "Everyday Excel, Part 3 (Projects)" course provides a comprehensive overview of Excel functions and tools that are specifically relevant to risk analysis. Learners will gain hands-on experience in data analysis, scenario planning, and risk reporting, which are key skills for Risk Analysts.

See salaries and explore the career path for Risk Analyst

Financial Planner

Financial Planners use Excel for financial planning, investment analysis, and retirement planning. The "Everyday Excel, Part 3 (Projects)" course provides a comprehensive overview of Excel functions and tools that are specifically relevant to financial planning. Learners will gain hands-on experience in financial modeling, scenario planning, and portfolio optimization, which are key skills for Financial Planners.

See salaries and explore the career path for Financial Planner

Actuary

Actuaries use Excel for financial modeling, risk analysis, and insurance pricing. The "Everyday Excel, Part 3 (Projects)" course provides a comprehensive overview of Excel functions and tools that are specifically relevant to actuarial science. Learners will gain hands-on experience in financial modeling, data analysis, and scenario planning, which are key skills for Actuaries.

See salaries and explore the career path for Actuary

Financial Analyst

Financial Analysts use Excel extensively for financial modeling, data analysis, and forecasting. The "Everyday Excel, Part 3 (Projects)" course provides a comprehensive overview of Excel functions and tools that are specifically relevant to financial analysis. Learners will gain hands-on experience in building financial models, performing sensitivity analysis, and creating dynamic dashboards, which are key skills for Financial Analysts.

See salaries and explore the career path for Financial Analyst

Business Analyst

Business Analysts use Excel for data analysis, process mapping, and project management. The "Everyday Excel, Part 3 (Projects)" course offers a practical approach to using Excel for these tasks. Learners will develop skills in data cleaning, data visualization, and project planning, which are essential for success in this role.

See salaries and explore the career path for Business Analyst

Business Intelligence Analyst

Business Intelligence Analysts use Excel for data analysis, data visualization, and reporting. The "Everyday Excel, Part 3 (Projects)" course provides a solid foundation in Excel, a tool that is widely used by Business Intelligence Analysts. Through hands-on projects, learners will develop proficiency in data manipulation, visualization, and analysis techniques, which are essential for success in this role.

See salaries and explore the career path for Business Intelligence Analyst

Auditor

Auditors use Excel for data analysis, risk assessment, and financial reporting. The "Everyday Excel, Part 3 (Projects)" course provides a solid foundation in Excel, a tool that is widely used by Auditors. Through hands-on projects, learners will develop proficiency in data manipulation, visualization, and analysis techniques, which are essential for success in this role.

See salaries and explore the career path for Auditor

Data Scientist

Data Scientists use Excel for data cleaning, data analysis, and machine learning. The "Everyday Excel, Part 3 (Projects)" course provides a solid foundation in Excel, a tool that is widely used by Data Scientists. Through hands-on projects, learners will develop proficiency in data manipulation, visualization, and analysis techniques, which are essential for success in this role.

See salaries and explore the career path for Data Scientist

Statistician

Statisticians use Excel for data analysis, statistical modeling, and hypothesis testing. The "Everyday Excel, Part 3 (Projects)" course provides a solid foundation in Excel, a tool that is widely used by Statisticians. Through hands-on projects, learners will develop proficiency in data manipulation, visualization, and analysis techniques, which are essential for success in this role.

See salaries and explore the career path for Statistician

Data Analyst

Data Analysts use their skills in data collection, analysis, and interpretation to solve complex problems and make informed decisions. The "Everyday Excel, Part 3 (Projects)" course from the University of Colorado Boulder provides a solid foundation in Excel, a tool that is widely used by Data Analysts. Through hands-on projects, learners will develop proficiency in data manipulation, visualization, and analysis techniques, which are essential for success in this role.

See salaries and explore the career path for Data Analyst

Data Engineer

Data Engineers use Excel for data extraction, transformation, and loading. The "Everyday Excel, Part 3 (Projects)" course provides a solid foundation in Excel, a tool that is widely used by Data Engineers. Through hands-on projects, learners will develop proficiency in data manipulation, data cleaning, and data integration techniques, which are essential for success in this role.

See salaries and explore the career path for Data Engineer

Quantitative Analyst

Quantitative Analysts use Excel for financial modeling, data analysis, and risk management. The "Everyday Excel, Part 3 (Projects)" course provides a solid foundation in Excel, a tool that is widely used by Quantitative Analysts. Through hands-on projects, learners will develop proficiency in data manipulation, visualization, and analysis techniques, which are essential for success in this role.

See salaries and explore the career path for Quantitative Analyst

Management Consultant

Management Consultants use Excel for data analysis, financial modeling, and project management. The "Everyday Excel, Part 3 (Projects)" course provides a solid foundation in Excel, a tool that is widely used by Management Consultants. Through hands-on projects, learners will develop proficiency in data manipulation, visualization, and analysis techniques, which are essential for success in this role.

See salaries and explore the career path for Management Consultant

Project Manager

Project Managers use Excel for project planning, budgeting, and tracking. The "Everyday Excel, Part 3 (Projects)" course provides a practical approach to using Excel for these tasks. Learners will develop skills in project scheduling, resource allocation, and risk management, which are essential for success in this role.

See salaries and explore the career path for Project Manager