Products
-
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
-
Excel, Accelerated: Bank statement manipulation and categorization
CourseTime: 3:33 | Task: Manipulate and classify a list of transactions | Acceleration techniques: Table, VLOOKUP, split a column into 2 columns of debits and credits, Accumulate all records with specified text, remove duplicates, create a PivotTable
$4.99
-
Excel, Accelerated: Extract text from a cell
CourseTime: 4:01 | Task: Extract text from a cell | Acceleration techniques: CHAR, REPLACE, FIND, Text-to-columns, NUMBERVALUE, RIGHT, LEN
$4.99