Pivot Table
A pivot table allows you to organize, sort, manage and analyze large data sets in a dynamic way. Pivot tables are one of Excel’s most powerful data analysis tools, used […]
What If Analysis
By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results. For example, you can […]
Conditional Formatting
Conditional formatting is useful for highlighting certain results in an Excel financial model. For example, breaches in financial ratios or bank covenants. If a financial ratio in the model is […]
Excel as a Tool in Financial Modelling: Basic Excel in Brief
Financial modeling is one of the most highly valued, but thinly understood, skills in finance. The objective is to combine accounting, finance, and business metrics to create an abstract representation […]
Concept of Auditing and Standards
Auditing standards provide minimum guidance for the auditor that helps determine the extent of audit steps and procedures that should be applied to fulfill the audit objective. They are the […]
Detection and Prevention of Frauds
Detection and Prevention of Fraud: When something is being done with an intent to deceive, to mislead or to conceal the truth, it is an art of fraud. It is […]
Detection and Prevention of Errors
Errors of Principle When principles of book-keeping and accountancy are not followed such an error is error of principle. For examples Treatment of revenue expenditure as capital expenditure or vice […]
Basic Principles Governing an Audit
Auditing is a systematic and scientific procedure of inspection of the financial statements of an organization. And like any scientific procedures, the audit also has certain principles and rules that […]
Limitations of Auditing
Rely on Experts An Auditor has to rely on experts like engineers, valuers and lawyers for estimation and valuation of fixed assets and estimation of contingent liabilities. Efficiency of Management […]
Accounting and Auditing
Accounting and audit have a pivotal role to play in the financial record keeping process of any business though their roles are different in their focus. While accounting translates to […]
