Products
-
Excel, Accelerated: Change certain grades to other text
CourseTime: 0:51 | Task: Retain certain grades while changing others to specified text | Acceleration techniques: VLOOKUP, name a range
$4.99
-
Excel, Accelerated: Parse addresses
CourseTime: 2:16 | Task: Parse addresses from 1 cell into multiple cells| Acceleration techniques: Increment text cells which end with a number, RIGHT, LEFT, TEXT, Text-to-columns, TRIM
$4.99
-
Hangout: How to Use a Radio or Option Button in Excel
CourseTechnique: How to Use a Radio or Option Button in Excel | Why: Allows the user to see results based on the option selected | Step 1: Insert the Option from the Developer Tab | Step 2: Copy the Option Button for each choice | Step 3: Create a formula
$4.99
-
Excel, Accelerated: Rotating Assignments
CourseTime: 1:40 | Task: Assign employees to line items on a rotating basis | Acceleration techniques: Create and name a table, IF, VLOOKUP, COLUMNS
$4.99
-
Hangout: How to Use Formulas in Conditional Formatting in Excel
CourseTechnique: How to Use Formulas in Conditional Formatting in Excel | Why: Creates a simple and visual way to see errors | Step 1: Determine where conditional formatting is needed | Step 2: Create conditional formatting with a formula
$4.99
-
Excel, Accelerated: Reference an expanding database
CourseTime: 4:01 | Task: Summarize figures from multiple tabs | Acceleration techniques: Create and name a table, 3-D formulas, fence technique, SUM, SUMIF, EOMONTH
$4.99