Skip to main content
PRDV006: Spreadsheets II: Formatting and Functions
0%
Previous
Course Feedback Survey
General
Course Syllabus
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
Specialization Programs
Specialization Programs
MBA Degree Program
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
Specialization Programs
Collapse
Expand
Specialization Programs
MBA Degree Program
Help
Collapse
Expand
Getting Started
Help Center & FAQ
Expand all
Collapse all
Open course index
PRDV006: Spreadsheets II: Formatting and Functions
Course Feedback Survey
Course Feedback Survey
Course Feedback Survey
Completion requirements
Click on
Course Feedback Survey
to open the resource.
