Products
-
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
-
Excel, Accelerated: Use VBA to mimic double-clicking the fill handle
CourseTime: 5:10 | Would you like to know how to use VBA to mimic double-clicking the fill handle? To learn how, watch the video and download the Excel template. Techniques: Define a variable, Set the variable's value
$4.99
-
Excel, Accelerated: Use the FILTER function to exclude multiple values
CourseTime: 1:59 | Would you like to know how to use the FILTER function to exclude multiple values? To learn how, watch the video and download the Excel template. Techniques: FILTER, * operator
$4.99