Skip to main content
If you continue browsing this website, you agree to our policies:
Privacy Policy and Terms of Service
Continue
x
PRDV006: Spreadsheets II: Formatting and Functions
0%
Previous
Announcements
General
Course Syllabus
Announcements
Unit 1: Formatting Spreadsheets
1.1: Formatting Cells and Numbers
Formatting Cells in Microsoft Excel
Formatting Cells in Google Sheets
Formatting Special Data
Borders and Shading
1.2: Formatting Worksheet Tabs
Adding Tabs to a Workbook
Grouping Worksheets
1.3: Conditional Formatting
Conditional Formatting in Microsoft Excel
Conditional Formatting in Google Sheets
Unit 2: Mathematical Computations
2.1: Formulas
Creating Formulas
Order of Operations: PEMDAS
2.2: Statistical Functions
Statistical Functions in Microsoft Excel
Statistical Functions in Google Sheets
2.3: Functions for Personal Finance
Functions for Personal Finance
How to Calculate a Monthly Payment
Unit 3: Logical Functions
3.1: Logical Functions
Freezing Panes
Using the IF Function
The And Function
IF with AND and OR
3.2: Statistical IF Functions
Statistical IF Functions
COUNTIF, SUMIF, and AVERAGEIF in Microsoft Excel
IF, COUNTIF, and SUMIF in Google Sheets
Unit 4: Lookup Functions
4.1: Lookup Functions
Lookup Functions
The Benefits of XLOOKUP
VLOOKUP and HLOOKUP
4.2: Web Queries
Creating a Web Query
4.3: Goal Seek
Using Goal Seek
4.4: Printing Formulas and Functions
Printing in Formulas View
Unit 5: Multi-Page Spreadsheets
5.1: 3D Formulas
3D Formulas
5.2: Formulas Across Workbooks
Formulas Across Workbooks
Course Feedback Survey
Course Feedback Survey
Certificate Final Exam
PRDV006: Certificate Final Exam
Next
Side panel
Course Catalog
All categories
Arts & Humanities
Art History
Communication
English
Philosophy
Business Administration
Computer Science
English as a Second Language
Professional Development
General Knowledge for Teachers
Science and Math
Biology
Chemistry
Mathematics
Physics
Social Science
Economics
Geography
History
Political Science
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
Arts & Humanities
Art History
Communication
English
Philosophy
Business Administration
Computer Science
English as a Second Language
Professional Development
General Knowledge for Teachers
Science and Math
Biology
Chemistry
Mathematics
Physics
Social Science
Economics
Geography
History
Political Science
Psychology
Sociology
Home
Help
Collapse
Expand
Getting Started
Help Center & FAQ
Expand all
Collapse all
Open course index
PRDV006: Spreadsheets II: Formatting and Functions
Announcements
Announcements
Completion requirements
General news and announcements
Search forums
Search forums
(No announcements have been posted yet.)
Previous Activity
Jump to...
Jump to...
Course Syllabus
Formatting Cells in Microsoft Excel
Formatting Cells in Google Sheets
Formatting Special Data
Borders and Shading
Adding Tabs to a Workbook
Grouping Worksheets
Conditional Formatting in Microsoft Excel
Conditional Formatting in Google Sheets
Creating Formulas
Order of Operations: PEMDAS
Statistical Functions in Microsoft Excel
Statistical Functions in Google Sheets
Functions for Personal Finance
How to Calculate a Monthly Payment
Freezing Panes
Using the IF Function
The And Function
IF with AND and OR
Statistical IF Functions
COUNTIF, SUMIF, and AVERAGEIF in Microsoft Excel
IF, COUNTIF, and SUMIF in Google Sheets
Lookup Functions
The Benefits of XLOOKUP
VLOOKUP and HLOOKUP
Creating a Web Query
Using Goal Seek
Printing in Formulas View
3D Formulas
Formulas Across Workbooks
Course Feedback Survey
PRDV006: Certificate Final Exam
Next Section
