by Naiyer Jawaid | Jul 14, 2016 | Excel
If you are using Excel 2013, I'm sure you must have encountered be careful Excel warning. When you try to save a workbook, suddenly a pop-up appears saying 'Be careful! Parts of your document may include personal information that … by Naiyer Jawaid | Mar 29, 2016 | Excel, Finance
… by Naiyer Jawaid | Jan 5, 2016 | Charting, Excel
Hatched charts in Excel look beautiful. They look cool and professional. Hatching or shading between plotted lines enhances charts and helps to convey the story. Crating Hatched Charts in Excel Creating hatched charts in Excel is rather easy (I'm using... by Naiyer Jawaid | Oct 5, 2015 | Excel, Finance, Formulas
Have you ever wondered how does Excel calculate irr (internal rate of return)? I never gave it a second thought until I wrote a post on the issues with NPV calculation in Excel. Our reader, Deyan, pointed out that... by Naiyer Jawaid | Aug 19, 2015 | Excel, Finance, Formulas
Future value calculation in Excel can be done either by using Excel FV formula or by manual calculation. Before we get into the calculations, let's review the concept of future value. We have discussed the time value of money earlier....