Monday, January 20, 2025

2025-01-20_Our Work Begins Where Your Excel Troubles Lead You

 

2025-01-20_Our Work Begins Where Your Excel Troubles Lead You

In the year 2019, this course was launched for the very first time. "BEGINNERS COURSE ON VISUAL BASIC FOR APPLICATIONS (VBA) alias VBA-Excel". Multiple phone-calls and to my consternation, multiple assurances later, we had NO TAKERS for this course! What was the reason, nobody would elaborate, only that Rs. 15,000/- for 15 sessions (So, Rs. 1,000/-) per session was "Too Expensive"!! When I contacted other institutes in the City about similar courses, the prices were almost the same, yet, they had students coming in and learning MS Excel and the basics of VBA, but we had none. Finally, after my father-in-law, who owned that office at A-107, Doctor House, passed away on April 18th, 2021, I told my wife, who was the inheritor of the office, that we should sell it, as nothing seemed to succeed there, except for my father-in-laws practise as a Diabetologist.

Upto December 2024, I did not think much about this profile. Somewhere, I did realise that running an Excel Training Institute in a practising doctor's clinic was what was driving people away from learning excel, even though he would be in the clinic/office only from 4:30 pm upto 8:30 pm!! I would be the sole occupant of the office from 10:30 AM / 11:00 AM till 4:30 PM, and yet nobody ever did turn up. 

We finally disposed of the office after the death of my mother-in-law and the property ownership finally passed to my wife, in approximately May 2024. I had stopped going to the office post-COVID19, because of the fact that I did not want to take the risk of travelling to and fro from the office to home, when there was no assured business happening there.

So, with this launch of the new course, named the same as the old course, I plan to give the participants some pointers on how to get successfully recruited in the Industry or Profession, whichever they chose, by imparting some training in the final stages, that I know for sure other institutes are definitely not giving, because I myself have been a part of this profession, as a VBA Programmer since almost 25-30 years of my life. You see, Microsoft 365 / Office 2019 / Office 2024 has added a whole lot of functions to the Excel interface, that work no only in the local installation of Office, but on the online excel interface available from https://office.microsoft.com interface as well.

CA VIKRAM SHANKAR MATHUR
January 20th, 2025 @05:31 Hours IST

Ahmedabad, Gujarat, India.



Friday, January 17, 2025

2025-01-17_LinkedInPost_Viral




[17/01, 11:17 am] Vikram Shankar Mathur: Statistics on my post on LinkedIn on 16th January 2025 that got 197 impressions in just 2 days!! How awesome is that?

[17/01, 11:23 am] Vikram Shankar Mathur FCA:

Read this almost viral post by yours truly!!

[17/01, 11:51 am] Vikram Shankar Mathur FCA: Already has received more than 200 impressions in just 2 days!! Unbelievable!!

Thursday, January 16, 2025

Excel-VBA-AHMFCA



This is indeed a very interesting article, and coincidentally happens to be the exact reason for myself launching my website https://lnkd.in/gEZaUmF2, where I (from past experiences as a partner in a CA Firm) had started successfully storing critical audit and accounting data on customised (sometimes even using VBA) - specially for typically difficult clients.

Just for example, as an accountant, I used to supervise TDS related data for submission of eTDS returns on a quarterly basis for a client, say Ms XYZ. Then, at the time of finalizing the books of account prior to publishing the Annual Report as a part of the Audit Report, we would firstly need to report on the yearly TDS data as being 'True and Fair/Correct'. Secondly, to issue the Form 16 for the employees, we need the consolidated data of the four quarterly eTDS submissions!! Voila, customised Excel Spreadsheets came to the rescue.

Read this article, like I did, to realize that each CA (read as professional) Firm has their own requirements at least on an annual basis!! I am not even mentioning those Financial Modeling requirements of Project Finance, or the periodic submissions firms need to submit to their banks from whom finance of any kind is availed.

CA Vikram Shankar Mathur

https://caalley.com/new-update/international-news-listings/many-auditors-are-still-married-to-their-excel-spreadsheets-report-finds

Wednesday, January 15, 2025

Restarting Excel Trainer Ahmedabad in 2025

Excel Trainer Ahmedabad 2025

Excel Trainer Ahmedabad 2025

In the month of November, 2019, I had given up, officially, all hopes of ever earning the tag of "Excel Trainer Ahmedabad" and then, post COVID-19, I stopped going to my office at A-107, Doctor House completely. Partly because the man who owned that office, Dr. Om Prakash Gupta, my father-in-law, had suffered a nasty fall and broken his hip bone and had become completely bed-ridden. Now, this was the man who has always been a great source of inspiration to me, because at the age of 92, he was spunky enough to go for a hip-replacement surgery, even though we (his immediate family, consisting of my wife, Dr. Kamayani Mathur and my mother-in-law, Smt. Sudha Gupta) knew for a fact that he was the last person on earth who could bear the pain of the operation, despite being a doctor himself. You see, this pain-tolerance level was very, very low. Sadly, he passed away in April 2021, and I stopped going to the office shortly thereafter.

I do not mind stating here, that despite the fact that I got quite a few enquiries about the Advanced Excel Course and a few for the Visual Basic for Applications (VBA) course, no one ever did turn up to attend the classes. Fees was never the problem, because I always used to say that the student should join the course, take a couple of trial classes for free, and then pay the fees for the course, 50% in advance and 50% on completion of the course. But still, there were no takers for the course.Of course, I was totally downcast and this thought kept nagging me that there was something that I was missing, something so critical that it was simply not occuring to me! I had even had GST Registration done for the EXCEL TRAINER AHMEDABAD institute and registered it. But there were still no takers for this !!

Then that office was shut down and my wife and I took the tough decision to sell the place, and by February 2024, even the sale of the Doctor House property was completed. So, effectively, from May'2021 upto September'2024, there was no activity on the front of anything to do with "Advanced Usage of Microsoft Excel Formulae" or with "Programming the Visual Basic for Applications (VBA)" front.


In December'2024, I came across the worksheet depicted above, a multi-column Expenditure & Withdrawal Bank Book Format that was used by me in my own Income-Tax Return for the Assessment Year 2024-2025 (current assessment year). This workbook does not use either any advanced excel formulae, or any VBA Coding at all. But it still managed to inspire the teacher-cum-artist alive inside me - who LOVES Microsoft Excel Spreadsheets and still swears by them DAILY!!

Simultaneously, on 8th October, 2024, I launched my Digital Showroom and my Excel-VBA-AhmFCA FB-Page inspired website. I also realized that there are a very few (slightly more than a handful, actually) Chartered Accountants in Ahmedabad who are into Advanced Visual Basic For Applications Programming and that set me off thinking. Then, I created three Worksheet Catalogues shown below:



I also made a flurry of posts at my Vikram Shankar Mathur (vsmathurcoin) Blog and my Deadly VBA Programmer Blog and on my VikramSMathur Blog, as well.

Finally, I realised, today, on the 14th of January, 2025 that there was a big mistake that I had been doing all along. I was hankering for students and the paucity of them as well, little realising that if no one really knew anything about my capabilities, why would they even come to me?

SO, I AM RELAUNCHING MY EXCEL TRAINER AHMEDABAD PROFILE WITH NO EXPECTATIONS FROM ANYONE TODAY!!

CA VIKRAM SHANKAR MATHUR
January 15th, 2025 @ 01:21 Hours IST

2025-01-20_Our Work Begins Where Your Excel Troubles Lead You

  2025-01-20_Our Work Begins Where Your Excel Troubles Lead You In the year 2019, this course was launched for the very first time. " B...