Take charge of data and create effective and informative summaries by using Excel PivotTables.
When you need to crunch data sorting, filtering, and inserting subtotals will only allow you to go so far.
What’s needed are ways to quickly create summary totals based on multiple criteria and to have the ability to interchange or add fields, and add to sort results fast! And, to do this without ever needing to deal with complex formulas.
The Microsoft® Excel PivotTable provides these capabilities long with many additional features!Discover the value of:
- Creating a PivotTable
- Adding and rearranging fields
- Grouping and summarizing effectively
- Applying PivotTable styles
- Inserting slicers
- Creating a PivotChart
- Designing a dashboard
Consider this scenario:
You have thousands of detailed rows of data covering a multi-year period—containing names, dates, transactions, customer location, type of transaction, amount of the transaction, etc. Wouldn’t it be great if you could quickly, easily and accurately create a table to show the total transaction amount for each customer without writing formulas and do it fast!
Then, just as quickly, create another table showing your total transactions by week, month or year by simply changing a field’s location.
You can apply these techniques to an endless variety of data; budget, inventory, contacts, human resources, and many more. The possibilities are endless!
This webinar will start from square one showing you how to design a PivotTable to answer data analysis questions. Then, create a professional look for the data by applying styles, adding charts and slicers, and create an interactive dashboard.
This event will be presented with Excel 2010, however the tips and techniques covered will also be applicable to Excel 2007.
Whether you're completely new to PivotTables or have been muddling along on your own, all it takes is 70-minutes for you to gain valuable tips and tricks to quickly create Excel PivotTables and take your spreadsheets to the next level.
Lisa Ryan has more than 19 years of experience training and supporting users of software applications. She is known for her professional demeanor, thorough command of topics, and ability to tailor training for every audience.|
With extensive experience in a variety of software applications including several proprietary software applications, network operating systems, MS Project, Visio, Crystal Reports, SharePoint, SQL, Visual Basic, and other various programming languages. She is proficient in a variety of word processors, spreadsheets, web design applications, business tools, presentation programs, databases and email.
- MOS Master
- MOS Excel 2010 Expert
- MOS Word 2010 Expert
- MOS Excel 2010
- MOS Outlook 2010
- MOS PowerPoint 2010
- MOS Outlook 2007