Products
-
Excel, Accelerated: Consolidate multiple tabs
CourseTime: 2:09 | Task: Consolidate multiple tabs into a single database | Context: Investment account tracking | Acceleration techniques: VLOOKUP, MATCH, Single absolute referencing ($A1, A$1)
$4.99
-
Excel, Accelerated: Multi-criterial lookup for item costs, without XLOOKUP
CourseTime: 1:56 | Task: Look up item costs from a specific invoice number (without XLOOKUP) | Context:Sales line item report | Acceleration techniques: CONCAT, table objects, VLOOKUP, COLUMNS | Bonus! Creating sample data: CHOOSE, RANDBETWEEN
$4.99
-
Excel, Accelerated: Calculate run rate
CourseTime: 3:47 | Task: Calculate a run rate | Context: Monthly Profit & Loss report | Acceleration techniques: Driver cells, % number format, ROUND, Format Painter, SUBTOTAL
$4.99
-
Excel, Accelerated: Convert a Word list into a columnar Excel database
CourseTime: 2:16 | Task: Convert a Word list into a columnar Excel database | Context: Contact list | Acceleration techniques: ROW, CEILING.MATH, CONCAT, VLOOKUP, COLUMNS, 5 keyboard shortcuts, asymmetric absolute references
$4.99
-
Excel, Accelerated: Calculate totals for columns of different lengths
CourseTime: 2:04 | Task:Calculate totals for columns of different lengths | Context: List of values | Acceleration techniques: VBA: Insert a new module, create a macro, define a variable, select a cell, assign a value to a cell
$4.99
-
Excel, Accelerated: Calculate % change
CourseTime: 2:44 | Task: Calculate a % change | Context: Comparative numbers that are also a % of the whole | Acceleration techniques: Change the number of visible decimal places, % format, IFERROR, IF
$4.99