Products
-
Excel, Accelerated: Expandable conditional dropdown lists from nonadjacent ranges
CourseTime: 02:4 | Would you like to learn Expandable conditional dropdown lists from nonadjacent ranges? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Upper and lower fences Technique: Data validation
$4.99
-
Excel, Accelerated: Identify cells with specific characters
CourseTime: 1:19 | Would you like to -dentify cells with specific characters? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Drag the fill handle to copy a formula Technique: Double-click the fill handl
$4.99
-
Excel, Accelerated: Summarize gifts by fiscal year
CourseTime: 1:21 | Would you like to know how to summarize gifts by fiscal year? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Double-click the fill handle to copy down Technique: Name a table object
$4.99
-
Excel, Accelerated: Total columns based on 1 criterion
CourseTime: 1:12 | Would you like to know how to total columns based on 1 criterion? To learn how, watch the video and download the Excel template. Techniques: SUMIF, Absolutely reference columns, rows, or both
$4.99
-
Excel, Accelerated: Compare data on 2 tabs
CourseTime: 2:10 | Would you like to know how to compare data on 2 tabs? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, = operator, Use tables
$4.99
-
Excel, Accelerated: Separate text which has a bullet point
CourseTime: 4:10 | Would you like to know how to separate text which has a bullet point? To learn how, watch the video and download the Excel template. Techniques: Text to columns, TRIM, LEFT, FIND, IFERROR, ISBLANK, IF
$4.99