Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel for Proposal Professionals
Introduction
Overall Introduction (0:28)
Introduction to Workbook (1:47)
Simple Outline
Overview of Simple Outline (3:33)
Simple Outline - Stoplight Data Validation (1:48)
Simple Outline - Stoplight Conditional Formatting (3:19)
Simple Outline - Outline Level Data Validation (1:10)
Simple Outline - Outline Level Conditional Formatting (2:31)
Simple Outline - Page Number Formatting (1:14)
Simple Outline - Calculating Page Count (3:17)
Simple Outline - Page Count Check Formula (3:05)
Simple Outline - Page Count Check Conditional Formatting (1:15)
Simple Outline - Page Count Check NPL Conditional Formatting (1:16)
Simple Outline - Page Count Check Examples (1:03)
Simple Outline - Hide and Unhide Columns (2:02)
Simple Outline - Freeze Top Row (1:07)
Simple Outline - Print Top Row (0:56)
Resume Tracking
Resume Tracking - Introduction (1:27)
Resume Tracking - Yes No Data Validation (1:52)
Resume Tracking - Stoplight Data Validation (0:47)
Resume Tracking - Yes No Conditional Formatting (3:03)
Resume Tracking - Stoplight Conditional Formatting (2:50)
Resume Tracking - Example (2:02)
Compliance Matrix
Compliance Matrix - Introduction (1:44)
Compliance Matrix - Data Validation (1:48)
Compliance Matrix - Conditional Formatting (1:30)
Past Performance Matrix
Past Performance Matrix - Introduction (0:20)
Past Performance Matrix - Overview of Information (2:05)
Past Performance Matrix - Vertical Text (0:41)
Past Performance Matrix - Data Validation for SOW Areas (1:04)
Past Performance Matrix - Level Data Validation (0:36)
Past Performance Matrix - Conditional Formatting for SOW Areas (1:37)
Past Performance Matrix - Level Conditional Formatting (1:53)
Past Performance Matrix - Average (3:02)
Past Performance Matrix - Average Conditional Formatting (1:44)
Conclusion
New Lecture (0:25)
Teach online with
Simple Outline - Calculating Page Count
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock