CA VIKRAM SHANKAR MATHUR
BA (Economics) Hons, F.C.A., D.I.S.A. (ICAI), F.A.F.P. (ICAI)
Office: A-107, Doctor House, Above Parimal Railway Underpass, Off C. G. Road, Ellisbridge, AHMEDABAD-380006.
Email: email@example.com / firstname.lastname@example.org
(Consulting hours: 11 AM – 4 PM)
Cell: +91-8460890111 / +91-9998090111
Innovative, Creative and Persistent – We believe in providing total impregnable solutions to our client’s needs. Microsoft Excel is one of the most versatile spreadsheet software’s ever invented. Information that usually resides in your accounting / financial software can only provide those many reports, either as have been built into the system or can be extracted into flat (usually text) files of a specified format. We connect directly to your database either using ODBC or similar methods that do not alter your data – but that is where your role ends – and extract reports using various Data Analysis methods that convey the expected level of Business Intelligence that is subject only to your imagination. Not only that, we have successfully trained personnel in companies of the like of Gujarat Telephone Cables Ltd (1995), Crompton Greaves Ltd (1990-1992) and Cadilla Laboratories Ltd (1993-1994) while employed in the industry. Since May 1995, the sole proprietary firm, M/s Vikram S. Mathur & Co., basically a Chartered Accountancy firm has been actively training personnel from varied industries like, Pharmaceutical Machinery Manufacturers, Textile Manufacturers, Chartered Accountancy Firms and Educational Institutes. Some of the names that are noteworthy are: Cip Machineries Pvt Ltd, RG Faith Creations Pvt Ltd, Rajiv I. Ravani & Co. and Educational Initiatives Private Limited. As partner of M/s Rajiv I. Ravani & Co., have created a Cashbook Programme developed largely in VBA and Data Validation (Worksheet-level) and have trained over 20-25 personnel in that firm on the methodology and operation of that software of which I was the Developer. Visual Basic for Programming is my forte and it would not be tantamount to boasting if it is said that very few trainers would be found to have such an in-depth knowledge of this aspect available in all versions of Microsoft Excel since Office’1995. Usage of specialized functions like Conditional Formatting, VLOOKUP/HLOOKUP, Data Filtering (basic to advanced), Data Queries, Data Tables, Pivot-Tables and Charts and various other functions (singularly and in combination with each other e.g. SUMIF / SUMIFS, COUNT / COUNTA, INDEX-MATCH etc) may be commonly found amongst other trainers as well – but our core competency lies in the development of user-defined functions and procedure, something that can only be done using Visual Basic for Applications. Have also delivered lectures at various public forum’s dealing with Microsoft Excel, Access, Powerpoint and Word and the interoperability between these software, especially Mail Merge and SQL Server 2005/2010 Query Execution. Advanced usage of the Visual Basic Editor for creating customized User-Defined Functions (UDF) and procedures which utilize Modules, Class Modules and Userforms are also touched upon to the extent specified, as per the mutually beneficial agreed upon terms and conditions and periodicity of the assignment.
AISSCE-CBSE (12th) : Modern School, Vasant Vihar (MSVV), New Delhi-110057 (Science Stream) (March-1980)
Undergraduation: B.A. (Economics) Honours, Shri Ram College of Commerce (SRCC), Maurice Nagar,
Delhi University , Delhi-110002. (March-1983)
Postgraduation: Associate Chartered Accountant, Institute of Chartered Accountants of India (ICAI), New Delhi (May-1989)
Fellow Chartered Accountant, ICAI, New Delhi. (May-2002)
Diploma in Information Systems Audit (DISA), ICAI. (March-2006)
Certification in Forensic Accounting and Fraud Prevention (FAFP), ICAI. (March-2016)
Certification in Concurrent Audit, ICAI. (June-2016)
Update on: 14-Jan-2017 | 10:19 Hours IST