Excel is the #1 data analysis tool for accountants. However, many accountants have never learned the basics of Excel’s data analysis tools. In this webcast, you will learn how PivotTables are crucially important for analyzing data. We will show you examples of PivotTables to demonstrate that data analysis can be an easy task for any accountant. You will learn the step-by-step process to create PivotTables and PivotCharts. To make sure you’re prepared for future analysis, we will even cover all the setup options and features. The major topics that will be covered in this webcast include: – The advantages of PivotTable for data analysis – Step-by-Step PivotTable creation – Creating PivotCharts
When you complete this webcast, you will be able to:~Understand the advantages of using PivotTables to analyze data from multiple dimensions.~Create a PivotTable using a step-by-step process that will analyze accounting data.~Use all PivotTable options to maximize your data analysis.~Create PivotCharts to present your data graphically for the most effective analysis.
A working knowledge of Excel features and functions