Products
-
Excel, Accelerated: Count cells containing a certain letter
CourseTime: 1:38 | Do you need to count cells containing a certain letter? If you would like to learn how, watch the video and download the Excel template. Techniques: COUNTIF, Wildcard *, Join operator "&"; Absolute referencing
$4.99
-
Excel, Accelerated: Compare two databases
CourseTime: 3:26 | Do you need to list the differences between two databases? If you would like to learn how, watch the video and download the Excel template. Techniques: XLOOKUP, IF, TEXT, table objects, the "join" operator
$4.99
-
Excel, Accelerated: Round money to the nearest penny
CourseTime: 0:48 | Are you having trouble rounding payroll taxes to the nearest penny? If you would like to learn how, watch the video and download the Excel template. Techniques: ROUND, use the additive inverse in a formula
$4.99
-
Excel, Accelerated: Add the year to a date
CourseTime: 1:06 | Do you have source data with only the month and day? If you would like to learn how to append the year, watch the video and download the Excel template. Techniques: DATEVALUE, "join" operator, name a range
$4.99
-
Excel, Accelerated: Calculate overtime automatically
CourseTime: 5:30 | Are you calculating overtime manually? If you would like to learn how to automate this, watch the video and download the Excel template. Techniques: WEEKNUM, SUMIFS, XLOOKUP, Convert time values to decimal values
$4.99
-
Excel, Accelerated: Subtotal numbers being recognized as text
CourseTime: 1:37 | Are your subtotal numbers sometimes recognized as text? If you would like to learn how to fix this, watch the video and download the Excel template. Techniques: ISNUMBER, NUMBERVALUE, Subtotal tool
$4.99