Blogs

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


How to use advanced filter in excel

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

Feb. 1, 2020 • Pranab Bala

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


Network micro-segmentation

Birds eye view of micro segmentation and its features and benefits

Jan. 5, 2020 • Pranab Bala

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


gantt chart in google sheets and template

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.

Oct. 19, 2019 • Pranab Bala

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


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