Consolidate Data From Multiple Worksheets in a Single Worksheet

In my starting days with Excel, I was really bad in capturing data.If you asked me to capture sales data for four different zones, I will create four different worksheets for that. I was that bad.But, you always learn with your mistakes. Am I right? And, if you are doing the same mistakes like I […]

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

Capturing data in a right way is really important.In Excel, most of the time we use serial numbers to in data tables but when you are working on lists the best way is to use bullet points.I mostly use bulleted lists to capture my day to day work (To do lists, Important points).Now, the bad […]

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 […]