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
Course Syllabus
Sections
Unit 1: Formatting Spreadsheets
Unit 2: Mathematical Computations
Unit 3: Logical 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
Home
Courses
Course Catalog
Professional Development
PRDV006: Spreadsheets II: Formatting and Functions
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&typeform-source=learn.saylor.org
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
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
PRDV006: Certificate Final Exam
Next