In this video we dive in to the top three mistakes by those new with Microsoft Excel:
1. Not structuring data properly and creating formulas at all corners of your worksheet
2. Not using keyboard shortcuts to navigate through your workbook
3. Not filter data correctly and potentially ruining your data set.
In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in the values, columns, rows, and filter boxes, how to format your pivot table, and some ways to spice up your visualizations.