Hasaan Fazal
40+ Excel navigational shortcuts to make accounting job super efficient
With the advent of user interface we are able to use mouse and other input devices. But when it comes to speed, efficiency and productivity keyboard is still EXCELlent above anything else i.e. K is for Keyboard like K is for King. While working in excel we often have to navigate like clicking ribbon, switching […]
Resume excel session with Save workspaces feature
In accounting world some work is repetitive and accountants have to open certain set of files almost on daily basis. Opening each file by reaching the location and double clicking might not be that big a task but when it comes to productivity then it is definitely a botheration. Or simply what if you want […]
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 sheets we have a much better way for you do to do this in Excel. Have the workbook open, press and […]
What is Depreciated replacement cost?
Depreciated replacement cost is an optimised form of replacement cost method to make the estimate more realistic by adding the aspect of depreciation to a simple replacement cost concept for valuation purposes. Replacement cost is simply defined as the cost that entity has to bear in order to replace the asset with such resource that […]
How fixed assets are revalued if fair value cannot be determined using market value?
IAS 16 Property, Plant and Equipment (IAS 16) recognizes the fact that fair value of every asset may not be determined using market value basis. Although it is recommended and hardly the case where market information does not help but still exceptions exist. IAS 16 recognises such assets specialized assets for which fair value cannot […]
What is Income approach to fixed asset revaluation?
After initial recognition at cost if the carrying value of an item (of property, plant and equipment) is significantly different from the value measured on fair value basis then revaluation of asset is required. The reason is if asset is still carried at old value financial statements might give distorted view of assets. Assets are […]
50+ Excel Tricks Accountants Love by Heart! - Episode 1
I often confront a question “what to know in Excel”. Answer to this is not easy. To me Excel is like a journey and it never ends unless you stop. Similarly more you use Excel more you learn about it better you become going around things easily using Excel’s almost endless combination of features, formulas […]
One minute Excel Tutorial - Excel ‘Auto’ features
Often in data related works we have to repeat the process over and over again like writing same name. That will be so easy and error free if what we intend to write is automatically inserted for us. Or if there is a mistake then it gets corrected automatically. Who don’t like if things start […]
Excel Tutorial - Ctrl P is Power in Control (Printing)
Yeah I know even a child with rock bottom skills know how to print. But Excel’s print is not just a Ctrl + P. Its this and much more. One of the nuisance often encountered by excel users is to print same headings on each page of every print. Or what if your data has […]
One minute Excel Tutorial - Tables
Yes Excel cells and coloumns and rows and you can apply colors and borders but problem with that formatting such way is kind of static i.e. if your data expands or contracts it does not adjusts itself accordingly. Solution to this is Tables. Having your data range formatted in tables your data automatically gets several features embedded […]