How to Use Microsoft® Excel® PivotTables® to Easily Summarize and Analyze Data
Turn mountains of data into easily usable and functional reports with just a few clicks!
Have you ever been frustrated by the daunting task of organizing and analyzing large amounts of data?
If so, you’re probably missing out on a remarkable tool that can make your job easier. If you find yourself buried under an avalanche of data and need to produce reports easily and efficiently, then allow Excel PivotTables to come to your rescue!
PivotTables can help you sort and sift large data sets to focus quickly on just the data elements that matter most to you, your boss, and your company’s specific needs.
Even long-time Excel users admit that they don’t take enough advantage of the PivotTable function. But, if your job requires you to sift through mounds of data, do yourself a favor and join us for this user-friendly one-hour training, How to Use Microsoft Excel PivotTables to Easily Summarize and Analyze Data!
In just one fast-paced and informative training session, you’ll learn how to use PivotTables better to sort your data more efficiently … create multiple, customized reports in a few easy steps … and gain a powerful new tool to help you make better business decisions.
In just 60 minutes, you'll learn how to save hours of data-crunching and reporting time
Forget complicated tutorials and thousand-page manuals written in “tech-speak” — this training is the fastest, most accurate way to learn how to harness the potential of PivotTables. Led by Dennis Taylor, one of the country’s foremost Excel experts, this training concentrates solely on PivotTables — what they are and how they can make your life easier. Much easier!
After this session is over, you won’t spend long hours cutting and pasting data in order to compare and analyze different variables. With just the click of a mouse, you’ll quickly find trends, analyze patterns, and complete multiple summaries with Excel PivotTables.
PivotTables WILL make your job easier
This training will open up a world of possibilities for managing data more easily than you’ve imagined. Whether you have a little experience with PivotTables — or none at all — you’re guaranteed to learn something incredible.
You’ll also learn how you can convert a PivotTable into a chart and use a macro to keep your table fresh. In addition, you’ll get tips on the easiest way to group your data. Most importantly, when you use the power of PivotTables, you’ll be saving time and making your job easier.
What You’ll Learn:
- Why they are the “hidden gems” inside Excel
- How to create multiple PivotTables so you can analyze large data sets from different business perspectives
- Easily group and view data in a spreadsheet
- Convert PivotTables into easy-to-read charts — instantly
- Create a macro that keeps your PivotTable data automatically updated
- Learn how to group date-related data into months, quarters, and years … perform ad hoc grouping in two quick steps
- How to get PivotTables and graphs to look — and print — exactly the way
How to Use Microsoft® Excel® PivotTables is an independent program and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation. Microsoft and Excel are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Your Trainer: Dennis Taylor
Dennis Taylor literally “wrote the book” on Excel. An author of seven spreadsheet how-to books including the popular Teach Yourself Microsoft Excel 2000, and a prolific writer/presenter of more than 50 software training videos, he is one of the most respected Excel experts in the industry. But what he likes best is training — be it in the classroom, in public seminars, on video, or through CD-ROMs such as this one.
Dennis has an extraordinary gift for helping “regular folks” grasp the amazing things that can be accomplished with Excel. His easygoing speaking style takes the intimidation factor out of the equation while packing each one of his sessions with enough information, shortcuts and strategies to satisfy everyone’s thirst for knowledge.
Item #: 89453C
All transactions are processed through an
encrypted secure socket layer (SSL).