Advanced Excel Training

Download Brochure

 

×

Download Brochure

Please enter your details.The download link would be sent to your email.

Organization Name:

Full Name:

Email Id:

Mobile Number:

DownloadClose

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

 

×

Enquiry Form

Please enter your details to enquiry.

Organization Name:

Full Name:

Email Id:

Mobile Number:

Enquiry FormClose