Products
-
Excel, Accelerated: Nested IF
CourseTime: 1:57 | Would you like to know how to determine price by filtered price points? To learn how, watch the video and download the Excel template. Techniques: IFS, IF, Nesting IF statements
$4.99
-
Excel, Accelerated: Dynamic dropdown lists
CourseTime: 2:15 | Would you like to know how to create a dynamic data validation lookup? To learn how, watch the video and download the Excel template. Techniques: IF, VLOOKUP, Create and name data ranges, Absolute referencing
$4.99
-
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