Skip to main content
If you continue browsing this website, you agree to our policies:
Privacy Policy and Terms of Service
Continue
x
PRDV007: Spreadsheets III: Presenting Data
0%
Previous
Course Feedback Survey
Course Syllabus
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
Next
Side panel
Course Catalog
All categories
Art History
Biology
Business Administration
Chemistry
Communication
Computer Science
Economics
English
English as a Second Language
General Knowledge for Teachers
Geography
History
Mathematics
Philosophy
Physics
Political Science
Pre-College Skills
Professional Development
Psychology
Sociology
Home
Help
Getting Started
Help Center & FAQ
Search
Search
Search
Search
Close
Toggle search input
You are currently using guest access
Log in
Course Catalog
Collapse
Expand
All categories
Art History
Biology
Business Administration
Chemistry
Communication
Computer Science
Economics
English
English as a Second Language
General Knowledge for Teachers
Geography
History
Mathematics
Philosophy
Physics
Political Science
Pre-College Skills
Professional Development
Psychology
Sociology
Home
Help
Collapse
Expand
Getting Started
Help Center & FAQ
Expand all
Collapse all
Open course index
PRDV007: Spreadsheets III: Presenting Data
Course Feedback Survey
Course Feedback Survey
Completion requirements
Click on
Course Feedback Survey
to open the resource.
Prev Section
Jump to...
Jump to...
Course Syllabus
Charts, Columns, Lines, and Pie Diagrams in Excel
Stacked Bar Charts in Excel
Line, Pie, Bar, and Grouped Bar Charts in Google Sheets
Present Data in a Chart in Excel
Choosing a Chart Type
Formatting Charts in Excel
Excel Charts
More on Excel Charts
The Scatter Chart
Graphing Scatter Graph in Excel
Scatter Plots in Google Sheets
Combo Charts in Excel
Sparklines in Excel
Sparklines in Google Sheets
Inserting Excel Shapes
Formatting Excel Shapes
Inserting Basic Pictures in Excel
Adding a Hyperlink
WordArt and Symbols
Excel Smartart
Conditional Formatting in Excel
Conditional Formatting in Google Sheets
Headers and Footers
Creating a Table
Excel Tables
Using Filters
Sorting PivotTables in Excel by Value
Convert to Range for Subtotaling
PivotTables in Excel
Slicers, Timelines, and PivotCharts
PivotTables in Google Sheets
Edit the Same File Together in Word, Excel, PowerPoint, OneDrive, and Teams
Managing Files and Folders in Google Drive
How to Protect Worksheets in Google Sheets
Protect Your Worksheet Cells and Still Allow Data Entry
Inserting Comments in Excel
Inserting Comments in Google Docs and Sheets
How to Use Power Automate Flow Conditions
Forms Live Integration in Excel
Features of Google Forms
Google Forms
Advanced Tips for Google Forms
PRDV007: Certificate Final Exam
Next Section