Products
-
Excel, Accelerated: Pull relevant information from another tab
CourseTime: 1:16 | Would you like to know how to pull relevant information from another tab? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, INDEX, MATCH, VLOOKUP, COLUMN, Select table headers only
$4.99
-
Excel, Accelerated: Test for whether row and column headers are in a table record
CourseTime: 1:16 | Would you like to know how to test for whether row and column headers are in a table record ? To learn how, watch the video and download the Excel template. Techniques: Helper column, COUNTIF, The join operator
$4.99
-
Excel, Accelerated: Count names in multiple columns
CourseTime: 1:42 | Would you like to know how to count names in multiple columns ? To learn how, watch the video and download the Excel template. Techniques: Group and outline, IF, COUNTIF, Table slicer, Create and name a table
$4.99
-
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