Products
-
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
-
Excel Hangout: How to use a simple VLOOKUP function
CourseTechnique: How to Use a Simple VLOOKUP Function | Why: Match criteria and select a value | Step 1: Create or import a list of items | Step 2: Use the VLOOKUP formula to add values using a matching criteria
$4.99
-
Excel, Accelerated: Sorting unusual values
CourseTime: 1:24 | Task: Sort non-alphabetically | Context: Tooling area | Acceleration techniques: Sort, COUNTIF, Absolute referencing ($A$1), Paste Values, Helper column
$4.99