Advanced Excel Courses

Advanced Excel Courses - Working With Pivot Tables

Miricle Solutions makes it easy to learn new and advanced functions and tools in Excel. People who work with Excel on a regular basis and thus have an understanding of the basics of Excel 2003, 2007 and 2010, will benefit from our various advanced Excel courses.

The advanced Excel courses are short, hands-on and focussed. This ensures that delegates will be able to master specific functions in Excel in a non-intimidating environment where questions are answered, examples given, and loads of exercise opportunities exist.

One of the advanced Excel courses worth attending is the half day application driven programme focussed on Pivot Tables in Excel. The main outcomes of the course include a full understanding of spreadsheets and application of models in the business environment. 

Attendees will learn how data needs to look for usage in Pivot Tables, how to convert non-compliant data and into the correct format for Pivot Tables, work with sub-totals, data in rows, filling in the blanks, and more. An exercise is done to ensure reinforcement of knowledge gained.

A step by step guide is provided regarding the creation of Pivot Tables, entering data, refreshing the Pivot Tables and manipulating the data. Areas such as report filtering, combining rows and columns, grouping data, and charting are also addressed. Exercises for combining of rows and columns in the same Pivot Table are done as well as for reinforcing pivot reporting and charting skills. Attendees also learn how to create more meaningful charts and pivot reports.

Other learning areas include that of using calculated fields, linking a Pivot Cell, applying multiple ranges, and consolidating the ranges. With ample hands-on exercises delegates get enough time to reinforce the skills learned. Contact us today to book your seat at one of our advanced Excel Courses focussing on Pivot Tables.