Excel is an excellent program for data visualization. In Excel 2013, the Power Map function could be used for visualizing geo-spatial data. In Excel 2016, the Power Map function has been renamed to 3D Maps. In this movie, you will know how to create a 3D map tour and scene from a data table, then remove it.
- [Voiceover] If you are using Excel 2013…for data visualization,…specifically visualizing geospatial data,…you'd use something called Power Map.…Well, here in Excel 2016 you won't find Power Map,…it's been renamed to the 3D Maps.…We're gonna take a peek at it…because it looks a little bit different here in Excel 2016.…We're gonna do it with this file, called Power O3O3,…you'll find it in the chapter three folder…of your exercise files.…Here you can see we have four columns…but we actually have over 17,600 rows of data.…
This is ideal for data visualization.…And because the table, and we know it's a table,…from the drop down arrows at the top of each column,…because it contains state, county, for example,…this could be used in a geospatial 3D Map.…To create it, using the entire table,…all we do is click anywhere in the table,…just go ahead and click.…Now, if we wanted to,…we could select data we wanted to use…and add it to a 3D Map,…but we wanna create one using the entire table…so you don't really need to select anything…
- Recognize the changes to the user interface.
- Describe when you would use Touch mode.
- Explain how to quickly format shapes.
- Cite how to quickly choose a chart type.
- Name the pane that opens up when a picture is added to a slide and describe what it does.
- Explain how to import your contacts, email, calendars, and more.