Products
-
Excel, Accelerated: Calculate how many times a customer placed an order
CourseTime: 2:06 | Task: Calculate how many times the customer placed an order | Context: Sales ledger | Acceleration techniques: PivotTable, COUNTIF, table, COUNTIFS, "&" operator
$4.99
-
Excel, Accelerated: Eliminate in-cell line breaks
CourseTime: 0:29 | Task: Eliminate in-cell line breaks | Context:Data exported from another system | Acceleration techniques: Keyboard shortcuts Find and Replace, Find the line breaks
$4.99
-
Excel, Accelerated: Create uniform starting column
CourseTime: 3:08 | Task: Create uniform starting column from comparative Balance Sheet | Acceleration techniques: TRIM, CONCAT, Delete columns, Format Painter, absolute referencing, VLOOKUP, MATCH
$4.99
-
Excel, Accelerated: Create a database layout with multiple dimensions
CourseTime: 5:03 | Task: Create a multidimensional database layout from information laid out in a different format | Acceleration techniques: Transpose, VLOOKUP, INDEX, MATCH, Format Painter, absolute referencing, PivotTable
$4.99
-
Excel, Accelerated: Format a number in a text string
CourseTime: 1:40 | Task:Format a number in a string which concatenates both text and numbers from cells in a database | Acceleration techniques: CONCAT, TEXT, TEXTJOIN
$4.99
-
Excel, Accelerated: Change certain grades to other text
CourseTime: 0:51 | Task: Retain certain grades while changing others to specified text | Acceleration techniques: VLOOKUP, name a range
$4.99