Products
-
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
-
Excel, Accelerated: PivotTable and VLOOKUP basics
CourseTask: Summarize detailed information and consult a reference table Context: Random data Acceleration techniques: * Object: PivotTable * Keyboard shortcut: Ctrl+Shift+4 * Function: VLOOKUP * Technique: Absolute referencing ($J$1) Time: 4:53
$4.99
-
Excel, Accelerated: Populate the preferred address
CourseTask: Cause the preferred address to populate in a database Context: Address database Acceleration techniques: Object: Create and name a table Technique: Double-click the Fill Handle Function: IF Function: VLOOKUP Function: COLUMNS Time: 2:41
$4.99