Excel USA Add-in – 3digits ZIP-Code Map
The Excel USA Add-in – 3digits ZIP-Code Map (postcode area) is a smart and powerful Excel tool to transfer Excel data – based on the ZIP code numbers (Address-Data, KPI-Values and Labels) – automatically on an integrated Vector-Map for Excel-Worksheets and for PowerPoint Presentations.
Prepare Management decisions faster than ever. In just three steps you can transfer your locations on a US Postcode boundary map (ZIP-Code Level 3-digits) in Excel and / or into your PowerPoint Presentation
Preview: Excel USA Add-in – 3digits ZIP-Code Map
Protect your company data and work offline with clear KPI-Values by Regions and geographic Layers. Increase your Sales and Marketing Activities by Heatmaps – use Points, Shapes and Labels from your own Excel Data-Source to increase your KPI-Dashboards in PowerPoint.
1. In Excel: prepare data according to the supplied sample files
2. Select your Range and create your own heatmap, colorramp and set Points (CRM-System or Values)
The Excel US Add-in is suitable for business simulations and designed for sales and marketing presentations, potential analysis, CRM solutions or for your regional service center orientation. An intelligent algorithm ensures the highest precision in the geographical representation of your data and location points.
Use “The Golden Rule” and IBCS-Standards for Reporting:
Simple data structure in Excel + Digital Maps for PowerPoint + Your KPI Values = successful reports
Features at glance
Privacy – Protect your Data
Easy to use and totally offline – to protect your company data source. No Google-Map, Bing-Map or other web-based solutions or services you need.
Setting Locations – with postcode number or addresses from Excel Source
Cities and Points are displayed automatically and precisely on the basis of postal code numbers on the Excel map and formatted according to your data (size and color ramp).
The Regions, Shapes and Areas can be automatically colored, depending on your data source (sum or number) and options.
Excel USA Add-in – 3 digits ZIP-Code Map
- US Boundary Map with three digits postcode areas as boundary-Shapes – editable vector map
- Macro to transfer Excel Data into Map, colorize Shapes automatically (Count, Sum)
- Set individual Markers by Types (Circle, Rectangle, Triangle or own Icons – e.g. Company Icons and Pictures)
- Marker size by Excel-Values – dynamic of fixed size
- Marker Colors – individual or by color ramp, heatmap
- Simple Redesign (CI-Conform) with classic Excel Functions
- High display resolutions: Ideal for printing on large paper sizes or beamer presentations
- Simple to use: No VBA or Programming skills required.
- Security: No Bing-, Google or other web-based solutions
- Quick-Tutorial – PDF-File – US/UK
- Compatible with MS Office 2010, 2013, 2016, 2019 (365) – MS Office 32-bit System, not for MS Office for Mac.
- Operation Systems: Windows XP, Windows Vista, Windows 7, Windows 10
- License: 1 Single User
Example – Harvey-Balls on the three digit zip-codes Map:
Example Map for Reporting
create heatmaps by excel values, ranges
All postcode areas and labels can be edited with the simple Excel functions – thanks to the correct naming of forms and shapes.
Use LAT and LON Values to set Points or locations on a US-Map.
Simple to prepare the Excel-Sheet to set Points on a US map, use your own label, sales region and enter in the next column latitude and longitude values into the sheet.
Output US Excel Map with Points and Labels
Export your Excel US-ZIP-Code Map to PowerPoint Presentations. Use the Function “copy maps to powerpoint” to export all shapes and labels to the PowerPoint slide.
For customizing your US-CRM Database-System, modifying your KPI-System or programming VBA for MS Access, Excel add-ons with 5 digits ZIP-Code Map, PowerPoint oder MS BI-System please contact our consulting company stallwanger IT.