Welcome to Deeps Online

Please visit All Blogs Page for more Articles and Tips:

Outlook and Mail Management

Excel Tips and Trick

Diagramming Tools

Photo Editing

Every day Programming

Other Miscellaneous topics

Preview of few Latest Articles

Excel pop-up box using VBA macro - Add texts with date for status
Nov. 22, 2020 • Pranab Bala
Learn how to create Excel VBA macro to pop-up input Box to capture text. Update the cell by Prepending or appending existing text as a new line starting with today's date

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, 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
PowerPoint Keyboard shortcut keys in presentation mode is one of the key for smooth presentation.

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 »
Find duplicates in excel
April 20, 2019 • Pranab Bala
Duplicate sheets, duplicate rows or duplicates in some selective columns? lets explore

While working with excel, I believe, everyone faces this situation sometime or other. How to figure out duplicates? There could be different dim...

Read more »
Getting started with Outlook Macro
March 29, 2019 • Pranab Bala
If you are wondering to automate some of the tasks in Outlook, but not sure where to start.. you came to right place

Microsoft Outlook allows users to define macros written in Visual Basic for Applications (VBA) to automate certain activities. Through Visua...

Read more »
Outlook Screen Overview
March 10, 2019 • Pranab Bala
Getting Started with Outlook is self explanatory. But this introduction will get you going betterway

Outlook is one of the widely used productivity tool. This article focuses on explaining you the different parts the main window of Outlook. Wil...

Read more »
Create diagrams, flowcharts or gantt from text with mermaid
March 3, 2019 • Pranab Bala
Draw your diagrams, flowcharts or gantt by writing simple texts similar to markdown or graphviz

Ever wanted to simply draw diagrams or flowcharts and avoid heavy tools like Visio.? Mermaid is one of the tool comes very handy here. Amazing...

Read more »
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