Products
-
Excel, Accelerated: Parse an address with a line break
CourseTime: 1:23 | Task: Parse a cell with a line break | Acceleration techniques: LEFT, RIGHT, LEN, FIND, CHAR, format painter
$4.99
-
Excel, Accelerated: Tiered sales commissions
CourseTime: 3:54 | Task: Automatically display a commission rate contingent on a value in another cell | Acceleration techniques: IF, IFS, VLOOKUP, XLOOKUP, AND, create and name a table
$4.99
-
Excel, Accelerated: Effect a currency conversion
CourseTime: 2:19 | Task: Effect a currency conversion | Acceleration techniques: Name a cell, ROUND, Paste Special > Formulas, GBP format, Group and Outline, Center Across Selection
$4.99
-
Excel, Accelerated: Extract key words from text
CourseTime: 2:45 | Task: Extract key words from text | Acceleration techniques: Table, Remove Duplicates, VLOOKUP, COLUMNS, XLOOKUP, RIGHT, LEN
$4.99
-
Excel, Accelerated: Subtotal columns which have header groupings
CourseTime: 1:27 | Task: Subtotal columns which have header groupings | Acceleration techniques: LEFT, FIND, SUMIF, absolute referencing for columns, rows, and both, Format Painter, Group and Outline
$4.99
-
Excel, Accelerated: Rent tracker
CourseTime: 4:00 | Task: Create a rent tracker with automation | Acceleration techniques: Table, PivotTable, EDATE, using a TRUE/FALSE column as a filter
$4.99