Conditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip
We have been provided with a top secret data of one lab situated at the very center of the earth. A team of vigilant individuals take readings of different parameters to monitor the temperature of facility so that it is kept in the range good for human life. Now we want to count the number […]
5 Ways to Transpose in Excel - Shifting Columns to Rows or Rows to Columns
One of our community member asked how to convert rows to columns or make columns as rows in Excel quickly without using pivot tables? Many already know how to do this. But for those who don’t this one minute Excel tutorial is for them. By the way, yes! you can use pivot tables to shift […]
Create Edgy To-Do or Check Lists with Check boxes in Excel + Shortfall calculator
The ones who like to plan adores to-do lists as well. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is for you. As I teach ACCA and other professional qualification students and at the same time teaching several subjects it is […]
Changing numbers Sign in Excel - From Negative to Positive and Vice versa
Another question to answer and very interesting one indeed. Again this question came from our vibrant facebook community. The requirement is to change number signs that is change negative numbers to positive and positive to negatives. Although this is hardly the case in many situations that you really want an additive inverse for each and […]
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 […]
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 […]
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 […]
