Blogs
A Guide to Stock Return Visual Comparison using Python Pandas and Matplotlib
Stock return comparison between Mutual Funds or Stocks using pandas and matplotlib
May 21, 2023 • Pranab Bala
Analyzing stock returns is a crucial aspect of financial analysis and investment decision-making. Investors and analysts often compare the perfo...
Automating appointment booking in Outlook using VBA for increased productivity
Automate finding and blocking free slots in Outlook calendar from email for using VBA
April 9, 2023 • Pranab Bala
Are you tired of manually finding free slots in your calendar to book appointments or schedule time for a specific task? With VBA, you can autom...
VBA Macro to add Reminder and Due date to Outlook email
Auto Set reminder and due date to outlook email
Nov. 13, 2022 • Pranab Bala
While reading through emails, sometimes there might be situation that you are not able to immediately react to the email and that you need to do...
Free Excel Project Task status tracker template with RAG
How to create a Project task tracker which shows status in Red, Amber, Green and additional colors, that is handy to track status and to report status
Dec. 30, 2021 • Pranab Bala
An obvious expectation from a decent Task tracker or Project tracker is to have a visual of tasks that needs attention. This could be the tasks ...
Free BPMN diagram online or offline with yED Graph Editor
use yED Live to create BPMN diagram online or download yED Desktop for your Operating system to create BPMN diagrams offline
Dec. 4, 2021 • Pranab Bala
Business Process Model Notation (BPMN) is a graphical notation that can be used to depict internal Business processes in a standard way and shar...
Python Regular Expression (RegEx) in 6 minutes
Get started with Python Regular Expressions (RegEx) and use it for search or match in less than 6 min with python re module
Nov. 27, 2021 • Pranab Bala
Regular Expression ( RegEx ) is a series of characters or a pattern of characters used to search or extract texts from a string. This is widely ...
Excel pop-up box using VBA macro - Add texts with date for status
Excel VBA macro to update Task tracking for progress comments and remarks with Date in pop-up box
Jan. 29, 2021 • Pranab Bala
One of the very frequent use of excel is tracking progress on plan or tasks. Sometimes, it becomes tedious to keep on adding date and followed b...
VBA Macro to Save attachments from multiple selected emails in outlook
Save all attachments from an email is easy. But if you need to save attachments from multiple selected emails to a folder, it is tedious. A simple VBA Macro can help you overcome this
May 3, 2020 • Pranab Bala
There are situations when you would like to save all attachments from an email ID to a particular folder. Outlook do not have any ready feature ...
How to start with Selenium IDE
Get started with Selenium IDE in 30 minutes. Install plugin, record web-page interactions and playback recordings
April 11, 2020 • Pranab Bala
Selenium Automates Browser. This means whatever we do as human on a website, including (not limited to) opening sites, browse through sites,...
PowerPoint presentation shortcut keys
Use keyboard shortcuts to deliver PowerPoint presentations for good audience experience
March 14, 2020 • Pranab Bala
Preparing good PowerPoint slides is the first thing for delivering an excellent presentation. Keyboard shortcuts comes very handy while deliveri...