Please enter your details.The download link would be sent to your email.
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
Essential worksheets operations
Working with cells and ranges
Introducing Tables
Removing Duplicate Rows
Sorting &Filtering Tables
Filtering tables with slicers
Creating Subtotals
Understanding data with conditional formatting Charts
Introducing Formulas and Functions
Text Function & Date Function
The IF Function: what it is, and how to use it
COUNTIF, COUNTIFS, COUNTA COUNTBLANK Function
SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS Function
Introducing array formulas
Vlookup, Hlookup
Match function
Index function
What If Analysis
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
Enquiry Form
Please enter your details to enquiry.
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.
