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...
Formatting Numbers in Excel – Conditional Formatting Vs Custom Number Formatting
Accountants are always dealing with numbers. And its not always about highlighting positives. In some cases we have to make negative numbers standout and...
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...
Formatting Dates in Excel the better way using Custom Number Formatting – How To
Time is of prime importance and having dates in your data is most of the time essential bit of whole. However, making the dates...
Using Excel Custom Number Formatting as Data Validation Tool
Excel custom number formatting feature is immensely powerful. From hiding things to formatting telephone numbers correctly, to changing colours to use them to insert...
Calculate the difference between two times in Excel
Its tough to manage times and sometimes it is difficult to manage the time related calculations even in Excel. Suppose you have a situation...