Absolute and Relative References

This video discusses the differences between absolute and relative cell references. (3:06)

Text to Columns

This video demonstrates how to use the Text to Columns feature to separate a string of text into two or more cells. (3:13)

Tables

This video describes the Table feature. (3:52)

Creating a Crosstab Report

This video shows how to create a crosstab report using concatenation and the COUNTIF function. (3:42)

Creating a Dynamic Crosstab Report

This video shows how to create a dynamic crosstab report using concatenation, the COUNTIF function, and data validation. (3:13)