Thursday, May 29, 2025

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





Monday, May 26, 2025

Analysis of the LinkedIn Analytics - May-2025

 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

 Embedded Word Document

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



 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

FeatureUDFMacro
Returns a valueYesNo (usually performs actions)
Used in worksheet cellsYesNo
Modifies worksheetNoYes
Triggered automaticallyYes (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





Friday, May 23, 2025

A Couple of AI Generated Videos

 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






Thursday, May 22, 2025

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

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.



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, be...