ABOUT THIS EVENT

Event Category

Business & Technology

Event Overview



"Dude! It took me a whole weekend to do what you just did in 30 seconds!"

This quote came from someone who was desperate to get his business data under control. The business is doing well but he'd like to plan better and stop guessing about inventory levels, customer behavior and product line performance. And all it took was a pivot table.





Prerequisites

People who work with Excel hear about Pivot Tables but aren't sure what they are, how they can be useful or when to use them. So, let's spend 2 hours just on Pivot Tables! They can help:- Get immediate, focused summaries of your data without writing a bunch of formulas- Assess the size of a project before you jump in- Check your data quality before you start any analysisHere is a guest blogpost where I show how to use Pivot Tables to check the quality of a nonprofit’s donor information: Pivot Tables: Your Tool for Exposing Miscreant Data In the workshop you'll see that Pivot Tables can reduce DAYS of work down to seconds or minutes. The key is in laying out your spreadsheet properly. And well cover that during the session.We’ll also look at some Excel 2013 features that make Pivot Tables even more powerful.Sign up! Come out! Learn how you can grab hold of your data like never before.

The only prerequisite is that you use Excel on a regular basis.