Blogs
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...
Find duplicates in excel
Duplicate sheets, duplicate rows or duplicates in some selective columns? lets explore
April 20, 2019 • Pranab Bala
While working with excel, I believe, everyone faces this situation sometime or other. How to figure out duplicates? There could be different dim...
Getting started with Outlook Macro
If you are wondering to automate some of the tasks in Outlook, but not sure where to start.. you came to right place
March 29, 2019 • Pranab Bala
Microsoft Outlook allows users to define macros written in Visual Basic for Applications (VBA) to automate certain activities. Through Visua...
Outlook Screen Overview
Getting Started with Outlook is self explanatory. But this introduction will get you going betterway
March 10, 2019 • Pranab Bala
Outlook is one of the widely used productivity tool. This article focuses on explaining you the different parts the main window of Outlook. Wil...