Products
-
Excel, Accelerated: Pull selected columns from another tab
CourseTime: 3:26 | Would you like to pull selected columns from another tab? To learn how, watch the video and download the template. Acceleration Technique: Helper column Function: FILTER, INDEX, MATCH, TRUE Object: Create a tab, Name a table
$4.99
-
Excel, Accelerated: Highlight cells that match the adjacent cell
CourseTime: 1:45 | Would you like to highlight cells that match the adjacent cell? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Conditional formatting Technique: Paste formats
$4.99
-
Excel, Accelerated: Reference summarized information from a separate form
CourseTime: 3:41 | Would you like to reference summarized info from a separate form? To learn how, watch the video and download the template. Acceleration Techniques: Substitute cell references for text and; Extract target text from a cell w/ more text
$4.99
-
Excel, Accelerated: Look up vendor cost rates
CourseTime: 1:10 | Would you like to learn how to look up vendor cost rates? To learn how, watch the video and download the Excel template. Acceleration techniques: Function: XLOOKUP Technique: Absolute referencing Technique: Double-click the fill handle
$4.99
-
Excel, Accelerated: Identify consecutive identical data
CourseTime: 2:07 | Would you like to Identify consecutive identical data? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Double-click to copy down Technique: AutoFilter
$4.99
-
Excel, Accelerated: Expandable conditional dropdown list content
CourseTime: 02:4 5| Would you like to learn Expandable conditional dropdown list content? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Data validation to create in-cell dropdown lists Technique: Lower
$4.99