10+ Excel features in Home tab that every beginner MUST learn

1 Don't just Paste, Paste Special! Position in tab: Clipboard group>Paste button drop down | Shortcut: Alt+Ctrl+V This one is definitely a speciality in Excel's arsenal of features. Normal paste option only put what you copy...

My Top 10 personal favourite Excel keyboard shortcuts

Everybody has preferences and likeness towards Excel keyboard shortcuts and I am no exception. So here is my personal top 10 list of Excel keyboard shortcuts that help me immensely when going through my...

Dealing with Telephone numbers in Excel – Dialing in the correct format

Many have the impression that Excel is a tool to do maths. But the ones who are using it on daily basis know that Excel is way beyond just calculation and helps you maintain...

Comparing two columns to highlight Duplicates in the same row – Excel Conditional Formatting

Back to Excel after a long time. But now starting to relax a little as course is concluded for many subjects I teach. I really missed my Excel community and I really want to...

Adding specific Prefix to All cells or Specific cells in Excel – 3 Methods...

A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in...

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

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

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

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

Quickly fill Blank cells with the Value in the Cell Above

There are situations when you ask someone to punch data for you and they come up with one lazy idea to leave the cell blank if the same value is repeating in subsequent cells...