Products
-
Excel, Accelerated: Create scenarios from columns in different combinations
CourseTime: 2:05 | Task: Add different combinations of cost sets for different scenarios | Acceleration techniques: Create an in-cell drop-down list, Name a range, COUNTIF, SUMPRODUCT, Absolute and relative referencing
$4.99
-
Excel, Accelerated: Control date groupings in a PivotTable
CourseTime: 1:13 | Task: Control date groupings in a PivotTable | Acceleration techniques: Group and ungroup dates in the PivotTable
$4.99
-
Excel, Accelerated: T1S EA video - Create automated amortization schedule
CourseTime: 7:31 | Task: Create an automated amortization schedule which also calculates the final payment for a $0 ending balance | Acceleration techniques: ROUND, PMT, EDATE, name ranges, macros/VBA, Goal Seek, command buttons
$49
-
Excel, Accelerated: Advance data 1 month in a two-dimensional, multi-year table
CourseTime: 2:02 | Task: Advance data 1 month in a two-dimensional, multi-year table | Acceleration techniques: INDEX, MATCH, SUMIFS, Combination absolute/relative referencing in a single cell reference
$4.99
-
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