If you struggle with how to create Pivot Tables, or if you don’t even know what you can do with it, or maybe you think that Pivot Tables are too difficult, this session is for you. Pivot Tables can provide you with tremendous results. With some basic understanding, you can master Pivot Tables and you and your staff can be more productive in Excel.
This session, presented by Expert Speaker, a Microsoft certified expert & trainer will show you what Pivot Tables are, how to use them, and that they are not difficult. After the session, you will learn how to make all of your raw data and quickly turn that data into easy-to-use, flexible summary reports using Pivot Tables and Charts. The speaker will start with the basics and build up to more complex Pivot Tables. He will then make Pivot Charts, to graphically show the data. He’ll show you how to add sorts, filters, slicers, and timelines to create a very easy-to-use, but very powerful dashboard that can give you instant results, and allow you to slice and dice your data any which way.
The techniques that you’ll learn here, will work cross-industry, with any type of data. You will find it easier to be clear and concise and right to the point and you will be able to apply these techniques to your own data immediately after the session.
Webinar Agenda
- How to create and manage Pivot Tables
- How to change the calculation type
- How to add additional calculations
- How to create custom calculations
- How to create multi-layer reports
- How to create daily, monthly, quarterly and yearly summaries
- How to add A pivot chart
- How to add Slicers
- How to add timelines
