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