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.
n this video we discuss the most common types of errors in Excel, including the N/A error, Value error, divide by zero error, name error, and more.
