Products
-
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
-
Hangout: How to Use Formulas in Excel to Get Your Data Just Right
CourseTechnique: How to Use Formulas in Excel to Get Your Data Just Right | Why: Easily modify exported data so that it is useful | Step 1: Create a table with formula columns | Step 2: Paste raw data into your formatted table
$4.99