Hasaan Fazal
Hiding Gridlines in Excel - Learn the Right Ways
One of our facebook community member consulted for Excel help and sent me a sample file. In that I noticed in order to hide gridlines, that are visible by default, were “forced” to disappear by filling the cells with white fill colour. Yes it does work but its not the right way to do it. […]
Conditional Charts in Excel - Workaround + How To
Last time we learnt how to make simple dial charts. There is so much to be discussed as basics to Excel charting but without little fun and doing out of ordinary is what everyone asks for. So today we will talk about how to do conditional charting in Excel. Making things clear, there is no […]
Create Simple Dial Charts in Excel - How To
Charting or graphing is one of the biggest punch Excel has. Visual presentation of data greatly improves user’s ability to comprehend the information and significantly cuts down the time to take decisions. That is why executives around the world rely on charts and graphs rather than simple reports full of words. Believe me nobody has […]
Excel Dynamic Data Validation Lists - Explained
Data validation lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. For those who are unaware of data validation tool and data validation lists then it is a technique by which you can control the input by providing a drop-down […]
Building a reference to specific Worksheet based on Cell value using Formula
Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported to Excel where calculations and everything is done much more easily. However, exporting to excel or importing in excel sometimes create very bizarre situations. For example, imagine a situation that you […]
5 Interview Questions I ask every candidate
Hiring the right person is first step to successful organization. Letting the right one in saves you ample in the long run. Filtering down to the right candidate is a difficult process. If it depends on candidate it depends on the interviewer even more. Although I have listed down the five questions later but this […]
10 Signs that You are a born Leader
Many think leaders are not made but are born to be one. To be a leader one don’t need to have super powers. It only takes few traits under the skin. We have listed 10 characteristics that are common in finest leaders around the world. Are you also born to be a leader? Read on […]
Count Specific Weekday or Weekdays within Data range containing Dates
Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count specific weekdays within a large range of dates? This is often the case with time sheets or similar kind of data set where dates are involved and you have to count […]
Removing leading Apostrophe (‘) in Excel from Numbers and Text
This question is asked by one of the member at our facebook community. He was stuck in common problem. Leading apostrophes. This is often the case if data is extracted from a famous business application Lotus Notes. If the data is copied or extracted to Excel then these unwanted characters interferes with Excel’s normal functioning. So […]
How Excel VLOOKUP Works: How to use it - Explanation with Example
While explaining LOOKUPs in my previous post, I explained how in daily life we apply lookup functions in different situations and to understand better I explained the example of mathematical lookup table to find the rate. If you haven’t read that article yet then I strongly recommend to read that first and then come to […]
