Products
-
Excel, Accelerated: Split a column into 2 columns
CourseTime: 1:29 | Task: Split a column into 2 columns | Acceleration techniques: Text to columns, table, LEFT, FIND, RIGHT, LEN
$4.99
-
Excel, Accelerated: Restrict access to a tab
CourseTime: 3:41 | Task: Restrict access to a tab | Acceleration techniques: VBA, hide the tab upon opening the workbook, create a password prompt for the user
$4.99
-
Excel, Accelerated: AutoComplete with a predetermined set of options
CourseTime: 3:14 | Task: AutoComplete with a predetermined set of options | Acceleration techniques: AutoComplete, name a range, Combo Box, Format Painter, Create and name a table, XLOOKUP, INDEX
$4.99
-
Excel, Accelerated: Allocate budgeted salaries to programs
CourseTime: 2:36 | Task: Allocate budgeted salaries to programs | Acceleration techniques: CEILING.MATH, RAND, XLOOKUP, table, PivotTable
$4.99
-
Excel, Accelerated: Invert first and last names, with some middle initials
CourseTime: 1:34 | Task: Invert first and last names, with some middle initials | Acceleration techniques: Text to Columns, IF, ISBLANK, TEXTJOIN
$4.99
-
Excel, Accelerated: Parse an address with a line break
CourseTime: 1:23 | Task: Parse a cell with a line break | Acceleration techniques: LEFT, RIGHT, LEN, FIND, CHAR, format painter
$4.99