Close

Two Year Full-Time PGDM, PGDM(IB), PGDM(FM), & PGDM(BDA) Programme 2023-25 Batch (Apply Online )                                            Admission in Full-Time Fellow Programme in Management (FPM) AY 2023-24. (Apply Online )                                           

Fore School of Management
Menu Icon

Advanced Excel Training

Download Brochure

Duration: 2 days
Timings: 1000hrs -1730hrs
Dates: November 21 -22, 2022
Programme Director: Prof. Sumeet Kaur
Mode: Online/Offline
Fees: (Online) Rs.8000 Plus GST @18%
(Classroom) Rs.16000 Plus GST @18%
(Residential) Rs.24000 Plus GST @18%

Programme Introduction:

For many people, Microsoft Excel is the technology upon which they rely on a daily basis, covering a multitude of workplace applications. Ms-Excel has grown to become undeniably the most powerful tool in organizations around the world. It is used to optimize data and statistics for further analysis so as to aid decision making across all the management levels. Applications for Microsoft Excel have expanded far beyond the accounting and finance departments, to include users in virtually every aspect of business such as Operations, HR, Marketing, Finance. It is vital for most office based professionals today.

Excel training courses reveal a lot of nut and bolts, tricks and short cuts, professionals can quickly find ways to apply the knowledge to make tasks in their current jobs simpler, efficient and effective.

One can benefit from this program to use Ms Excel to access, process, analyze, share, and display the information with which you work

Programme Objective:

This Excel 2016 advanced training course, is much more than a quick way to add up numbers. Once you learn about all of the innovative applications in this Advance Excel training course, you will find new ways to track critical tasks. By the conclusion of this advance course, you will master the advanced features and functions of this software.


Programme Content:

Microsoft Excel 2016 Advanced

  1. Essential worksheets operations
  2. Working with cells and ranges
  3. Introducing Tables
  4. Removing Duplicate Rows
  5. Sorting &Filtering Tables
  6. Filtering tables with slicers
  7. Creating Subtotals
  8. Understanding data with conditional formatting Charts
  9. Introducing Formulas and Functions
  10. Text Function & Date Function
  11. The IF Function: what it is, and how to use it
  12. COUNTIF, COUNTIFS, COUNTA COUNTBLANK Function
  13. SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS Function
  14. Introducing array formulas
  15. Vlookup, Hlookup
  16. Match function
  17. Index function
  18. What If Analysis
  19. Text to table

Programme Methodology:

100% hands on

Target Participants:

All analysts, decision makers and managers across all management levels who would like to improve the ability of using Excel for taking decisions.

Program Directors:

Prof. Sumeet Kaur is an Associate Professor has over 18 years’ research and teaching experience. She has conducted Management Development Programs on topics like applications of qualitative techniques in competence mapping, simulation techniques and assignment problems, operations excellence, supply chain management, advanced excel techniques for managers of the public and private sector. She has organized workshops on Decision Sciences and its management applications like business research methods. She has also conducted Faculty Development Program on topics like SPSS and Research Methods, Multivariate Data Analysis, Machine Learning and Analytics using R. She has also been involved in case of development with Maruti True Value, Blind People Association, Indraprastha Apollo Hospitals which are published in European Case Clearing House (ECCH). She has research and consulting interests in Reliability and Life Testing, Business Forecasting, Managerial Decision Making, Quantitative Techniques in Advanced Marketing Research, etc. She teaches courses on Business Statistics, Business Analytics, Multivariate Data Analysis, and Advanced Business Statistics in Big Data associated with the University of California, Riverside.

Corporate Group Discount:

One complimentary nomination for every group of three nominations from the same organization, i.e., 3+1 participants for the fee of 3 participants.

For registration/enquiries , please mail to exed@fsm.ac.in or call at 011-26856301/ + 91 9166085159/ +91 9810875278/ + 91 7976445970

Executive Education/MDPs

FORE School of Management has been designing, developing and conducting innovative Executive Education (EE)/ Management Development Programmes (MDPs) for working executives in India for over three decades.