Products
-
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
-
CFO Advantage: Designing a Sweet Dashboard in Excel for Small Businesses
CourseLearn eye-popping techniques on how to create a sweet dashboard of key performance indicators for flourishing small businesses. Major topics include: - Creating Database Tables - Creating Charts & Graphs - Making Your Dashboard Sweet
$199