How to Make a US Heat Map in Excel with Zip Code Lists! 🗺️ [Lesson 9 of 11]
⚡ 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