Videos about Microsoft SQL Server, Excel, and much more – for way less than $30
If you want to download random documents, such as Microsoft Word, as used in the articles “What document properties are actually used in .doc/.docx files“, then go to Google and click on Advanced Search. Unfortunately, the location of Advanced Search changes according to which version of Google you are using. One way is to do a search, and click on […]
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 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 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 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 moreIntroduction If you are looking for picture and photo propertes generally, please click this link. Got a new iPhone, and are wondering what additional details its photographs can hold? In order to analyse this, we took photographs from the iPhone 4, 4s and the recently released iPhone 6 Plus, and used Filecats Professional to have a look at the photographic […]
Read moreCamera Maker and Model This data which a camera or camera-phone adds to each photograph which is taken. It reveals the make and model of a particular camera. Identification of this makes it very easy to identify photographs which were taken by different cameras. It may be edited by software, including Windows Explorer, so its presence does not mean for […]
Read moreIt is possible that the metadata which is available to PowerPoint presentations might be actually be used in real-life presentations. Therefore, 1,180 PowerPoint presentations were downloaded at random (see methodology), and the metadata extractor Filecats Professional imported the metadata into Microsoft Excel in order to find out what document properties were actually used. The results are as follows: Common metadata […]
Read moreWhilst it may be interesting to know in theory what metadata is available for use in Excel documents, the actual document properties used in real Excel spreadsheets might be different. To find this out, 1,113 Excel workbooks were downloaded at random (see methodology), and the metadata extractor Filecats Professional has been used to extract the metadata to see what document […]
Read more