Hi, please check out my Youtube video for the hack to replicate a formula down a column accurately and fast. 🙂
Category: Machine Learning
Using Excel VBA to automate Excel, CSV files transfer from Sharepoint library to local or network folder.
Hi, below is the Youtube video for the Sharepoint Excel, CSV files transfer automation. I have also included the text file for the VBA code
Semi- Automatically Copy files from Sharepoint to local/ network folder
This post is to create a semi automatic process to copy files from Sharepoint to your local or network folder. This automation uses Power Automate,
Using Telegram bot to control ESP32 microcontroller LEDs
This post is about using Telegram bot to remotely control ESP32 microcontroller to on/off 4 LEDs. Please watch my YouTube video below, for better understanding
Enable Excel cell to include leading zeros – 3 methods
Hi this post is about leading zeros in Excel cell and how to force Excel to display the leading zeros which we need especially for
Split Python List into sublists base on index/indices
We will split a Python list into sublists base on the index position. The source code below and it’s quite self explanatory. The output :
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 