Update: There’s a more recent version of this article published here – Visualising geographic data in Excel 2016. If a picture says a 1,000 words, then a beautiful interactive map overlaid with ...

When you first generate the 3D map, Excel will review your column headers and try to identify which column contains the geographical data you want to plot.

In this month’s installment of my Excel dashboard series, I’m going to show you a trick that will give you the ability to control an entire dashboard with one menu — in this example, a radio ...

Spin buttons enable incremental value adjustments. Option buttons allow selection of one option from a group. Form controls can be combined to create interactive dashboards.

Office 2011 brings Visual Basic for Applications (VBA) back to the Mac. If you haven't used VBA before, and don't know why you would, here's a good example of how simple and useful it is.