Products
-
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
-
Excel, Accelerated: Random sample
CourseTask: Generate a random sample Context: Accounts receivable database during financial statement audit Acceleration techniques: Function: RAND Function: ROUND Function: RANDBETWEEN Technique: F9 Technique: Remove Duplicates Time: 2:43
$4.99
-
Excel, Accelerated: Reconcile a bank statement
CourseTask: Reconcile a bank statement Context: Accounting ledger is in Excel Acceleration techniques: Object: Create a table Object: Name a table Technique: Name a range Function: SUMIFS Operator: <= (less than or equal to) Operator: & Time: 2:53
$4.99
-
Excel, Accelerated: Eliminate NA Error in VLOOKUP
CourseTask: Substitute 0 for the #N/A error in a VLOOKUP formula Context: Random database Acceleration techniques: Function: VLOOKUP Technique: Absolute referencing Function: IFERROR Time: 1:00
$4.99
-
Excel, Accelerated: Dynamically reference different tabs
CourseTask: Dynamically reference an identical cell in different tabs Context: Property management Acceleration techniques: Function: INDIRECT Operator: & Technique: Single and double apostrophes Technique: Double-click the Fill Handle Time: 2:16
$4.99