Blogs

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, 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 and playback

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

PowerPoint Keyboard shortcut keys in presentation mode is one of the key for smooth presentation.

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


Excel Advanced Filter or AutoFilter

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

Sept. 14, 2019 • Pranab Bala

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


Open csv in excel - Date format issue

Frustrated with incorrect dates while opening csv file in excel? This is very common. But you can also overcome easily in different ways

Aug. 17, 2019 • Pranab Bala

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


Excel Pivot - Multiple summarization of Fields

Pivot tables allows summarization of multiple data Fields or summarization of same data Field multiple times with different perspectives

Aug. 3, 2019 • Pranab Bala

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


Trace a duplicate row in another sheet

Find duplicate rows in another sheet, no matter, if that was moved up or down or sorted

May 4, 2019 • Pranab Bala

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


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