Products
-
Excel, Accelerated: Spreadsheet update from other spreadsheet
CourseAcceleration techniques include: Programming a macro with open & close workbook, disable screen updating, create a formula, create a variable, autofill, paste formulas
$4.99
-
Excel, Accelerated: Combine contact lists
CourseAcceleration techniques include: Tables, VLOOKUP, FIND, IFERROR, IF, ISERROR, LEFT, Remove Duplicates
$4.99
-
Excel, Accelerated: Separate single-cell multi-line addresses into columns
CourseAcceleration techniques include: CHAR, FIND, REPLACE, Text-to-Columns
$4.99
-
Excel, Accelerated: Troubleshoot a Clearing Account
CourseAcceleration techniques include: Sort, Subtotal, Group and Outline
$4.99
-
Excel, Accelerated: Total Amounts from Pick List
CourseTask: Total values by category Context: A budget vs. actual summary by category Acceleration techniques: Function: SUMIF Technique: Absolute referencing Object: Create a table Object: Name a table Technique: In-cell drop-down list Time: 3:47
$4.99
-
Excel, Accelerated: Get vendor name from bank export
CourseTask: Get vendor name from bank export Context: Exported transactions from a bank account Acceleration techniques: Function: RIGHT Function: LEN Technique: Text to Columns Technique: Sort Time: 3:18
$4.99