Products
-
Excel, Accelerated: T1S EA video - Amortization schedule with flexible accrued interest
CourseTime: 2:13 | Task: Calculate loan interest when payments are irregular | Acceleration techniques: ROUND, absolute referencing, create a table
$4.99
-
Excel, Accelerated: Bank statement manipulation and categorization
CourseTime: 3:33 | Task: Manipulate and classify a list of transactions | Acceleration techniques: Table, VLOOKUP, split a column into 2 columns of debits and credits, Accumulate all records with specified text, remove duplicates, create a PivotTable
$4.99
-
Excel, Accelerated: Extract text from a cell
CourseTime: 4:01 | Task: Extract text from a cell | Acceleration techniques: CHAR, REPLACE, FIND, Text-to-columns, NUMBERVALUE, RIGHT, LEN
$4.99
-
Excel, Accelerated: Dynamic rolling average
CourseTime: 3:50 | Task: Create a rolling n-month average that ignores annual totals | Acceleration techniques: AVERAGEIFS, EOMONTH, IFERROR, IF, MIN, absolute referencing, concatenate operator, helper row, use a named range in a formula
$4.99
-
Hangout: How to Create a Database in Excel from a Messy QB Export
CourseTechnique: How to Create a Database in Excel from a Messy QB Export | Why: Create a usable data table | Step 1: Use the F5 "Go To" Key | Step 2: Delete rows with blanks and subtotals
$4.99
-
Hangout: How to Add a Menu Tab to Your Presentation in Excel
CourseTechnique: How to Add a Menu Tab to Your Presentation in Excel | Why: Create simple navigation of the worksheet for users | Step 1: Insert shapes on the Menu Tab for each worksheet | Step 2: Link the shapes to the appropriate tab
$4.99