PRDV007: Conditional Formatting in Google Sheets

STAGE - Never been refreshed - Debugging On

Watch this video on how to use conditional formatting to highlight data using Google Sheets.

Source: datalabcc, https://www.youtube.com/watch?v=wYlq714qyq0
This work is licensed under a Creative Commons Attribution 3.0 License.

Last modified: Monday, August 26, 2024, 11:15 AM

Course Introduction

Course Syllabus

Unit 1: Presenting Data with Charts

1.1: Types of Charts in Spreadsheet Programs

Charts, Columns, Lines, and Pie Diagrams in Excel

Stacked Bar Charts in Excel

Line, Pie, Bar, and Grouped Bar Charts in Google Sheets

1.2: Choosing a Chart Type

Present Data in a Chart in Excel

Choosing a Chart Type

1.3: Formatting Charts

Formatting Charts in Excel

Excel Charts

More on Excel Charts

Unit 2: More Work with Charts

2.1: The Scatter Chart

The Scatter Chart

Graphing Scatter Graph in Excel

Scatter Plots in Google Sheets

2.2: Combination Charts

Combo Charts in Excel

2.3: Sparklines

Sparklines in Excel

Sparklines in Google Sheets

Unit 3: Incorporating Graphics

3.1: Adding Shapes to Charts or Spreadsheets

Inserting Excel Shapes

Formatting Excel Shapes

Inserting Basic Pictures in Excel

3.2: Adding a Hyperlink

Adding a Hyperlink

3.3: WordArt, Symbols, and SmartArt

WordArt and Symbols

Excel Smartart

3.4: Conditional Formatting

Conditional Formatting in Excel

Conditional Formatting in Google Sheets

3.5: Headers and Footers

Headers and Footers

Unit 4: Tables

4.1: Creating and Formatting a Table

Creating a Table

Excel Tables

4.2: Sorting and Filtering Data

Using Filters

Sorting PivotTables in Excel by Value

4.3: Outlining Data

Convert to Range for Subtotaling

4.4: PivotTable and PivotChart

PivotTables in Excel

Slicers, Timelines, and PivotCharts

PivotTables in Google Sheets

Unit 5: Data Collaboration

5.1: Microsoft OneDrive and Google Drive

Edit the Same File Together in Word, Excel, PowerPoint, OneDrive, and Teams

Managing Files and Folders in Google Drive

5.2: Share and Protect

How to Protect Worksheets in Google Sheets

Protect Your Worksheet Cells and Still Allow Data Entry

5.3: Comments

Inserting Comments in Excel

Inserting Comments in Google Docs and Sheets

5.4: Power Automate or Microsoft Flow

How to Use Power Automate Flow Conditions

5.5: Forms

Forms Live Integration in Excel

Features of Google Forms

Google Forms

Advanced Tips for Google Forms

Course Feedback Survey

Course Feedback Survey

Certificate Final Exam

PRDV007: Certificate Final Exam