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