Products
-
Excel, Accelerated: Extract a ZIP code
CourseTime: 2:09 | Do you have a hard time extracting zip codes from an address list? Watch the video and download the Excel template to learn how. Techniques: Create and name a table, RIGHT, TEXT, ISNUMBER, REPLACE, NUMBERVALUE, IF
$4.99
-
Excel, Accelerated: Split database into different tabs, by month
CourseTime: 0:22 | Do you need help splitting a database into different tabs by month? Use the AutoFilter technique to complete the task easily. Watch the video and download the Excel template to learn how.
$4.99
-
Excel, Accelerated: Create a dynamic report date
CourseTime: 2:43 | Task: Create a dynamic report date | Acceleration techniques: &, TEXT, EOMONTH, TODAY, date format mmmm yyyy, RANDBETWEEN, create and name a table, MAX
$4.99
-
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