Products
-
Excel, Accelerated: Convert text digits to numbers
CourseTime: 1:20 | Do you need help converting text digits to numbers? If you would like to learn how, watch the video and download the Excel template. Techniques: ISNUMBER, NUMBERVALUE, Double-click the fill handle to copy down
$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