Products
-
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
-
Excel, Accelerated: Summarize PayPal transactions
CourseTime: 3:32 | Would you like to know how to summarize PayPal transactions? To learn how, watch the video and download the Excel template. Techniques: SUMIFS, LEFT, DATEVALUE, IFERROR, TEXT, Create and name a table, Name a cell, Remove duplicates
$4.99
-
Excel, Accelerated: Total the bills due this week
CourseTime: 1:44 | Would you like to know how to total bills due this week? To learn how, watch the video and download the Excel template. Techniques: SUMIFS, INDEX, MATCH, EOMONTH, DAY, Name a cell, Use an operator on a date, Color an input cell
$4.99
-
Excel, Accelerated: Retain leading zeroes in ID numbers
CourseTime: 2:41 | Would you like to know how to retain leading zeroes in ID numbers? To learn how, watch the video and download the Excel template. Techniques: TEXT, RIGHT, REPT, LEN, FIND
$4.99
-
Excel, Accelerated: Calculate profit by project
CourseTime: 6:07 | Would you like to know how to calculate profit by project? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, SUMIFS, SUMIF, ROUND, IFERROR, EOMONTH, Create and name a table, Create a line graph
$4.99