Products
-
Excel, Accelerated: Protect and Sort
CourseTime: 3:46 | Would you like to know how to Sort, Select, and Protect data in a locked table? To learn how, watch the video and download the Excel template. Techniques: Create and name a table, Create arrows for sorting, Lock/unlock cells
$4.99
-
Excel, Accelerated: Identify most recent date
CourseTime: 1:55 | Would you like to know how to list each vendor with the most recent date that they were paid? To learn how, watch the video and download the Excel template. Techniques: NUMBERVALUE, MAXIFS, PivotTable, table
$4.99
-
Excel, Accelerated: Extract key terms from a cell
CourseTime: 2:22 | Would you like to know how to extract key terms from a cell? To learn how, watch the video and download the Excel template. Techniques: LEFT, RIGHT, LEN, FIND, Helper columns, Fill down, Increment numbers
$4.99
-
Excel, Accelerated: Split month, date, and time into separate columns
CourseTime: 0:50 | Would you like to know how to split month, date, and time into separate columns? To learn how, watch the video and download the Excel template. Techniques: TEXT
$4.99
-
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