MS Excel is the most widely used software tool in all spheres, be it at your work place or your personal data management. Even for students, MS Excel becomes extremely crucial as acquiring excel skills gives them an edge over others during the recruitment process. For most of us, MS Excel is like an undiscovered treasure. We all know it’s basic working but are not aware of most of it’s functioning. Once you discover it’s true potential, it can work wonders in your professional as well as personal ventures. This workshop will familiarise you with various necessary excel tools, functions and features that are frequently used in business and can be extended to personal use as well.
The course would help the following categories of individuals in the best possible way
• Students preparing for placements or professional courses
• Management students
• Finance professionals
• Marketing professionals
• Entrepreneurs
• Engineer
Topics covered
- Basic excel
- Arithmetic functions
- Logical functions
- Aggregation functions
- Date functions
- Paste special
- Formatting worksheets Advanced Excel
- Arrays
- One dimensional data tables
- Two dimensional data tables
- Choose Goal seek
- Pivot tables
- VLOOKUP
- HLOOKUP
- Hyperlinks
- Charts
MS Excel has been my companion for a long time. Right from my Engineering days where we learnt to design and manage databases, then in investment banking and private equity at JP Morgan, and now as a finance and management professional, I have really been able to unravel this mystery called MS Excel. I can help you develop data management and processing skills using Excel in the best possible way. This course has been designed to give you inputs which are widely used in the industry with the help of finest material used for training professionals.
