Click here for the sample file http://simpletek.ca/files/ In this video learn to use Database functionality in Excel with Sort, Filter, Freeze pane, and enter info as Form. Also learn to split screen and view 2 worksheets side by side. Learn to create pivot table. And learn to use functions like Vlookup. Concatenate, Countif, convert Text to column.