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