Twenty19

Login or Create Your Twenty19 Account


New to Twenty19? No Worries. Register for free!

Advanced EXCEL workshop

Winter Combo Offer

Event Description

Greetings from KVIM Centre for Research !

Realizing the need for Data Analysis in Post Graduate, Industry and Research, Professors from KVIM - Centre for Research as a part of Executive Education has decided to conduct Hands – on training in Advanced EXCEL to Members of faculty, Industrial persons UG and PG Graduate students. Professors with rich knowledge in advanced excel concepts are involved in this program for the benefit of the learners.

The course shall provide:

  • 6  hours of hands – on workshop using real data-sets
  • Industrial case studies
  • Exercises and Assignments

Event Details/Highlights

COURSE CONTENT:

The course is sorted out in modules and every module covers a sensible substance to empower members associate and advancement progressively in the following modules.

Module 1: Introduction to Advanced Excel

Module 2: Data Validation

  • Extended uses of Data Validation
  • Working with validation formulae
  • Other methods of tracking down invalid entries

Module 3: Preparing your data for analysis

  • Mastering lookup functions (INDEX, MATCH, HLOOKUP, VLOOKUP)
  • Creating helper columns using DATE and TEXT functions
  • Applying NESTED-IF, AND, OR to organize data

Module 4: Methods of Summarizing Data

  • Using SUMIFS and COUNTIFS
  • Advanced uses of PIVOT-TABLE features like Value Field Settings, Grouping Data and Slicers among others
  • Identify Major Customers, Top Products, Top/Bottom Sales reps, LARGE, SMALL, MAX, MIN

Module 5: Report Visualization Techniques in Excel

  • Dynamic charts (using CHOOSE & OFFSET functions) & Sparklines for trends
  • Effectively using Conditional Formatting (formula-driven) for reporting

Module 6: Industrial Case Study Analysis

Registration Details

Category Amount (RS)
Academicians 1000
Students UG 250
PG 500

Live Event Feed

Live Trainings Feed

Live Internship Feed

Send me amazing internships by email

Confirmation email has been sent to your email address. Please click on "Confirm to get Internship alerts" button in the email.
Please provide a valid email address.
There were some issues. Please try again later.

Close