Today is World Backup Day — an annual reminder to backup all your critical data. You likely know how important it is to routinely back up all your devices; it’s a trusty way to mitigate risk, anticipate unexpected events and align your work and your organization’s continuity plan. However, as someone who’s worked with data collection for litigation for over a decade, I can tell you one thing with certainty: not all backups are equally useful.

Metadata is data about data. In a Word file, the document contains all of the data: words, put into paragraphs, displayed on pages. But, as we know, behind the scenes Word also keeps metadata about the document including the author’s name and the date it was created, modified and printed.

In today's Tuesday Tip, we'll be showing you how to collect, copy and move data without accidentally changing the hidden (and extremely important) details about the file. While most eDiscovery tools won’t capture unusual metadata, you can create your own custom fields in Word. These additional fields will allow you to keep track of information that may be useful or pertinent for future reference.

Keep reading to learn how to properly manage your files during the data collection process. 

Have you ever run a complex Boolean search and didn’t know why some documents were showing up in the results?

In a previous Tuesday’s Tip post, we explained what padded zeroes are and how to add them in Excel using apostrophes or by setting the format of the field. Today, we’re sharing an alternative way you can create padded zeros – this time by using a formula. Keep reading to see how you can do this in three easy steps, and (once you’ve got that down pat) how to combine all the steps into one single formula.