Certified - Excel Using AI Workshop - 2025-June-15th

 15th June 2025 - Completed the Excel Using AI Workshop conducted by Aditya Goenka of BE10X and OfficeMaster.IN

Happy to share that I have today, 15th June 2025 earned this certificate from OfficeMaster.IN and BE10X after attending the “#Excel Using AI Workshop” for three hours from 11:00 am to 02:00 PM.

Learning AI tools in Microsoft Excel is increasingly important in today's data-driven world. Integrating AI into Excel enhances your ability to analyze and interpret data, automate complex tasks, and derive actionable insights. By mastering AI-powered Excel features, you can streamline workflows, improve forecasting accuracy, and make informed decisions more efficiently. These skills enable you to stay competitive in various industries, as AI-driven data analysis becomes a standard requirement. Furthermore, understanding AI in Excel empowers you to unlock hidden patterns and trends within datasets, leading to better problem-solving and strategic planning.

(Important Note: I used the web to search for information about the importance of learning AI tools in Microsoft Excel.)

CA Vikram Shankar Mathur
exceltrainerahmedabad@gmail.com

https://exceltrainerahmedabad.blogspot.com

excel-vba-ahmfca.com-Banned?

 Excel-VBA-AhmFCA.com is Banned?

Excel-VBA-AHMFca.com

The strange case of the domain www.excel-vba-ahmfca.com has gone viral in my life, because firstly, I had not ever updated that website that I had got from the www.websites.co.in website.

I have till now been 'banned' from Facebook and Wordpress, but those were for mostly genuine reasons, where I had unwittingly crossed the file line between what out to be and what ought not to be!!! 

 Analysis of the LinkedIn Analytics - May-2025

Post impressions on LinkedIn refer to the number of times a post is displayed, regardless of whether it was clicked or engaged with. Here's a more in-depth explanation: 

• Definition: An impression is counted each time a post appears in a user's feed. If a user sees the same post multiple times, each view counts as a separate impression. 
• Reach vs. Impressions: While reach refers to the number of unique individuals who saw the post, impressions count the total number of views, including multiple views by the same user. Importance: 

Impressions are a key metric for assessing the visibility of content on LinkedIn. A high number of impressions suggests that the content is being widely distributed across the platform. 

• Factors Influencing Impressions: Several factors can influence the number of impressions a post receives, including the relevance of the content to the audience, the timing of the post, and the overall engagement it generates (likes, comments, shares). 
• Tracking Impressions: LinkedIn provides analytics tools that allow users to track the number of impressions their posts are receiving. This data can be used to optimize content strategy and improve overall performance on the platform. 
• Usefulness: While impressions can indicate visibility, they don't guarantee engagement. It's crucial to also monitor metrics like click-through rates, comments, and shares to understand how the audience is interacting with the content. 

In summary, post impressions on LinkedIn measure how many times a post is displayed, offering valuable insights into content visibility and distribution.

Conclusion about the above LinkedIn pictorial:

The growth of the 'Post Impressions' from 3070 t0 3996 i.e. 926 (30.16%) would appear to be purely organic, and should be a result of the constant posting done by the author (me) over the past 6-7 days, because the system computes the last week's average, for that day itself. Last I checked, the post impressions had climbed to as high as 4800+. But the moment that pace goes down, so do the statistics.

Increase of the followers from 1402 to 1431, i.e. 29 (52.00%) seems a rather high in terms of percentage, by when you see that the author (me) must have been browsing the LinkedIn.com website pretty regularly and has obviously added those many number of connections, this statistic, at this stage, is not an alarming thing. Cheers !!

CA Vikram Shankar Mathur
exceltrainerahmedabad@gmail.com

 Embedded Word Document

This is a word document relating to  top points in the document 100-ChatGPT-Tips.PDF, shot out by Microsoft CoPilot.

Use www.blogger.com to create a new blog today !!

 USING MACROS INSIDE MICROSOFT EXCEL

First of all, in order to understand the usage of Macro's inside of Microsoft Excel, you must know that some of these macro's are called UDF's, or User-Defined Functions. Read on, below:

What is a UDF?

A User Defined Function is a function you create using VBA to perform custom calculations that Excel’s built-in functions can't easily do.

---

📌 Why Use Macros for UDFs?

• Extend Functionality: Excel’s built-in functions may not meet specific business or technical needs.

• Reusability: UDFs can be reused across different workbooks and shared with others.

• Automation: You can integrate UDFs into broader macros to perform full automation workflows.

---

🛠️ How to Create a UDF Using Macros (VBA)

1. Open the VBA Editor:

   • Press ALT + F11 in Excel.

2. Insert a Module:

   • Go to Insert > Module.

3. Write Your Function:

   vba
   Function AddNumbers(x As Double, y As Double) As Double
       AddNumbers = x + y
   End Function
   

4. Use It in Excel:

   • Go back to Excel and use =AddNumbers(5, 3) in a cell.

---

📝 Notes About UDFs

• UDFs cannot modify the Excel environment (e.g., they can’t change cell formatting or move cells). They're limited to returning a result.

• Execution speed: UDFs can be slower than built-in functions if written inefficiently or if used repeatedly over large ranges.

• Security warning: Excel disables macros by default for security; users must enable them to run UDFs.

---

📍 Example UDF: Convert Celsius to Fahrenheit

vba
Function CtoF(celsius As Double) As Double
    CtoF = (celsius * 9 / 5) + 32
End Function

Use as: =CtoF(25), which returns 77.

---

🧩 UDF vs. Macro

Feature	UDF	Macro
Returns a value	Yes	No (usually performs actions)
Used in worksheet cells	Yes	No
Modifies worksheet	No	Yes
Triggered automatically	Yes (when cell recalculates)	No (runs on command or event)

---

🛑 Limitations

• UDFs can't access things like:

• Message boxes or input boxes (MsgBox, InputBox)

• Formatting or inserting rows/columns

• Worksheets not currently open or recalculating

The story of Bulder.AI

 The story of Bulder.AI, from YouTube :

Wow, shocking, but true!!

CA Vikram Shankar Mathur
https://www.exceltrainerahmedabad.com/2025/05/
https://www.linkedin.com/company/exceltrainerahmedabad
https://www.facebook.com/excelvbaahmfca

 A Couple of AI Generated Videos

This is a video generated using Video.AI - generated just a few days back, this is not the end, because, as they say, Picture Abhi Baki Hai.

This is another video, this time generated using HeyGen - because it is a free version there is branding on it, still - it is a reasonably good start, yes?

CA Vikram Shankar Mathur
exceltrainerahmedabad@gmail.com

Vikram Shankar Mathur

The Deadly.VBA.Programmer

In this #Digital age, you need not come to my doorstep, office or even physically close to me, just scan this #QRCode and transfer my due amount to me, using this QRCode.

This is a post that will be visible only to all my connections, so no worries about any scams happening. What I want to convey vide this message is that you cannot withdraw money from my account, because this is a #Payment only code, right?

You may not be owing me any money today, because you are clearly not my client yet, but save this post for that day is sure to come, when you WILL be my client!! Cheers!!

Import Form26AS Text File Into Excel Spreadsheet Slides 20250426

 Import Form26AS Text File Into Excel Spreadsheet Slides 20250426

Ahmedabad Fellow Chartered Accountants (AhmedabadFCA): Microsoft Excel and Myself

Ahmedabad Fellow Chartered Accountants (AhmedabadFCA): Microsoft Excel and Myself: Microsoft Excel and Myself Perhaps there is some guilt hidden in my words when I say that I have never really acted on the maxim "When ...

 

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.

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:

https://www.linkedin.com/posts/activity-7285512637407277058-kH4X?utm_source=share&utm_medium=member_android

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!!

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

Restarting Excel Trainer Ahmedabad in 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