How to Make a US Heat Map in Excel with Zip Code Lists! 🗺️ [Lesson 9 of 11]

Veröffentlicht am: 13 Dezember 2023
auf dem Kanal: Spotlight Impact Data Design

28,424

⚡ Support my channel with a $1.99 membership (cancel anytime!)    / @spotlightimpact

In this step by step tutorial (lesson 10 of our Analyze Zip Codes in Excel mini-course) You'll learn how to insert a United States heat map in Excel from your summarized zip code lists. Watch to the end for a great tip on making this map an SVG image so you can customize colors.

⌚ TIMESTAMPS
00:00 Ahoy
00:21 Set up your data table
01:19 Insert US Heat Map
04:44 Change Map Chart to an SVG Map Image!

🙏 Support My Channel
SUBSCRIBE for more tips, tricks, and tutorials!    / @spotlightimpact
JOIN for early access to weekly tutorials    / @spotlightimpact
DOWNLOAD templates from Gumroad https://spotlightimpact.gumroad.com/
DOWNLOAD templates from Payhip https://payhip.com/spotlightimpact
CHART 💗 STICKERS! https://www.charthearts.com/
SHOP on Amazon with my link https://www.amazon.com?&linkCode=ll2&...

💻 Download Templates
ZIP Code Lookup Template [Excel] https://spotlightimpact.gumroad.com/l...
Carousel Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
10-Minute Timer Slide Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
Data Placemat Template [PowerPoint] https://spotlightimpact.gumroad.com/l...

🎒 Courses
Depict Data Studio Courses https://depictdatastudio.teachable.co...
Excel University https://affiliate.excel-university.co...

🛒 My Gear
Microsoft 365 http://www.amazon.com/dp/B07F3TQ6DQ/r...
Laptop http://www.amazon.com/dp/B09K4GKQRZ/r...
Webcam http://www.amazon.com/dp/B09NBWWP79/r...
Mic http://www.amazon.com/dp/B007JX8O0Y/r...
Tripod http://www.amazon.com/dp/B0DP4MLMR2/r...

📚 Reads
Building PPT Templates V2 http://www.amazon.com/dp/B09GL757ZJ/r...
PowerPoint Mastery http://www.amazon.com/dp/B0F2M7ZQYG/r...
The Reporting Revolution http://www.amazon.com/dp/B0G19PWNM6/r...
Presenting Data Effectively https://amzn.to/3NxEwvW
Effective Data Visualization https://amzn.to/49Kz4P7

🙋FAQs
I’m using Microsoft 365 in my videos - PowerPoint, Excel, Word. If you don't have a feature you see here check the Microsoft support pages for a version feature list
https://support.microsoft.com/en-us
Buying courses through affiliate links above costs no extra, but gives a small percentage of the proceeds to my channel.

#exceltutorial #zipcode #excel

Auf dieser Seite können Sie das Online-Video How to Make a US Heat Map in Excel with Zip Code Lists! 🗺️ [Lesson 9 of 11] mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Spotlight Impact Data Design 13 Dezember 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 28,424 Mal angesehen und es wurde von 53 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

338,206

6.2K