Products
-
Excel, Accelerated: Tag and expand a list
CourseTime: 0:48 | Would you like to know how to append text to an existing list, duplicating that list for each type of text? To learn how, watch the video and download the Excel template. Techniques: & operator, Sort with two levels
$4.99
-
Excel, Accelerated: Call up a record with selected contact information
CourseTime: 2:30 | Would you like to know how to call up a record with selected contact information? To learn how, watch the video and download the Excel template. Techniques: Create a fence under a database, Name a range, Create an in-cell dropdown box
$4.99
-
Excel, Accelerated: Paste data into a transposed layout
CourseTime: 1:21 | Would you like to know how to paste data into a transposed layout? To learn how, watch the video and download the Excel template. Techniques: transpose while pasting
$4.99
-
Excel, Accelerated: Add notes next to a PivotTable
CourseTime: 2:23 | Would you like to know how to add commentary next to a PivotTable? To learn how, watch the video and download the Excel template. Techniques: Create and name a table, Create a PivotTable, Remove duplicates, IFERROR, XLOOKUP
$4.99
-
Excel, Accelerated: Track a two-way loan balance
CourseTime: 3:20 | Would you like to know how to track a balance of a loan whose balance switches between two parties? To learn how, watch the video and download the Excel template. Techniques: Force a table to have different formulas in a column, SUMIF
$4.99
-
Excel, Accelerated: Count cells by color
CourseTime: 1:09 | Would you like to know how to count cells by color? To learn how, watch the video and download the Excel template. Techniques: SUBTOTAL, AutoFilter
$4.99