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



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 »
Excel Pivot - Multiple summarization of Fields
Aug. 3, 2019 • Pranab Bala
Pivot tables allows summarization of multiple data Fields or summarization of same data Field multiple times with different perspectives

Often we come across with situations, where the data we summarize in Pivot table do not give the right picture or not giving all the necessary p...

Read more »
Trace a duplicate row in another sheet
May 4, 2019 • Pranab Bala
Find duplicate rows in another sheet, no matter, if that was moved up or down or sorted

Many times you are in a situation that you have worked on a excel did changed couple of cells, sorted the data based on the some or the other co...

Read more »
x
We use cookies. By using our site, you acknowledge that you understand this. Please refer to Cookie Policy, Privacy Policy, and our Terms of Service. OK, Do not show again