Products
-
Excel, Accelerated: Test for whether a number falls within a range
CourseTime: 1:55 | Task: Test for whether a number falls within a range | Acceleration techniques: Control cells, RANDBETWEEN, IF, AND, greater than or equal to operator, less than or equal to operator, absolute referencing, named ranges
$4.99
-
Excel, Accelerated: Count survey responses
CourseTime: 2:52 | Task: Tally survey response totals for each question | Acceleration techniques: COUNTIF, Create a database layout, keyboard shortcuts, PivotTable, PivotChart, Slicer
$4.99
-
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