Excel Tips
Create a Chart with One Click »
June 19, 2023
I have to create a bunch of charts based on data I already have in Excel. How can I speed up the process?
Use One Slicer For Pivot Tables From Different Data Sets »
June 15, 2023
I have two pivot tables that contain a Product column. The pivot tables come from different data sets, so I can not use one slicer to drive both pivot tables.
Excel 2013 Allows Slicers on Regular Tables »
June 13, 2023
New in Excel 2013, you can filter a regular data set, provided you convert the data to a table using Ctrl+T first.
Excel Data to Mailing Labels in Word »
June 12, 2023
I have address information in Excel and I have to make mailing labels.
Use an Alternate Map for 3D Map »
June 8, 2023
Maybe you want to plot quality performance in a manufacturing plant. Or which displays in a retail store generate the highest sales. The 2015 edition of Power Map lets you replaced the Globe with any alternate map image.
Creating a Video from 3D Map »
June 6, 2023
3D Map will let you tell a story by stringing together a series of scenes. You might show the whole country for 10 seconds, then zoom in to Florida and fly over Florida for a few seconds.
June 5, 2023
I’ve been using 3D Map since the first beta. Igor Peev and the Power Map team have hidden a lot of good settings inside of the product, even if they are not always evident.
Tricks for Navigating the Map in 3D Map »
June 1, 2023
You can easily fly through the map to focus on any part of the map.
Put a Pivot Table on a Map In Excel Using 3D Map »
May 31, 2023
Power Map is a new feature in Excel 2013. It was renamed to 3D Map in Excel 2016. If your data includes fields such as Street Address, City, State, Zip, Country, Continent, Latitude or Longitude, you can plot your pivot table on a map.