Products
-
Excel, Accelerated: Summarize monthly financial transactions in a PivotTable
CourseTime: 5:37 | Would you like to know how to summarize monthly financial transactions in a PivotTable? To learn how, watch the video and download the Excel template. Techniques: Create a PivotTable from detailed transactions
$4.99
-
Excel, Accelerated: Create combinatorial table based on two lists
CourseTime: 3:14 | Would you like to know how to create combinatorial table based on two lists? To learn how, watch the video and download the Excel template. Techniques: COUNTA, INDEX, IF, ISTEXT, MOD, IFERROR, & operator, Create and name a table
$4.99
-
Excel, Accelerated: Use conditional formatting to test for identical cell values
CourseTime: 0:42 | Would you like to know how to use conditional formatting to test for identical cell values? To learn how, watch the video and download the Excel template. Techniques: Conditional formatting, Use a formula inside conditional formatting
$4.99
-
Excel, Accelerated: Move comments into cells
CourseTime: 2:18 | Would you like to know how to move comments into cells? To learn how, watch the video and download the Excel template. Techniques: Add the Developer tab to the ribbon, Insert and name a module for macro programming
$4.99
-
Excel, Accelerated: Troubleshoot a circular reference
CourseTime: 1:13 | Would you like to know how to troubleshoot a circular reference? To learn how, watch the video and download the Excel template. Techniques: Locating circular reference
$4.99
-
Excel, Accelerated: Calculate benefit eligibility date
CourseTime: 1:24 | Would you like to know how to calculate the date based on criteria? To learn how, watch the video and download the Excel template. Techniques: EOMONTH, XLOOKUP, Create and name a table, Paste Values
$4.99