We may earn an affiliate commission when you visit our partners.
Charlie Nuttelman
"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.
Read more
"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.
Read more
"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.
Register for this course and see more details by visiting:
OpenCourser.com/course/im0gak/everyday
Here's a deal for you
Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Get offer
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.
Read more
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.
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause 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
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Practical excel application through projects
According to learners, "Everyday Excel, Part 3 (Projects)" is a highly practical and engaging capstone course that effectively builds upon prior Excel knowledge. Students particularly praise the real-world relevance of the projects, which allow for hands-on application of advanced Excel functions and techniques. Many found the course structure, with its choice of projects across difficulty levels, to be highly beneficial, leading to a strong sense of accomplishment. While some found the more challenging main projects to require significant effort, the instructor's guidance through screencasts was widely appreciated, making complex tasks manageable. This course is considered essential for solidifying Excel skills for professional use, though it assumes a foundational understanding from previous parts.
Diverse project topics appeal to a wide range of interests.
"The selection of projects was great; I could pick ones that aligned with my professional interests."
"It was nice to have a choice of projects so I could focus on areas that felt most relevant to my work or personal use."
"From math-focused to lookup tasks, the diversity in project topics kept things interesting throughout the course."
Projects allow for multiple solutions and creative problem-solving.
"The open-ended nature of the projects encouraged me to explore different ways to solve problems, which was fantastic for my learning."
"I liked that there wasn't just one right answer; it gave me the freedom to try different Excel functions to achieve the goal."
"This course truly tests your understanding by presenting problems that can be solved in various creative ways."
Projects increase in difficulty, building confidence.
"The progression from warm-up to main projects felt just right, allowing me to build confidence before tackling the harder ones."
"I enjoyed the challenge of the main projects; they pushed me to think critically and apply everything I’d learned."
"It was great to have options for different difficulty levels, and the intermediate projects were a perfect bridge to the main ones."
Helpful screencasts provide support for challenging tasks.
"The instructor’s screencasts were incredibly helpful, especially for the main projects where I needed a little extra guidance."
"Even when projects felt difficult, the hints and suggestions provided by the instructor made them achievable and rewarding."
"I felt well-supported throughout the course due to the clear instructions and supplementary videos from the instructor."
Reinforces Excel skills with real-world, hands-on projects.
"This course is a fantastic way to apply the concepts learned in Parts 1 and 2 to real-world scenarios. The projects are highly practical."
"I appreciated the variety of projects that helped me connect Excel theory to practical applications in my job."
"The hands-on projects were the strongest part of the course for me; they truly solidified my understanding of complex Excel functions."
Requires prior Excel understanding, ideally from Parts 1 & 2.
"This course absolutely requires a solid foundation in Excel; don't skip Parts 1 and 2 if you're not already proficient."
"I found myself revisiting previous concepts, so definitely make sure you are comfortable with earlier material before starting this part."
"While rewarding, this course isn't for absolute beginners and assumes familiarity with advanced Excel features."
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
Excel Resource Compilation
Show steps
Organize your notes, assignments, quizzes, and exams to enhance your understanding of the course material.
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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:
Financial Planner
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.
Operations Analyst
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.
Actuary
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.
Financial Analyst
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.
Risk 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.
Business 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.
Statistician
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.
Management Consultant
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.
Data Scientist
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.
Auditor
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.
Quantitative Analyst
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.
Data Analyst
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.
Business Intelligence 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.
Data Engineer
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.
Project Manager
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.
For more career information including salaries, visit:
OpenCourser.com/course/im0gak/everyday
Reading list
We've selected nine books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Everyday Excel, Part 3 (Projects).
Save
Focuses on using Excel for data analysis and modeling, including data preparation, statistical analysis, forecasting, and optimization. It provides practical examples and case studies.
A practical guide to data analysis using Excel, covering data cleaning, data manipulation, statistical analysis, and data visualization. It provides step-by-step instructions and real-world examples.
An introduction to Excel VBA programming, covering the basics of VBA, macros, and user-defined functions. It is suitable for beginners who want to automate tasks and extend the functionality of Excel.
Save
Covers various types of charts and graphs in Excel, including bar charts, line charts, pie charts, and scatter plots. It provides detailed instructions on creating, customizing, and interpreting charts and graphs to effectively communicate data.
A beginner-friendly guide to Microsoft Excel, covering the basics of creating, editing, and formatting spreadsheets, as well as performing basic calculations and data analysis. It is suitable for those who are new to Excel or need a refresher.
A comprehensive guide to using pivot tables and charts in Excel for data summarization, analysis, and visualization. It covers advanced techniques and best practices for creating effective and interactive pivot tables and charts.
Provides an introduction to Excel Power Query and Power BI for data transformation, data cleaning, and data visualization. It covers the basics of data modeling, data cleansing, and creating interactive reports and dashboards.
Covers advanced Excel techniques for data science, including data wrangling, data analysis, machine learning, and data visualization. It is suitable for those who want to use Excel for data science projects and build predictive models.
Save
Covers advanced Excel techniques for data modeling and analysis using PowerPivot and DAX. It provides a comprehensive guide to creating data models, writing DAX formulas, and building interactive reports and dashboards.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/im0gak/everyday
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Effort
4-5 weeks of study, 3-5 hours per week
Level
Advanced
Via
Coursera
Institution
University of Colorado Boulder
Instructor
Charlie Nuttelman
Language
English
Transcripts
Español
Français
Português
Deutsch
Italiano
中文
العربية
한국어
日本語
हिंदी
Nederlands
Svenska
Pусский
Türkçe
Polski
Ελληνικά
українська мова
magyar nyelv
Bahasa Indonesia
ไทย
қазақша
اُردُو,
فارسی
বাংলা
پښتو
آذربایجان دیلی
This course belongs to a
collection
called
Everyday Excel. It's comprised of three courses:
- Everyday Excel, Part 2
- Everyday Excel, Part 1
- Everyday Excel, Part 3 (Projects) (viewing)
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser