Products
-
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
-
Excel, Accelerated: Parse addresses
CourseTime: 2:16 | Task: Parse addresses from 1 cell into multiple cells| Acceleration techniques: Increment text cells which end with a number, RIGHT, LEFT, TEXT, Text-to-columns, TRIM
$4.99
-
Hangout: How to Use a Radio or Option Button in Excel
CourseTechnique: How to Use a Radio or Option Button in Excel | Why: Allows the user to see results based on the option selected | Step 1: Insert the Option from the Developer Tab | Step 2: Copy the Option Button for each choice | Step 3: Create a formula
$4.99