From lookup functions to multi-part formulas, I wish I knew about these Excel formulas earlier because they make me feel like a data wizard whenever I use them.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.