The Life of an Auditor

  Step-1: import data Go to data tab in excel and get data from Table/Range Step-2: Look for and remove duplicate entries Select the user ID column and highlight the duplicate entries using conditional formatting in the Home tab Filter out the highlighted entries in User ID column by using the sort by colour option under the filter Now you can see the duplicate entries which are highlighted Copy these duplicate entries to separate sheet which can be used as an appendix to the report Now go to table design tab and ,click on remove duplicate entries at the top left. This will remove the duplicate entries Step-3: Insert the Pivot table Create a pivot table by clicking on “summarise with pivot table” under table design tab A pivot table will appear on a new sheet in the excel file Step-4: Document Check analysis On the pivot table you can see all the data fields and four areas 1. Filters, 2. Column 3. Rows 4. Values Add the result field in the rows area and us...