Products
-
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
-
CFO Advantage: Essential Finance & Operations for Technology Startups 2020
CourseThis webinar is ideal for early stage technology startup companies. Major topics include: -Finance Essentials -Operations Essentials -The Founder Role
$50
-
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
-
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