Products
-
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
-
Excel, Accelerated: Standardize database descriptions
CourseTime: 1:27 | Would you like to standardize your database descriptions? Watch the video and download the Excel template to learn how. Techniques: Table, XLOOKUP, PivotTable
$4.99
-
Excel, Accelerated: Update a PivotTable
CourseTime: 1:50 | Do you need to update a PivotTable with recently added information? Watch the video and download the Excel template to learn how. Techniques: Create and name a table, Create a PivotTable
$4.99