Workshop on Essentials of Microsoft Excel by Dr. Nitin Kr SaxenaPosts by JSB
Center for Advanced Data Analytics organizes a Half-day workshop on “Essentials of Microsoft Excel” for PGDM. The workshop was delivered by Dr. Nitin Kr Saxena, Associate Professor-Marketing.
The workshop covered 16 plus functions of MS Excel like 3D Sum, Sumif, Pivot tables, Lookups used in day to day analytics by the professionals in all area. Students enjoyed the hands-on experience of various MS Excel functions. The datasets provided to the students were real-life data from different companies.
The workshop started with the cleaning of the data and preparing the same for further insights. Students also prepared the sales dashboard showing current rate, desired rate along with day to day achievement.