Products
-
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
-
Hangout: How to Rename List Items with a Cross Reference Table in Excel
CourseTechnique: How to Rename List Items with a Cross Reference Table in Excel | Why: Rename items so they can be imported into the accounting system | Step 1: Create and name a cross reference table | Step 2: Use VLOOKUP to change the names
$4.99
-
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
-
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