Products
-
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
-
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