mapping Use an Excel Pivot Table to Count and Sum Values December 3, 2019 / February 5, 2026 by Adam DuVander So, you have data and you need a quick way to make sense of it. A PivotTable is a great option and it is one of Excel’s most powerful tools. We’ll walk you through what a PivotTable is, preparing your data for a PivotTable, quickly performing analytics using a PivotTable to Count and Sum your […] Read more »
mapping US Retailers by Revenue: $2.7 Trillion in Sales on a Map November 12, 2019 / February 5, 2026 by Adam DuVander As another year comes to an end, we took a look back to see which stores competing for business did the best. Thanks to company reports of retail sales (all of which are in the billions, by the way), we know the top 100 stores of the year. The retailers that made the most include […] Read more »
mapping Latitude and Longitude in Excel: Calculate Distance, Convert Degrees, and Geocode Addresses November 5, 2019 / August 25, 2025 by Adam DuVander If you have a long list of geographic coordinates to work with, a Microsoft Excel spreadsheet is sure to be useful. There are three basic Excel tools that can work for you, no matter how you want to manipulate your geographic coordinates. You’ll need to know how to calculate the distance between two latitude and […] Read more »