By the end of this project, you will create a Google Sheet that receives customer requests, tracks employee workload, and provides a small business with an overview of current project status and historical data for completed projects. You will learn how to create a custom form and use the data from the form to track requests, assign work to employees, and create a snapshot of current and past projects. Throughout the project you will leverage formulas to automate the Google Sheet in order to effectively and efficiently manage day to day operations.
By the end of this project, you will create a Google Sheet that receives customer requests, tracks employee workload, and provides a small business with an overview of current project status and historical data for completed projects. You will learn how to create a custom form and use the data from the form to track requests, assign work to employees, and create a snapshot of current and past projects. Throughout the project you will leverage formulas to automate the Google Sheet in order to effectively and efficiently manage day to day operations.
Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.
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.
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.