Products
-
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
-
Excel, Accelerated: What XLOOKUP replaces
CourseTime: 2:12 | Task: Look up a value using multiple criteria | Context: Professional impact and areas of specialty | Acceleration techniques: Create and name tables, resize a table, CONCAT, VLOOKUP
$4.99
-
Excel, Accelerated: Consolidate multiple tabs
CourseTime: 2:09 | Task: Consolidate multiple tabs into a single database | Context: Investment account tracking | Acceleration techniques: VLOOKUP, MATCH, Single absolute referencing ($A1, A$1)
$4.99
-
Excel, Accelerated: Multi-criterial lookup for item costs, without XLOOKUP
CourseTime: 1:56 | Task: Look up item costs from a specific invoice number (without XLOOKUP) | Context:Sales line item report | Acceleration techniques: CONCAT, table objects, VLOOKUP, COLUMNS | Bonus! Creating sample data: CHOOSE, RANDBETWEEN
$4.99