Excel Features

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

Title should be "making charts dance to your command in Excel" but lets keep it technical :) OK let me be very quick at it as I learnt about this almost by chance. I used...

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

Aging analysis is helping accountants since ages and beyond doubt this is one the those reports that are prepared almost every period to track both receivables and payables. If you want to learn more...

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

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

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

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

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