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...
Understanding Excel CHOOSE() function [Intro]
"Your life is what you choose it to be"
In essence whatever we give to life it returns the same. If we give peanuts, it will return peanuts. If it is 1 life will return...
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...
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...
Birth Dates Heat Map in Excel – How To
First off whoever has birthday on July the 7th my best wishes to all of them. You people have a very interesting birth date. 7 and 7. Everyone's birthday is interesting in one or...
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...
Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function...
A classical scenario to understand the excellence of Excel. There might be situations where we would like to split the email address in two parts i.e. the username (part at the left of @...
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+ 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...