Geography of Crime

Geography of Crime Geography of Crime Geography of Crime

Podcast Episodes

CAP KNOWLEDGE CENTER

Talks & Presentations

Geography of Crime

Geography of Crime Geography of Crime Geography of Crime

Podcast Episodes

CAP KNOWLEDGE CENTER

Talks & Presentations

Home
Podcast Episodes
CAP KNOWLEDGE CENTER
About Me
Excel Videos
ESRI Videos
Google Videos
News Articles
Talks & Presentations

Home
Podcast Episodes
CAP KNOWLEDGE CENTER
About Me
Excel Videos
ESRI Videos
Google Videos
News Articles
Talks & Presentations

Excel Tutorials

CSV to Workbook - Sorting - Filtering - Copy/Paste - Snip (Old Teaching video)

Snipping & Data Analysis Add-In

Filtering Data

COUNTIF & SUMIF

XLOOKUP & COUNTIF

INDEX & MATCH to Join Data (alternative to VLOOKUP)

UNIQUE

SWITCH

Percent Change

Selecting Blank Cells & Filling Down

Merging Data with Power Query

Rank Values

SIGNIFICANT CHANGE IN COUNTS

BLANK TEXT VALUES

DATE CREATION

REMOVE DUPLICATES - CONSOLIDATE - TEXT TO COLUMNS - FLASH FILL

PIVOT: ROW & COLUMN TOTALS

PIVOT: TEMPORAL HEAT MAP

PIVOT: SLICER

PIVOT TO MAPPING

TREEMAP

APPEND DATA

LAW OF CRIME CONCENTRATION

80/20 RULE - RISKY FACILITIES

eXCEL MAPPING

COUNTY MAP

STATE MAP

STATE & COUNTY MAPS

POINT MAP

VBA Geocoding with Google

PIVOT TO 3D MAPPING

MAPPING POLICE AGENCIES (points)

MAPPING DIFFERENT SPATIAL UNITS

CUSTOM REGIONS - Police Districts

CUSTOM REGOINS - NEIGHBORHOODS

CUSTOM REGOINS - BLOCK GROUP DATA

FIREARM MOVEMENT

arcgis in excel

How to Integrate Arc into Excel

Using ArcGIS in Excel

Excel to ArcGIS Pro

Copyright © 2025 Geography of Crime - All Rights Reserved.

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.