Products
-
Excel, Accelerated: Format a number in a text string
CourseTime: 1:40 | Task:Format a number in a string which concatenates both text and numbers from cells in a database | Acceleration techniques: CONCAT, TEXT, TEXTJOIN
$4.99
-
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
-
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
-
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
-
Excel, Accelerated: T1S EA video - Amortization schedule with flexible accrued interest
CourseTime: 2:13 | Task: Calculate loan interest when payments are irregular | Acceleration techniques: ROUND, absolute referencing, create a table
$4.99