Mastering Microsoft® Excel® PivotTables® overview:
Ever get a headache trying to make sense of worksheets that contain hundreds or even thousands of rows of data? One of the coolest features of Microsoft Excel—the PivotTable—is a great way to compare data. It’s powerful, but there’s no need to feel the least bit intimidated. If you can drag a mouse, you can create a PivotTable. Come find out how!Grab a comfortable seat and we’ll walk you through a one-hour lesson on the basics of creating PivotTables. Find out what PivotTables are, how they work and how to create your own. Wondering how to change your PivotTable field settings? How to use PivotTable Wizard? How to understand the lingo used in PivotTable reports? We’ll cover all that, too, in one mind-expanding hour. The next time you need to see comparisons, reveal patterns or analyze trends, you’ll know exactly what to do. If you want to impress your boss, wow your colleagues and, of course, save tons of time, sign up today.
What you’ll learn:
- The in’s and out’s of Excel PivotTable and PivotChart reports, including the terminology used in PivotTable reports
- How to use the PivotTable Wizard
- The right way to modify an existing PivotTable, including how to insert a chart in your PivotTable report
- How to quickly drill down in your PivotTable without having to go back to your source data to identify specific information
- How to change your PivotTable field settings to a variety of options such as average, minimum, maximum or even custom settings
- How to quickly format your PivotTable report and give it a professional appearance