Pivot Table
by 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 …
Author: Theintactfront
Mechanical,MBA,Knowledge and Peace.
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
