Products
-
Excel, Accelerated: Sorting unusual values
CourseTime: 1:24 | Task: Sort non-alphabetically | Context: Tooling area | Acceleration techniques: Sort, COUNTIF, Absolute referencing ($A$1), Paste Values, Helper column
$4.99
-
Excel, Accelerated: What XLOOKUP replaces
CourseTime: 2:12 | Task: Look up a value using multiple criteria | Context: Professional impact and areas of specialty | Acceleration techniques: Create and name tables, resize a table, CONCAT, VLOOKUP
$4.99
-
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