

With that data, he started explaining the concept of Pivot table. All the students came with laptops, and the Speaker had already shared data to their E-Mail IDs.

Various advanced graphing and charting techniques available in Excel have been demonstrated. The participants from both academia and industry have learnt from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel.Īll along, this workshop on Advanced Excel functionality introduced easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them. The workshop has been designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. The use of Excel is widespread in the industry.

The Workshop was organized with the aim of providing hands-on experience to the participants, on analyzing raw data, using MS Excel tools. Almost 400 participants have been benefited from various corporate houses as well. More than 200 students from MBA and BBA participated in the Workshop. IPS BUSINESS SCHOOL organized Five days Workshop on ‘Advanced Excel and Data Analysis’, on 29th May, 2020 to 3rd June.
