Products
-
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
-
Excel, Accelerated: Delete blank rows
CourseTime: 1:57 | Task: Delete blank rows | Acceleration techniques: Go To, activate the Delete Cells dialog, record a macro, assign a keyboard shortcut to a macro, make a macro available to all locally open Excel files
$4.99
-
Excel, Accelerated: Identify overdue items
CourseTime: 4:18 | Task: Identify overdue items | Acceleration techniques: Conditional formatting, AND, TODAY, <=, use a control cell, AutoFilter, table object, slicers
$4.99
-
Excel, Accelerated: Forecasted accrual of multiple staggered bills
CourseTime: 2:50 | Task: Forecast and accrue expenses for multiple staggered bills | Acceleration techniques: MAXIFS, SUMIFS, table object, format painter, ROUND, use a control cell, fill down
$4.99