Microsoft Excel 2003 pt 7 (Sort, Filter, Pivot table, Vlookup, Concatenate....)

Click here for the sample file https://sites.google.com/view/simpletektoronto/excel 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.