Skip to main content
Side panel
Home
My Courses
Course Catalog
Help
Getting Started
Help Center & FAQ
Search
Close
Search
Toggle search input
Log in or Sign up
Home
My Courses
Course Catalog
Help
Getting Started
Help Center & FAQ
PRDV006: Spreadsheets II: Formatting and Functions (2021.A.01)
Sections
Course Introduction
Course Syllabus
Unit 1: Formatting Spreadsheets
Unit 2: Mathematical Computations
Unit 3: Logical and Lookup Functions
Unit 4: Lookup Functions
Unit 5: Multi-Page Spreadsheets
Course Feedback Survey
Certificate Final Exam
Resources
Activities
Quizzes
Home
My programs
My certificates
PRDV006: Spreadsheets II: Formatting and Functions (2021.A.01)
Home
Courses
(hidden)
(hidden)
PRDV006: Spreadsheets II: Formatting and Functions (2021.A.01)
Sections
Course Feedback Survey
Course Feedback Survey
Back to 'Course Feedback Survey\'
Course Feedback Survey
Click
https://saylordotorg.typeform.com/to/i5d5GmAo?utm_source=PRDV006&utm_medium=coursepage&utm_campaign=compsurvey
link to open resource.
Previous
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 in Microsoft Excel
Conditional Formatting in Microsoft Excel
Conditional Formatting in Google Sheets
Formulas, Relative References, Order of Operations, and Auditing Formulas
Order of Operations Review
Statistical Functions in Microsoft Excel
Statistical Functions in Google Sheets
Functions for Personal Finance
How to Calculate a Monthly Payment in Microsoft Excel
Freezing Panes
Logical Functions
Statistical IF Functions
Using COUNTIF, SUMIF, and AVERAGEIF in Microsoft Excel
Using IF, COUNTIF, and SUMIF in Google Sheets
Lookup Functions
VLOOKUP and HLOOKUP in Microsoft Excel
Web Queries
Creating a Web Query in Microsoft Excel
Using Goal Seek in Microsoft Excel
Printing in Formulas View
3D Formulas
Formulas Across Workbooks
PRDV006: Certificate Final Exam
Next