Products
-
Excel, Accelerated: Calculate totals for columns of different lengths
CourseTime: 2:04 | Task:Calculate totals for columns of different lengths | Context: List of values | Acceleration techniques: VBA: Insert a new module, create a macro, define a variable, select a cell, assign a value to a cell
$4.99
-
Excel, Accelerated: Calculate % change
CourseTime: 2:44 | Task: Calculate a % change | Context: Comparative numbers that are also a % of the whole | Acceleration techniques: Change the number of visible decimal places, % format, IFERROR, IF
$4.99
-
Hangout: How to use a simple IFERROR Function
CourseTechnique: How to use a simple IFERROR Function | Why: Cleans up your presentation | Step 1: Create your formula | Step 2: Add the IFERROR function
$4.99
-
Excel, Accelerated: Calculate how many times a customer placed an order
CourseTime: 2:06 | Task: Calculate how many times the customer placed an order | Context: Sales ledger | Acceleration techniques: PivotTable, COUNTIF, table, COUNTIFS, "&" operator
$4.99
-
Excel, Accelerated: Eliminate in-cell line breaks
CourseTime: 0:29 | Task: Eliminate in-cell line breaks | Context:Data exported from another system | Acceleration techniques: Keyboard shortcuts Find and Replace, Find the line breaks
$4.99
-
Hangout: How to Record and Use a Macro
CourseTechnique: How to Record and Use a Macro | Why: To simplify a routine task | Step 1: Add the Developer Tab if you don't already have it | Step 2: Record the macro | Step 3: Add the button to your spreadsheet | Step 4: Save as Macro-Enabled
$4.99