Effective Pivot Tables in Microsoft Excel
Effective Pivot Tables in Microsoft Excel – This is one of the most powerful tools in Microsoft Excel application that you should not miss it especially when dealing of large database. Upon completion of the course, participants would be able to understand the workings of Excel Pivot Tables, various techniques of summarizing data and create complex models for reporting. You will also learn how to create a Pivot Charts for presentation. Essentially, this 1 day course gives you a complete understanding of the use of Pivot Tables in Microsoft Excel.
This course is also a pre-requisite for participants whom need to create management reports to give a good overviews of organisation performance. It is highly recommended for those who want to build their Excel knowledge further by attending the next course, Dashboard Reporting in Microsoft Excel.