Microsoft's 3D Mapping tool is a poor man's way of easily mapping a set of data directly from an Excel sheet. This tool is free and automatically included with Microsoft Excel 2013 and newer. All you need is a data set that contains some type of location information (address, x/y coordinates, latitude/altitude, etc). During the presentation, Diana will use a sample data and build a map from scratch. She will also show the benefit of using a table in order to update the data and how that in turn updates the created map automatically once refreshed. A handout with tip sheets will be provided and attendees will be able to refer to it during training and well as use it afterwards.
Diana Lopez is a Senior Crime and Intelligence Analyst and has been with the San Diego Sheriff's Department for exactly five years today! She has worked at multiple stations throughout San Diego County, including a specialized unit, and is currently assigned to the Vista Command. Prior to joining San Diego Sheriff's Department, Diana was a Crime and Intelligence Analyst with the Central Valley HIDTA for four and a half years before relocating to beautiful Sand Diego County. Diana has over twenty years of experience working with Excel. She learned about this free 3D mapping tool during an international IACA-sponsored webinar in Spanish over two years ago and has been using it ever since.