Everyday Excel, Part 2
University of Colorado Boulder
"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
About this Course
"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
What You'll Learn
- 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
Instructors
Charlie Nuttelman
Chemical and Biological Engineering