Products
-
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
-
Excel, Accelerated: Add total daily hours
CourseTime: 6:20 | Do you need to calculate total daily hours more efficiently? Watch the video and download the Excel template to learn how. Techniques: Name a range, In-cell dropdown, Table, PivotTable, PivotCharts (pie, line), Slicers
$4.99