Products
-
Excel, Accelerated: Split out address components into columns
CourseTime: 0:47 | Would you like to know how to split out address components into columns? To learn how, watch the video and download the Excel template. Techniques: Text to Columns in 2 stages
$4.99
-
Excel, Accelerated: Change date formatting
CourseTime: 1:55 | Would you like to know how to change date formatting? To learn how, watch the video and download the Excel template. Techniques: Add digits to the end of text, Reformat cells from text to number, Reformat cells from number to date, &
$4.99
-
Excel, Accelerated: AutoComplete from a predefined list
CourseTime: 2:56 | Would you like to know how to perform AutoComplete from a predefined list? To learn how, watch the video and download the Excel template. Techniques: INDEX, Fill down to the bottom of a list, In-cell AutoComplete, In-cell dropdown
$4.99
-
Excel, Accelerated: Pull relevant information from another tab
CourseTime: 1:16 | Would you like to know how to pull relevant information from another tab? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, INDEX, MATCH, VLOOKUP, COLUMN, Select table headers only
$4.99
-
Excel, Accelerated: Test for whether row and column headers are in a table record
CourseTime: 1:16 | Would you like to know how to test for whether row and column headers are in a table record ? To learn how, watch the video and download the Excel template. Techniques: Helper column, COUNTIF, The join operator
$4.99
-
Excel, Accelerated: Count names in multiple columns
CourseTime: 1:42 | Would you like to know how to count names in multiple columns ? To learn how, watch the video and download the Excel template. Techniques: Group and outline, IF, COUNTIF, Table slicer, Create and name a table
$4.99