How to Add Cities to a Map in Excel 🔥 [Lesson 6]
In lesson number 6 in our miniseries on making a visual inforgraphic in PowerPoint you'll learn how to add cities to our United States heat map. Frist we'll duplicate the map, add our city data, and convert the range to Excel's Geography data type. This will add cities to the map so you can get a more exact picture of where the cities sit on the map. We'll use this map in our next lesson where we'll make custom icon pins to match the ones we see in the infographic example from the Visual Capitalist.
------------------------------
⌚ Timestamps
------------------------------
00:00 Ahoy! 👋
00:40 Duplicate Map
01:04 Insert New Map Data
02:15 Geography Data Type for Cities
03:30 Format Map Colors
------------------------------
📣 Shoutouts
------------------------------
Visual Capitalist on Instagram / c8z-5ztyins
Visual Capitalist on YouTube / @visualcap
---------------------------------
▶️ Related Videos
---------------------------------
(Re)Making an Infographic in PowerPoint • (Re)Making an Infographic in PowerPoi...
My Top 10 BrightSlide Features • Top 10 PowerPoint Design Tips with Br...
Visual Capitalist on Instagram / c8z-5ztyins
-------------------------------------------
💻 Template Downloads
-------------------------------------------
Zip Code Lookup Template [Excel] https://spotlightimpact.gumroad.com/l...
Square Carousel Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
10 Minute Timer Slide Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
Net Promoter Slider Chart Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
Waffle Chart Template [Excel] https://spotlightimpact.gumroad.com/l...
Data Placemat or Dashboard Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
------------------------------------------
🙏 Support My Channel
------------------------------------------
SUBSCRIBE to this channel for more tips, tricks, and tutorials! / @spotlightimpact
JOIN Spotlight Super Fans for early access to weekly tutorials / @spotlightimpact
HIT the SUPER THANKS 💗 button on any video!
DOWNLOAD templates from on Gumroad https://spotlightimpact.gumroad.com/
DOWNLOAD templates from Payhip https://payhip.com/spotlightimpact
BUY stickers, I 💗 CHARTS! https://spotlightimpact.creator-sprin...
-----------------------------------------
🎒 Courses & Affiliates
-----------------------------------------
Depict Data Studio Courses https://depictdatastudio.teachable.co...
Excel University https://affiliate.excel-university.co...
Miss Excel (Opens monthly) https://links.miss-excel.com/exclusiv...
------------------
🙋 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.
#powerpoint #powerpointtutorial #infographic
Смотрите видео How to Add Cities to a Map in Excel 🔥 [Lesson 6] онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Spotlight Impact Data Design 16 Октябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 179 раз и оно понравилось 8 людям.