Excel Features

Earlier this month we learnt how to carry out ABC inventory analysis in Excel using conditional formatting technique. It was easy and we had loads of fun as we not only understood how to...

So here we have the 30+ amazing copy/paste tricks that everyone must know. With these tricks and tips I am hopeful that you will be able to extend your productivity way further than you...

Moments ago an active member of our facebook Excel community Muhammed Bilal Asmat asked this question: Okay for example there is a very large table consists of rows and columns. Some of the cells contains...

In my last tutorial Part 1 of this little jump start series on Pivot Tables for Absolute Beginners I explained what excel pivot tables are the science behind their working through example and explained how...

"Your life is what you choose it to be" In essence whatever we give to life it returns the same. If we give peanuts, it will return peanuts. If it is 1 life will return...

Sometimes our information is incomplete without the use of symbols. Inserting symbols that are accessible on keyboard are easy to punch in however, it is a tiring task if we have to insert symbols...

Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one...

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

Excel is surely a cavalry of features. And if we count the ways in which each feature can be useful just makes the whole think almost countless. However, for every feature one must know...

First things first, this post is strictly for those who have Excel 2010 or later installed. But is this a warning not to read this post if you have older versions? NO! The intention...