Advanced formatting in a Google Sheet

1. Advanced formatting in a Google Sheet

Welcome to Module One, advanced formatting in a Google Sheet. There are many advanced formatting options that help you customize your Google Sheets and leverage your data. In this module, we're going to talk about applying themes and conditional formatting options. Google Sheets has themes that can be applied to change the format of an entire spreadsheet. To view the themes, open the Format menu and click Theme. The themes panel will open on the right side of the sheet. Click the theme to apply to the spreadsheet. Themes can also be customized. Choose a theme and then click the Customize button to view and change its font, text color, chart background color, accent colors, and hyperlink color. Changes to themes are specific to the spreadsheet where they are modified. You may consider creating a sheets template to be able to reuse your chosen formatting in a new spreadsheet. Individual cells can still be formatted after the theme has been applied. Conditional formatting is a Google Sheets feature that automatically applies cell formatting if the contents of a cell meets predefined criteria, known as format rules. Conditional formatting is advantageous, as the formatting is applied automatically and in real time. So as data is entered into a sheet, the formatting will instantly highlight important information, such as the results of data entry or calculations. This is true even in large datasets. Conditional formatting can also be used to ensure errors are minimized. For example, duplicate or inaccurate data could be highlighted for quick correction or removal. Let's take a closer look at conditional formatting now.

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 - Advanced Topics

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

There are many advanced formatting options that help you customize your Google Sheets and leverage your data. In this module, we are going to talk about applying themes and conditional formatting options.

Exercise 1: Advanced formatting in a Google Sheet

Current Exercise

Exercise 2: Conditional formatting Exercise 3: Activity 1 explained Exercise 4: Activity 1 Apply conditional formatting to a Google Sheet Exercise 5: Quiz Question 1 Exercise 6: Quiz Question 2

Formulas and functions allow you to make quick calculations and better use your data. Google Sheets supports many of the formulas found in other spreadsheet applications. In this module, we are going to look at creating a formula, using functions, and referencing and validating data. We will also discuss how using named ranges can assist you when working with data sets.

Exercise 1: Advanced formulas and functions Exercise 2: Using IF and IFS to analyze data Exercise 3: Activity 2 explained Exercise 4: Activity 2 Using the IFS function in Google Sheets Exercise 5: Data validation and named ranges Exercise 6: Activity 3 explained Exercise 7: Activity 3 Create a data validation rule and name a range Exercise 8: Quiz Question 1 Exercise 9: Quiz Question 2 Exercise 10: Quiz Question 3

Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all of that data can be difficult without a summary or visualization, especially when presenting the data to colleagues, partners, prospects, or clients. In this module, we are going to explore the data visualization options in Google Sheets, such as charts and pivot tables. We will discuss how Google Workspace integration makes it easy to share your charts and tables in Google Docs and Google Slides. We also look at ways to automate repetitive tasks using macros.

Exercise 1: Analyze and report Exercise 2: Exploring charts Exercise 3: Activity 4 explained Exercise 4: Activity 4 Create a chart using Google Sheets Exercise 5: Pivot tables Exercise 6: Create a pivot table Exercise 7: Activity 5 explained Exercise 8: Activity 5 Create a pivot table based on existing data Exercise 9: Integration and publishing in Google Sheets Exercise 10: Activity 6 explained Exercise 11: Activity 6 Explore publishing options Exercise 12: Macros Exercise 13: Apply a macro Exercise 14: Quiz Question 1 Exercise 15: Quiz Question 2 Exercise 16: Quiz Question 3 Exercise 17: Quiz Question 4 Exercise 18: Quiz Question 5 Exercise 19: Quiz Question 6

Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. In this module, we’re going to explore how Google Forms and Google Sheets work together by connecting collected form data to a spreadsheet, or by creating a form from an existing spreadsheet.

Exercise 1: Populate data using a Google Form Exercise 2: Activity 7 explained Exercise 3: Activity 7 Create a Google Form Exercise 4: Form settings and sharing a Google Form Exercise 5: Activity 8 explained Exercise 6: Activity 8 Share a Google Form Exercise 7: Managing feedback Exercise 8: Quiz Question 1 Exercise 9: Quiz Question 2 Exercise 10: Quiz Question 3 Exercise 11: Quiz Question 4

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 Exercise 2: Business challenge explained Exercise 3: Activity 9 Business challenge Exercise 4: Wrap up