Videos about Microsoft SQL Server, Excel, and much more – for way less than $30
How accessible is your data? All of it. How quickly can you access your data? If we are talking about your current data, such as your Word documents and project files, then presumably you can access it very quickly. (However, how quickly can you find documents using Word metadata or photographs taken on a particular date?) What about your other ESI data? […]
Read moreIntroduction Previous articles in this series talked about how to see how newly received files were filed, how to look at their date range and types of files, and the specifics about managing Word, Excel and PowerPoint documents. This article will discuss the proliferation of photographs, and how to harness the hidden data contained within (and why you would want […]
Read moreIntroduction In previous articles, I talked about cataloguing a new hard drive, USB memory stick or network, and discussed approaches for investigating the file structure, the type of files, and the date ranges. In this fourth article I will be discussing in particular Microsoft Office files, namely MS Word, MS Excel and MS PowerPoint. I will be dealing with emails […]
Read moreIn the recent case of Willett v Redflex Traffic Systems Inc., the defendants stated that it had scanned and searched what is called “a high-level directory of the data”, and that it produced a spreadsheet of this directory. This spreadsheet had 538,000 rows, and it includes the following information: File name, File Type, File Size, Creation date, and Last Modified […]
Read moreIntroduction The first article of this series shows how to catalog files and folders using Power Query. Now that you know the mechanism as to how to do it, this article discusses whether you should do so, looking at the advantages and disadvantages. Advantages of using Power Query Firstly, Power Query is free. You can download it from the Microsoft […]
Read moreIntroduction This is the first of three articles about an add-in for Microsoft Excel called “Power Query”. Among other features, it allows files and folders to be cataloged from within Microsoft Excel. (It also does other things, which are perhaps what it is more used for.) This article shows the process where files can be listed. It walks through each […]
Read moreIntroduction In the previous two articles in this series, I discussed scenarios when you might suddenly have a lot of new data to investigate, and how to efficiently view the folder tree and create analyses based on the file type. In this article, I will discuss another important property for initially investigating your new files – the date range of […]
Read moreThis is the second of a series of articles which concern how best to investigate tens of thousands of files that you are seeing for the first time. The previous article addressed when that might occur, and how to examine and export the folder structure so you can start to understand it. This article addresses how to look at the […]
Read moreIntroduction 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 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 more