🌍 How to make interactive Excel Map charts
301.4 هزار بار بازدید -
3 سال پیش
-
🔥 Learn Excel in just
🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com/
In this step-by-step tutorial, learn how to take data and transform it into a visual map using Microsoft Excel. First, we look at how to create an Excel map using two columns of data. Next, we explore how to create a dynamic map that you can interact with using a drop-down list. With a dynamic map, the maps view changes based on the user's selection. Last, we look at how to build 3D maps in Excel using Power Map, which allows you to explore your data using multiple fields, times, and filters.
👋 Additional resources
Sample spreadsheet I used to follow-along: 1drv.ms/x/s!AmxrofZZlZ-whMtzQ49KJE9lQcbhag?e=87s4Z…
How to Build Excel Interactive Dashboard: • 📊 How to Build Excel Interactive Dash...
Get started with Power Map in Excel: support.microsoft.com/en-us/office/get-started-wit…
Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com/
⌚ Timestamps
0:00 Introduction
0:55 Insert a basic map
3:26 Map optimizes view based on geographies
3:57 Create a dynamic map
9:06 Move dynamic map to interactive dashboard
10:12 Visualize data with a 3D Power Map
11:34 Animate 3D map
12:21 Wrap up
📃 Watch related playlists
Playlist with all my videos on Excel: • ❎ How to use Excel
🚩 Connect with me on social
LinkedIn: www.linkedin.com/in/kevinstratvert/
Twitter: twitter.com/kevstrat
Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
TikTok: www.tiktok.com/@kevinstratvert
Instagram: www.instagram.com/kevinstratvert/
🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
www.kevinstratvert.com/
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
3 سال پیش
در تاریخ 1400/06/03 منتشر شده
است.
301,428
بـار بازدید شده