Briefly explain how conditional formatting and macros can he

Briefly explain how conditional formatting and macros can help in Audit Analytics

Solution

Audit Analytics is a field which requires smart and speedy work to trace patterns and abnormalities. In this regard, Excel can be used to make an auditor\'s work easier. Conditional formatting refers to a type of foramtting which allows highlighting of cells based on certain conditions. An auditor can use it to highlight specific type of data for example overaging accounts receivables or expired purchase orders.

Similary, a macro can repeat tasks on a single instruction. An auditor can use this feature efficiently to minimize his efforts on repetitive work which occurs in an audit such as sampling and focus on the patterns and abnormalities noticed throught the work to come up with strong conclusions.