Advanced MS-Excel

Venue
KV Institute Of Management And Information Studies
Start Date
End Date
Last Date For Registration
KVIMIS EED advance excel image - Coimbatore

MS Excel skill plays a major role in organizing and showing information for better understanding. When one has an adequate comprehension of Excel tools like tables, cell styles, organizing choices, modeling, it is then important to make extremely impressive workbooks and modeling formats.

The objective of this course is to show members the different models utilized in Excel, troubleshoot, review them and practice matching equations to events and furthermore know couple of options for some random issue. KVIM is putting forth this high effect limit building workshop to individuals and organizations to empower them grasp the significance of breaking down information, estimating and making decisions utilizing Advanced Excel tools.

MODULE

TOPIC

DETAILS

ASSIGNMENT

1

Introduction to Advanced Excel

    

2

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

Canadian super store case study

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

Nintendo company case study

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

Quantum company case study

5

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

The course is open for

  • Student
  • Academic Researchers
  • Business Researchers

Managers and above

 

Dr. S. Lara Priyadharshini, "The Best Professor 2017-18" in the areas of "Academics and Research" with interests in Human Resource Management, Organizational Behaviour and also one of the reputed Data Analyst, Researcher in statistical discipline. Her scientific accomplishments are many, with the most well-known being handling the SPSS and AMOS algorithm which was a landmark in the field of statistics, providing a unifying computational approach to evaluation of data sets. She has also worked closely with different manufacturing and service industries in to areas of G-Suite applications, Excel Modelling and Power Business Intelligence for Business Data Analysis. She has presented and her paper was accepted in various National and International Conferences.

Scan the QR code

The Program charges are as follows

Category

Amount (RS)

Corporate

2000

Academicians

1000

Students UG

250

PG

500

 

  • Maximum Number of Participants: 30
  • Your participation should be confirmed by us before attending the course. Delegate fee is non-refundable.
  • Registration: “First-come-First Serve” and based on a selection process by Department of Research (DoR) and Department of Executive Education (DoEE).

IMPORTANT NOTE:

  • Certificate of participation for those who attend all sessions.
  • Refreshment and working lunch will be provided.
  • Spot payment is permitted, require prior registration online along with acceptance from DoR and DoEE.
  • Attendance certificate will be issued on request.
  • Participants are expected to have basic Computer & Research knowledge to attend.