Download FY 2014 - MISDATA Home
Transcript
8/2/2013 Report Tips If duplicate records are found in the Excel report they can be removed using the tool on the Data tab Select the criteria for determining the duplicate removal Page 33 Reports Tips • Sorting and filtering – Excel files have default safety features the prevent accidental corruption of the spreadsheet data – A protected view banner • Recommendation – Disable these defaults before sorting and filtering • Enable editing first, unwrap text and remove merge and center 34 Page 34 17