Videos about Microsoft SQL Server, Excel, and much more – for way less than $30
Introduction There may be many reasons why you can suddenly find yourself faced with investigating tens of thousands of files. Maybe you have a new job, or are appointed in charge of an on-going project, and you now have access to existing files. Maybe you are a consultant, receiving your client’s raw data for the first time. It’s possible that […]
Read moreGPS 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 moreIntroduction Sharing information easily is a very 21th-century concept, but it creates its own set of headaches. This article will look at those problems, whether they be over networks, hosted clouds or personal clouds, and how they can be overcome. Why collaboration tools are great Networks are great. They enable people to collaborate on projects, to organise files in folders […]
Read moreGoogle Maps Longitude and Latitude from GPS can be mapped using a variety of online resources, such as Google Maps. For example, to map a location which is 51 degrees, 33 minutes and 21.6 seconds North, 0 degrees 16 minutes 46.2 seconds West: Go to maps.google.com Enter the co-ordinates in the following format: 00 00 00, 00 00 00, where […]
Read moreIn the past three articles in this series, we created a Pivot Table based on file extension and date information, added a Pivot Chart and a slicer. Slicers can be very useful to filter the presentation and focus the charts and tables. An example of a slicer is on the right. However, If this approach to interactivity looks a little…well, wordy, […]
Read moreGPS co-ordinates are partially available in Windows Explorer. In order to access them, right-hand click on a photograph in Windows Explorer and go to Properties. Then right-hand click on the Details tab, and scroll down to the bottom. The GPS data is listed underneath the Image, Camera and Advanced Photo sections. The Latitude and Longitude are shown in degrees, minutes […]
Read moreCreating 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 moreIntroduction It may be that you are interested in the history of your files. Or it could be that you have received a few (thousand) files from a client or third party, and you want to see what sort of information you have available. It can be important. In one job I received three CDs full of correspondence in jpeg […]
Read moreProblem with my Ho Ho Ho cards. ‘Twas seven nights before Christmas, and all through the office, I was setting the computer up to send 840 electronic Christmas cards. This could have been a difficult job, but I wrote a VBA macro to create individual e-mail cards with “Dear INSERTNAME”, followed by the card itself. I had also set up […]
Read moreIntroduction MSG files are emails, calendar entries etc. which have been exported from Microsoft Outlook, either manually by dragging them onto the desktop, or through an automatic extractor. This previous article shows how generally you can view document properties in Windows Explorer. This article will investigate how these methods work for MSG files. Viewing MSG metadata in Windows Explorer The […]
Read more