Products
-
Excel, Accelerated: Extract numbers from cells with both numbers and text
CourseTime: 1:54 | Task: Take a cell with both numbers and text, and extract only the numbers | Acceleration techniques: Text to columns, IF, LEFT, FIND, NUMBERVALUE
$4.99
-
Excel, Accelerated: Troubleshoot monthly date groupings in a PivotTable
CourseTime: 1:49 | Task: Troubleshoot monthly date groupings in a PivotTable | Acceleration techniques: NUMBERVALUE, PivotTable, group PivotTable dates by month
$4.99
-
Excel, Accelerated: Extract key totals from a database
CourseTime: 4:19 | Task: Extract key totals from a database | Acceleration techniques: Table, PivotTable, SUMIFS
$4.99
-
Hangout: How to Dynamically Update Start and End Dates for a List of Transactions in Excel
CourseTechnique: Dynamically Update Start and End Dates for a List of Transactions in Excel | Why: Create a visual that quickly shows the start and end dates of a list | Step 1: Import your data into a named table | Step 2: Create the MIN and MAX formulas
$4.99
-
Hangout: How to Avoid the Divide by Zero Error in Your Presentation
CourseTechnique: How to Avoid the Divide by Zero Error in Your Presentation | Why: Eliminate displaying unsightly errors in your presentation | Step 1: Create your formulas | Step 2: Add the IFERROR function
$4.99