Products
-
Excel, Accelerated: Remove text from a cell with dollar amounts
CourseTime: 1:37 | Do you need help removing text from a cell with dollar amounts? If you would like to learn how, watch the video and download the Excel template. Techniques: LEFT, LEN, Autofill down, ISNUMBER, NUMBERVALUE
$4.99
-
Excel, Accelerated: Parse negative and positive numbers into 2 columns
CourseTime: 1:45 | Do you need help parsing negative and positive numbers into 2 columns? If you would like to learn how, watch the video and download the Excel template. Techniques: IF, Format Painter
$4.99
-
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: 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