20+ Excel Table tricks to turbo charge your data
In my last article on tables Introduction to Excel Tables - Data beyond just formatting I discussed the basics. If you are new to excel or if you think that tables are meant for just...
10+ ways to SUM Top N values in Excel data range – Ready to...
We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently...
Entering data on multiple Excel worksheets in one go
If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than instead of copying and pasting the same data on different...
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...
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...
Automating Data Entry using Data Validation in Excel
This is mainly a data entry tutorial and can be used in other scenarios as well. But as sales and price data is easily understood so I am using the same. Let me know...
One minute Excel Tutorial – Remove Duplicates
Data entry is a cumbersome job and often key punch operator ends up recording the same data again. Or if the data has been collected at different sources and on consolidation many similar instances...
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...
Calculating number of days between two dates – Excel Function Vs Common Sense
Business and every aspect of our life is about time and we have to compute days most often. To handle this Excel does provide a solution for in shape of a dedicated formula DAYS360()....
One minute Excel Tutorial – Watch Window
Accountants and analysts around the world does one amazing job and that is they give the meaning to mammoth data by processing it using their skills and the same information is then used by...