letters-BW.jpg

Welcome to Deeps Online

This page covers few latest articles.

Please visit Blogs Page for more Articles and Tips:



Outlook and Mail Management

Excel Tips and Trick

Photo Editing

Diagramming Tools

Every day Programming

Other Miscellaneous topics

Preview of few Latest Articles



A Guide to Stock Return Visual Comparison using Python Pandas and Matplotlib
May 21, 2023 • Pranab Bala
Stock return comparison between Mutual Funds or Stocks using pandas and matplotlib

Analyzing stock returns is a crucial aspect of financial analysis and investment decision-making. Investors and analysts often compare the perfo...

Read more »
Automating appointment booking in Outlook using VBA for increased productivity
April 9, 2023 • Pranab Bala
Automate finding and blocking free slots in Outlook calendar from email for using VBA

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

Read more »
VBA Macro to add Reminder and Due date to Outlook email
Nov. 13, 2022 • Pranab Bala
Auto Set reminder and due date to outlook email

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

Read more »
Free Excel Project Task status tracker template with RAG
Dec. 30, 2021 • Pranab Bala
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

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

Read more »
Free BPMN diagram online or offline with yED Graph Editor
Dec. 4, 2021 • Pranab Bala
use yED Live to create BPMN diagram online or download yED Desktop for your Operating system to create BPMN diagrams offline

Business Process Model Notation (BPMN) is a graphical notation that can be used to depict internal Business processes in a standard way and shar...

Read more »
Python Regular Expression (RegEx) in 6 minutes
Nov. 27, 2021 • Pranab Bala
Get started with Python Regular Expressions (RegEx) and use it for search or match in less than 6 min with python re module

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

Read more »
Excel pop-up box using VBA macro - Add texts with date for status
Jan. 29, 2021 • Pranab Bala
Excel VBA macro to update Task tracking for progress comments and remarks with Date in pop-up box

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

Read more »
VBA Macro to Save attachments from multiple selected emails in outlook
May 3, 2020 • Pranab Bala
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

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

Read more »
How to start with Selenium IDE
April 11, 2020 • Pranab Bala
Get started with Selenium IDE in 30 minutes. Install plugin, record web-page interactions and playback recordings

Selenium Automates Browser. This means whatever we do as human on a website, including (not limited to) opening sites, browse through sites,...

Read more »
PowerPoint presentation shortcut keys
March 14, 2020 • Pranab Bala
Use keyboard shortcuts to deliver PowerPoint presentations for good audience experience

Preparing good PowerPoint slides is the first thing for delivering an excellent presentation. Keyboard shortcuts comes very handy while deliveri...

Read more »
How to use advanced filter in excel
Feb. 1, 2020 • Pranab Bala
Let us demistify Excel Advance Filter and learn how to apply criteria in advanced filter. You should be able to apply fairly complex criteria to Excel Advanced Filter in 15 minutes. Once created, same criteria can be reused on similar data

Advanced Filter in excel is applied onto some data in excel sheet. Criteria or filtering conditions are applied on the data. We need to unde...

Read more »
Network micro-segmentation
Jan. 5, 2020 • Pranab Bala
Birds eye view of micro segmentation and its features and benefits

Topics Covered in this article: Prime Reason to use Micro Segmentation What is Micro Segmentation? Micro Segmentation Basics with NSX ...

Read more »
gantt chart in google sheets and template
Oct. 19, 2019 • Pranab Bala
Want to Learn How to Make a Gantt Chart in google sheets? You will find how to do it quickly in google sheets with conditional formatting. You will also get a template in this article.

Designed more than century ago, Gantt chart is very popular to the Project Manager communities and decision makers. This is equally important to...

Read more »
Excel Advanced Filter or AutoFilter
Sept. 14, 2019 • Pranab Bala
Should I use Advanced Filter in Excel or should I use Auto Filter? Is there any advantage using Advanced Filter? Is it really hard to Learn remember? Let's find it out

Filters in Excel is an amazing feature. I almost cannot recall a time when I have opened an Excel workbook and have not applied a filter. For me...

Read more »
Open csv in excel - Date format issue
Aug. 17, 2019 • Pranab Bala
Frustrated with incorrect dates while opening csv file in excel? This is very common. But you can also overcome easily in different ways

You may jump to : Why excel do not recognize all the dates in CSV: How do I understand if excel could open my csv? Understand Date Loca...

Read more »