To create maps using Excel data outside of Excel, you can also use online mapping services like BatchGeo.com or Google Earth. BatchGeo.com lets you paste your Excel data directly into their web page.

John’s data set was a Bing Ads geographic location report by day for the last seven days – but use data you’re comfortable with (e.g., website analytics visitor reports). Microsoft offer some fun ...

Every self-respecting Excel user knows how to create graphs and charts. You enter some data, click the Chart Wizard icon, and you can choose from a number of different chart styles and options.

Using Excel 2016 and Google Earth, I was able to map not only the drone's flight path, but also its altitude, as shown in Figure 3. [Click on image for larger view.] Figure 3.

Open Microsoft Excel and create a new document. Draw a grid of 40-by40 cells. Divide the grid into four equal quadrants by drawing an X-axis between rows 20 and 21 and a Y-axis between columns 20 ...

One such feature is the 3D mapping feature found in Excel 2016. Recently I had a chance to try this feature out with some real-world data. In doing so, I learned not just what is possible with ...