![Making Interactive Charts in Excel [How To]](../../../../wp-content/uploads/2013/05/excel-tips-and-tricks-150x150.png)
Making Interactive Charts in Excel [How To]
Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one combination not to miss when you are learning Microsoft Excel application. But sometimes even the charts are so laborious that you wish […]
![Understanding Excel CHOOSE() function [Intro]](../../../../wp-content/uploads/2012/09/excel-page-featured-image-150x150.png)
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 1, if it is 2 life will return 2. So life is a perfect response to our intentions and actions. […]
Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function explained]
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 @ symbol) and the domain name (part at the right of @ symbol). For example [email protected] has the username hasaanfazalpk and gmail.com is the domain name. So consider […]
Creating Currency Converter in Excel [How To]
In the world we live in where almost every country has its own distinct currency and value, we almost always feel a need to convert one currency to another. These days it is easy as we can look for them over the internet and calculate how much a dollar is in terms of Pakistan Rupee. […]
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 to thought that when you create a chart the selected range is locked tight so show graph therefore if the data […]
Excel Conditional LOOKUPs - Applying VLOOKUP on multiple ranges
We all love LOOKUP functions in Excel and the heart favourite is VLOOKUP. We are well introduced to VLOOKUP and have already seen VLOOKUP in action several times, but we never came across a situation where we have multiple ranges to look up based on a condition. For example, to calculate wages of workmen you […]
Extract File Extension from file names in Excel - [Quick Tip]
What if your manager gave you a file with thousands of file names and you have to extract file extensions? If you are following our Excel tutorials on regular basis then it won’t be a problem as we have covered few of the ways that can be used to carry out this task. General knowledge […]
Extracting Integer and Decimal portion from a number in different cells - Part 1
When it comes to information then most of the time its about numbers and often numbers come with decimals i.e. numbers that are written as: 9.82 0.9856486 1021587.986244 But what if we are only interested in decimal portion (fractional part) of the number or we are interested in the integer (integral part) of the number? […]
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 information and later extract it they way you like. However, when it comes to number, there are situations where Excel stops […]
Excel Camera tool - What, How and Why? - Snap up your spreadsheet skills
Very recently my passion for art is realized in the form of photography. I wanted it but I never knew that it will soon be an addiction and will have a name as well. And now I completely agree that when you are passionate about doing something you will always make time for it. And […]
