# Microsoft Excel Training for Finance and Accounts in Gurgaon, Mumbai, New Delhi

We have conducted training sessions for thousands of Finance and Accounts Professionals. Also, we have conducted such Excel Training programs at New Delhi, Gurgaon, Mumbai, Bangalore, Chennai, Pune, Lucknow, Kolkata etc. We have collected the feedback from our Excel Trainers. Following is the summary that can help you plan a training program for your company.

Amongst many areas, Accountants deal with the following computations:

1. Depreciation of Fixed Assets
2. Debtor’s Aging Report
3. Reconciliation Statement of Accounts Payable and Receivables
4. Accounts Consolidation
5. MIS Reports in a pre-decided format
6. Stock Valuation
7. Cost Allocation

All of the above is calculated or re-calculated in Microsoft Excel. If the working professionals learn the the following specific tricks in Excel, their working will improve dramatically:

1. VLOOKUP (with TRUE and FALSE), INDEX, MATCH – They help pulling values from different tables and help bring data points under one table
2. SUMIFS, COUNTIFS – Using these with dates, numbers and multiple criteria along with right use of cell referencing (\$) can help summarize crucial data as per the MIS report requirement
3. PIVOT TABLE – Data files download from ERP applications such as SAP, Oracle etc. are columnar. Pivot Table can draw critical insights in less than a minute
4. TEXT-TO-COLUMNS – It is a data cleaning technique. It is used to split text into multiple cells. It is also used to correct the date formats. E.g. 22.10.2009
5. IF, AND, OR – These functions help build decision driving logics.
6. EDATE, TEXT, DAY, MONTH, YEAR – The date functions help compute due dates, date differences, year, month and day name.
7. FILTER and SUBTOTAL – This is the most fundamental Excel technique for all basic analysis.

## FAQs:

Corporate Excel training is designed to help employees learn how to effectively use Excel for tasks related to their job duties. Corporate Excel training can help employees work more efficiently and effectively, and may also help improve the overall productivity of the organization.

Corporate Excel training is typically attended by employees who use Excel as part of their job duties, or who need to learn Excel for a specific project or task. This may include people in a wide range of roles, such as finance professionals, salespeople, marketing professionals, and administrative staff.

There are several benefits of corporate Excel training, including: Improved efficiency, Increased accuracy, Enhanced data analysis skills, Better teamwork, etc.

There are several ways to ensure that your employees retain the skills learned in corporate Excel training: Such as: Encourage employees to practice what they have learned, Provide ongoing support, Encourage regular use of Excel and Consider follow-up training.

There are no specific prerequisites for learning Microsoft Excel. However, having a basic understanding of computers and how to use them may be helpful. Overall, the most important prerequisite for learning Excel is a willingness to learn and a desire to become proficient with the program. With some practice and patience, anyone can learn how to use Excel effectively.

WHAT STUDENT SAYS

## Pre-Training Prep Course Testimonials

Kapila Basnayake
Causeway Paints
It is highly appreciating the way he teaches us. We are a much more comfortable zone to understand since we are in the beginning.
Prasoon Mehra
EY
The video and modules illustrated were good with the proper shortcuts mentioned. a great training prep.
Sanyam Kalra
PwC
This Excel Speed Training was really helpful and informative. Shortcuts were really good to know. Flash Fill. Vlookup and Pivot Table as well. Helped me get to the next level. A big thanks to PwC and Yoda Learning Team for introducing me to this course.
Harsh Bhati
PwC
It's short, and concise yet pretty informative, your way of describing things and the edits mentioning the shortcuts on the screen helped me with the learning.
Vishal Sharma
PwC
The way these sessions are planned is way more helpful than physical training in the classroom. These are very much helpful.
Chandni Lakdawala
PwC
Now I can easily and efficiently use excel. Also really good and quick coverage Of the topics.
Mohit Kumar
EY
Pre-Training preparation is very crisp and really useful to refresh the formulas for advanced training.
Ankit Singh
EY
All the concepts were explained very clearly and were easy to understand. The information conveyed was relevant and is really going to be handy.
Kavya Gupta
PwC
All the topics were relevant and can be used in day-to-day projects. Very insightful and informative topics were covered.

WHAT STUDENT SAYS

## Post-Training Testimonials

Kaustubh Raul
EY
It was a superb and 2 ways session. The trainer made it so comfortable and easy for everyone though for almost everyone this is was the very first time to be working on Power BI.
Anushree krishania
EY
It was excellent!! Very very worthwhile to attend it. Thank you so much, and I hope to have more sessions.
Pushkar Thakur
PwC