Business challenge overview

1. Business challenge overview

Now it's time to put everything you've learned into practice. Before you get started, let's remind ourselves of the business challenge. Over the last year, as On The Rise has grown, the size of its employee base has increased significantly. Local stores have been advertising for employees to keep up with both bakery production and customer service demand. The On The Rise leadership team has received several memos from store owners around the world, asking for help as they search for new employees. In one of the leadership meetings, the bakery owners, Thomas Omar and Saroja Malone turned to the head of HR and Employee Development, Sherrie West, and asked her to provide an up-to-date summary of the number of employment openings and a forecast for upcoming job vacancies. Sherrie West has contacted you to help her organize the data she has collected from the various regions. She hopes that by analyzing the numbers, you can help her understand the current employment situation. In the following activity, you'll help Sherrie West and the On The Rise team solve their business challenge using Google Sheets. Good luck.

2. Let's practice!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

This exercise is part of the course

Google Workspace End User: Google Sheets

BeginnerSkill Level

5.0+

Start Course for Free

This module covers the agenda. It also introduces students to On the Rise and the course business challenge.

Exercise 1: Course introduction Exercise 2: Agenda

In this module, we will introduce Google Sheets and discuss how to open and create a new spreadsheet. We will also look at importing an existing spreadsheet into Google Sheets.

Exercise 1: Introduction to Google Sheets Exercise 2: Activity 1 explained Exercise 3: Activity 1 Import an Excel spreadsheet to Google Sheets Exercise 4: Quiz Question 1 Exercise 5: Quiz Question 2

In this module, we will talk about adding and organizing data with Google Sheets. You will learn how to add, paste and import data. You will also learn how to sort and filter data in your spreadsheets which is especially useful when working with large datasets.

Exercise 1: Manage data using Google Sheets Exercise 2: Activity 2 explained Exercise 3: Activity 2 Manage data in Google Sheets Exercise 4: Quiz Question 1 Exercise 5: Quiz Question 2

In this module, we will explore some of the ways you can format your spreadsheets. This includes some of the basic formatting options, such as cell colors and text wrapping, and options to freeze cells and protect data in your Google Sheet.

Exercise 1: Format a Google Sheets spreadsheet Exercise 2: Format a Sheet Exercise 3: Cell types, rows and columns Exercise 4: Activity 3 explained Exercise 5: Activity 3 Apply formatting to a Google Sheet Exercise 6: Manage multiple sheets Exercise 7: Quiz Question 1 Exercise 8: Quiz Question 2

In this module, we will look at creating a basic formula, using functions, named ranges and referencing data. You will also learn how to create a chart, and be introduced to Google Explore, a powerful tool that can be used to answer questions and make suggestions based on insights gained from your data.

Exercise 1: Basic formulas, functions, and charts Exercise 2: Basic functions Exercise 3: Activity 4 explained Exercise 4: Activity 4 Use formulas to perform calculations Exercise 5: Summarize data with charts Exercise 6: Create a chart Exercise 7: Import, export, date types, and more Exercise 8: Activities 5 and 6 explained Exercise 9: Activity 5 Use named ranges Exercise 10: Activity 6 Create a chart Exercise 11: Quiz Question 1

In this module, we will look at the different ways to share your spreadsheets with others. You will learn how to add collaborators and assign them roles and permissions, and also learn how you can share your Google Sheets spreadsheet with a link. You will understand how to transfer ownership of your spreadsheets to another collaborator, track changes, and manage versions.

Exercise 1: Share your Google Sheets spreadsheets Exercise 2: Activity 7 explained Exercise 3: Activity 7 Explore sharing options Exercise 4: Quiz Question 1 Exercise 5: Quiz Question 2

In this module, we will look at some of the collaboration options available to you with Google Sheets. Examples include commenting, action items, and notifications.

Exercise 1: Collaborate with Google Sheets Exercise 2: Activity 8 explained Exercise 3: Activity 8 Comments and action items Exercise 4: Chat and Gmail integration Exercise 5: Quiz Question 1 Exercise 6: Quiz Question 2 Exercise 7: Quiz Question 3

In this module, you will put everything you have learned into practice by helping our fictional Google Workspace customer solve their business challenge.

Exercise 1: Business challenge overview

Current Exercise

Exercise 2: Business challenge explained Exercise 3: Activity 9 Business challenge Exercise 4: Wrap up