Business Operations Support in Google Sheets

4.7
stars
94 ratings
Offered By
Coursera Project Network
2,467 already enrolled
In this Guided Project, you will:

Create a form within Google Sheets

Write formulas to track organizational requirements

Summarize the data in order to make day-to-day organizational decisions

Clock1 week of study, 2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

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.

Skills you will develop

Data AnalysisBusiness OperationsGoogle Sheets

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Create a Google Form

  2. Enter Customer Data

  3. Use Formulas to Summarize Data

  4. Design a Summary Tab

  5. Complete a Summary Tab

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Reviews

TOP REVIEWS FROM BUSINESS OPERATIONS SUPPORT IN GOOGLE SHEETS

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.