
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 […]
Mechanical,MBA,Knowledge and Peace.
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 […]
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 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 […]
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 […]
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 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 […]
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 […]
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 […]
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 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 […]