How to Join Microsoft Office Insider

By joining Microsoft Office Insider, you have the opportunity to get exclusive access to new features (like the new XLOOKUP function) in addition to the ability to send feedback directly to Microsoft.

Navigate to File -> Account and click on the “Office Insider” button located on this panel. Follow the prompts from there and you’re in!

Microsoft Office insider

Once you’ve joined you’ll be prompted to download new updates and features when available.

Pivot Table Tutorial with Larger 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.