Consolidate Data From Multiple Worksheets in a Single Worksheet

Written by Puneet Gogia in Advanced Excel In my starting days with Excel, I was really bad at consolidating data. If you asked me to capture sales data for four different zones, I would create four different worksheets for that. Yes, I was that bad.But you always learn from your mistakes. Am I right? And if you are doing the […]

How to Highlight Blank Cells in Excel

It’s hard to recognize blank cells in a large data. Because a blank cell is just a white cell without any value.In most of the cases, blank cells represent some sort of gap, missing data, or a formula returns an empty string resulting in a blank cell.And that’s why it’s recommended to highlight these cells […]

How to Insert Bullet Points In Excel

How to Insert Bullet Points in ExcelCapturing data in a right way is really important. In Excel, most of the time we use serial numbers but when you are working on lists the best way is to use bullet points. ​I mostly use bullet point lists to capture my day to day work (To do lists, Important […]

How To Highlight Top-Bottom N Values In Excel

The best way to highlight top bottom values is by using conditional formatting. It’s quick, simple and all you need a few clicks. But, the best part is, you don’t even have to write a formula for this. I have been using this since I have got my first job. Whenever my boss called me with […]

How To Perform Two Way Lookup In Excel

 It happens sometimes when we need to lookup for a value from a table according to the row heading and column heading.Let say, if you need to get the values from above table for a particular month and zone.  Here in this situation you can use a two way lookup. Performing a two-way lookup is all about […]