This is a rebroadcast of a session that was recorded in July 2017.
When you register for this webinar you will receive complimentary Pivot Table Toolkit, which will help you convert your raw data into useful Pivot Tables and Charts.
Many people struggle with making sense of raw data. Maybe you're unsure of what can be done with the data in the first place. Or, maybe you've heard about putting data into Pivot Tables, but think they are too difficult to bother. Or, perhaps, you are confused by the actual process of creating Pivot Tables.
Regardless of why Pivot Tables give you pause, after attending this webinar, you will be able to take all of your raw data and quickly turn that data into easy to use flexible summary reports using Pivot Tables and Charts. You and your staff will be instantly more productive in Excel. These techniques will work with any type of data. You will find these methods 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.
Excel Expert Tom Fragile will show you what Pivot Tables are, how to use them, and prove to you not only that Pivot Tables are user-friendly, but also that they can provide tremendous results for your Financial Institution. We will start with the basics and build up to more complex pivot tables. We will then create several Pivot Charts together, and you will see the benefits of graphically examining data.
We will then add sorts, filters, slicers, and timelines to create an extraordinarily easy-to-use, highly powerful dashboard that will give you instant results, and allow you to slice and dice your data any which way.
- Creating and managing Pivot Tables.
- Changing the calculation type
- Adding additional calculations
- Creating custom calculations
- Multilayer reports
- Creating Daily, Monthly, quarterly and yearly summaries
- Adding A pivot chart
- Adding Slicers
- Adding timelines
Who Should Attend?
This informative session is designed for:
- Branch Managers
- Bank Tellers
- Management of all levels
- Anybody who uses Excel on a regular basis, and want to be more efficient and productive