Blogs

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


How to use advanced filter in excel

If you ever thought that Excel Advanced Filter is complex, let's break that myth. The greatest advantage of Advanced Filter is it can be reused.

Sept. 22, 2019 • Pranab Bala

Excel Advanced Filter - Though the name suggest Advanced, but it is not that complex. In the contrary, it is simple and once you spend few minut...


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

Very often people face issues when they are opening csv file and that have dates. When date is exported or saved most of the program or applicat...


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