A 3 day Workshop on Data Analysis and Business Modelling was organised by Amity Business School, Amity University Madhya Pradesh in its campus in Maharajpur. The workshop was conducted by Mr. Harendra Singh, Assistant Professor at Amity Business School, AUMP. A total of 12 participants who are the alumni of Jiwaji University, BIMR, MLB, IPS, Prestige Institute etc actively participated in this workshop, conducted from 25-07-16 to 27-0716.
The objective of this workshop was to inculcate technical skills in participants to enable them to analyze complex data for business and implement basic MS-Excel techniques for better decision making. The participants were trained on MS-Excel modelling tools and techniques with emphasis on practical industry oriented applications and cases.
The workshop followed the following schedule :-
Day 1: Basic Functions and Utilities in MS-Excel, Date Function, Time Function, Range Names, Text Functions, Cell Freezing and Linking were discussed and students practiced these functions on MS Excel.
Day 2: Financial and logical functions in MS-Excel, Tables, Sorting, Filters, Conditional Formatting,and Summarizing Data using Descriptive Statistics were discussed.
Day 3: IF Statement Analysis, Pivot Table and its Applications, COUNTIF, SUMIF, AVERAGEIF, What-if analysis, Vlookup, Hlookup were discussed.
Certificates were distributed by Prof (Dr.) Anil Vashisht (Director, Amity Business School, AUMP) to the participants on completion of the workshop.