Tag Archives: article

Creating GPS slideshow with Microsoft Power Map

GPS co-ordinates can also be mapped by time. Firstly, four things are needed: Latitude in decimal form. How to convert degrees/minutes/seconds into decimal form is discussed in the article “Converting GPS degrees/minutes/seconds into decimal form“. Longitude in decimal form, Date taken, and Microsoft Excel 2013 (or Office 365 ProPlus) with Power Map. This regards either a standalone version of Excel […]

Read more

Enhance your Microsoft Excel Pivottables with Pivotchart and slicers

Creating a Pivot Charts In the previous two articles in this series, we looked at creating a Pivot Table in Microsoft Excel based on textual data such as the file extension or author name, and investigating date information. At the end of the second article, we created a PivotTable, grouped by year, quarter and month. In this article, I’m going to […]

Read more
1 2 3