1. Introduction to G Suite Certification: Sheets - Part 3
Playback speed:
Transcript
The Google G Suite is a set of cloud-based apps that can be used to create documents,spreadsheets, presentations, and more. Earning your G Suite certification demonstrates yourability to use digital skills to work collaboratively and productively in a professional environment.
Completing this lesson about Google Sheets will help prepare you for your G Suite certificationexam. For more practice, complete the first and second lessons in this series that usesGoogle Sheets. Spreadsheets are a common and versatile toolused to present information. You may be familiar with using spreadsheetsfor budgeting or project management, but there are many different ways to use a spreadsheet.
You could: Organize information, such as travel expensesor a shopping list, Create a tracker to manage the people andtasks for a project, Or keep a log of grades or assignments forschool or sales and invoices for a small business.
If you completed the first two Google Sheets lessons in the G Suite Certification series,you formatted a sheet containing raw data about shirts sold for a community fundraiser,then analyzed the data with filters, functions and charts. But spreadsheets aren’t justfor organizing and analyzing information. They are also useful tools for making calculationsand projections for a business or project. In this lesson, you willimport a spreadsheet in another file format into Google Sheets and combine your spreadsheetsto create a broader and more inclusive view of the sales data for the fundraiser,use functions to make calculations and summarize the data so you and your collaborators canscan the sheet quickly to find the necessary information,use conditional formatting to make specific details in your sheet stand out,and insert non-text elements, such as links and images, into your sheet, to make it moreuseful and interactive.
This lesson uses Google Sheets, but you can apply these concepts in any spreadsheet application.
To work on this lesson, sign in to your Google account. Open a new tab in your browser, andnavigate to Google.com. If you are not signed in, do so now.
If you do not have a Google account, pause the video and create one.
If you completed the second lesson in the G Suite Certification series, continue usingthe spreadsheet from that lesson. Open Google Drive, and find the file.
If not, use the starter project. Open the starter project and make a copy ofthe spreadsheet.
Remove the words “copy of” and add yourname to the title. Now, it’s your turn:Sign in to your Google account, Open Google Drive and find your spreadsheetfrom the previous lesson, Or, make a copy of the starter project,And update the title.
1. Introduction to G Suite Certification: Sheets - Part 3
2. Sheets: Copy Sheets Into Your Spreadsheet — Copy from .csv and .xls File Types
3. Sheets: Use Functions to Calculate Cost and Current Sales — Format Currency and View Function List
4. Sheets: Use Functions to Summarize Data and Calculate Profit
5. Sheets: Use the MIN, MAX, and AVERAGE Functions to Analyze Sales Data
6. Sheets: Add Conditional Formatting to Emphasize Data
7. Sheets: Insert Links, Images, Forms and Drawings