Products
-
Excel, Accelerated: Rotating Assignments
CourseTime: 1:40 | Task: Assign employees to line items on a rotating basis | Acceleration techniques: Create and name a table, IF, VLOOKUP, COLUMNS
$4.99
-
Hangout: How to Use Formulas in Conditional Formatting in Excel
CourseTechnique: How to Use Formulas in Conditional Formatting in Excel | Why: Creates a simple and visual way to see errors | Step 1: Determine where conditional formatting is needed | Step 2: Create conditional formatting with a formula
$4.99
-
Excel, Accelerated: Reference an expanding database
CourseTime: 4:01 | Task: Summarize figures from multiple tabs | Acceleration techniques: Create and name a table, 3-D formulas, fence technique, SUM, SUMIF, EOMONTH
$4.99
-
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