Products
-
Excel, Accelerated: Day of the week
CourseTask: Translate a date into the day of the week expressed as text Acceleration techniques: Function: RANDBETWEEN Function: DATE Function: WEEKDAY Technique: Fill Handle Object: Create a table Function: VLOOKUP Function: COLUMNS Time: 1:19
$4.99
-
Excel, Accelerated: Transform grid into dimensional database
CourseTask: Transform a grid into a dimensional database Context: Profit & Loss by property Acceleration techniques: Function: COUNTIF Technique: Absolute referencing ($A$1) Function: INDEX Function: MATCH Time: 2:21
$4.99
-
Excel, Accelerated: Eliminate balancing error
CourseTask: Eliminate a balancing error due to too many decimal places Context: SaasAnt accounting entry upload Acceleration techniques: Function: ROUND Technique: Double-click the Fill Handle to copy down Time: 1:11
$4.99
-
Excel, Accelerated: Dynamically link Word and Excel
CourseTime: 1:01 | Task: Dynamically link a Word doc to an Excel spreadsheet | Context: Office for Windows | Acceleration techniques: Paste Special
$4.99
-
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