Hasaan Fazal
Excel Most Wanted - Selection shortcut keys Mega collection
While working in Excel or any data related job selection is one job in itself. And even in Excel it is not easy when you making your way through thousands of cells. However, life is much easier if you know selection tricks Excel has to offer and even better is they come in shape of shortcut keys […]
One minute Excel Tutorial - Watch Window
Accountants and analysts around the world does one amazing job and that is they give the meaning to mammoth data by processing it using their skills and the same information is then used by managers to make decisions. Everyone wishes to be an analyst or a consultant that people seek for advice. However, as we […]
What is the difference between Audit engagement and Assurance engagement?
In few words, all audit engagements are assurance engagements but not all assurance engagements are audit engagements. Audit engagement is one type of assurance engagement that provides reasonable assurance. Assurance engagements can be reasonable assurance engagements, limited assurance engagements or other assurance engagements. Other assurance engagements are such assurance engagements that are other than audit […]
Excel for Accountants - Introduction to Excel Interface
To understand anything we must first understand what each of the visible components can do and only then we can understand what it really holds for us including what is not visible for the time being. When we double click excel icon and application runs. Our eyeballs witness many things inside that application window. Before […]
What is the difference between a Fair presentation framework and a Compliance framework?
Financial statements are prepared to fulfill information needs of its users. In order to cater the needs at best a certain financial reporting framework is used considering the jurisdiction in which the entity and/or its users exist. For example two of the popular financial reporting framework are IFRSs and US GAAPs. However, talking about the […]
How to account for change in residual value of fixed asset?
International Accounting Standard (IAS) 16 recognizes that residual value of asset may increase or decrease as a result of revaluations or future assessments of non-current asset. IAS 16 recognizes such change as a change in accounting estimate i.e. adjustment will be prospective in nature. There is no need to adjust for previously recorded depreciation charge […]
Excel challenge of the Week April 28 - Got to watch movies!
OK there lots of movies coming out in the year 2013. Some has already been released and some are yet to be screened in cinemas. Now we have one film fanatic who has no idea what movie should he watch. He watches movies from different genre i.e. action, thriller, horror etc. Deadline: Two weeks i.e. […]
Excel Custom Shortcuts - Reaping real benefits of Quick Access Toolbar
Many excel beginners especially those who are using version 2007 and later a small bar which is by default placed above ribbon alongside the title bar and many recognize it for its UNDO button. Well it deserves a respect because if it is a toolbar than actually it means efficiency and by overlooking it we are overlooking […]
How to show 0 (digit) as text ZERO or Nil or anything in Excel
Excel is about measuring and calculating but it is not only just numbers it can also help you make the information more understandable and user friendly. In calculations we often get a result 0 instead of any positive or negative digit or number. If you desire highlighting this result and instead of a digit 0 […]
What is meant by deviation from controls?
Simply put; an instance or activity that did not occur as per expectations is considered as deviation. For an activity it is not necessary that it must occur as per expectations but also non-occurrence can be considered as deviation. In short, any thing that given rise to conflict between expectation and what actually happened is […]