Hasaan Fazal
![Extract File Extension from file names in Excel - [Quick Tip]](../../../../wp-content/uploads/2013/05/excel-tips-and-tricks-150x150.png)
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 […]
What is Financial Instrument?
Financial instrument in essence is simply a contract that will ultimately result in financial asset in the hands of one party and corresponding financial liability in the hands of another party to the same contract. For example, invoice, bill receivable, promissory note, cheques are well known examples of financial instruments. However, the distinguishing factor between financial […]
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 […]
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 thank each and everyone of them that they have not given up on me. Love you all! During my break from […]
Adding specific Prefix to All cells or Specific cells in Excel - 3 Methods Explained
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 vain. The reason was an excel file with over 25,000 contact numbers with or without area codes before actual contact number. […]
What is the difference between Emphasis of Matter paragraph and Other Matter paragraph?
Auditor is required to express his opinion in the form of a written report called auditor’s report. Although auditor’s responsibility and also the purpose of auditor’s report is to convey primarily the auditor’s opinion on financial statements but if auditor believes that there is a matter that must be brought to attention of user of […]
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 having a negative sign is just not enough. Similarly to show zero results as “Nill” or simply leave that field blank or being filled with a dash to replace boring “0” […]
How to account for Temporary Investment Incomes on funds from Specific borrowing?
It is a usual practice that if entity has borrowed funds to finance a qualifying asset then they might be invested temporarily until the funds are needed. This gives rise to a question if these temporary investments are to be deducted from borrowing costs eligible for capitalization or taken to profit and loss account as […]
