Inserting symbols in Excel using text input

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

Creating and Working with Dynamic Charts in Excel

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

30+ Excel Copy & Paste Tricks You Must Know – Mouse Keyboard Autofill Paste...

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

Making Aging Analysis Reports Using Excel – How To

Aging analysis is helping accountants since ages and is one of those reports that are prepared mostly in Excel to track both receivables and payables. So today we are learning how to conduct aging...

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

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

Remove leading Apostrophe (‘) in Excel Data from Numbers and Text – How To

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

Excel Pivot Table Slicers: Old Filters got Overhauled!

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

How to quickly fill cells with 0 (zero) – Excel Quick Tip

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

Excel Pivot Table tutorial for Absolute Beginners: Creating your First Pivot Report [2 of...

In 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 pivot table let...