Thank you for listening to my presentation at the NVLSA event on January 12, 2016. On this page, you will find all of the resources mentioned in my presentation. In addition, for some tutorials, there is a link below the video to download sample files.
If you have any questions, please feel free to [encrypted_email text=”email me.”]firstname.lastname@example.org[/encrypted_email]
If you are interested in viewing all of the Fast Tip Friday tutorials, click here.
Scenario: You have two similar lists of information and you need to identify the differences between them.
Solution: Use “conditional formatting” in Excel to compare the two lists and highlight the differences.
Tutorial: All roles within a legal team have had the need to compare two lists of bates numbers. This fast tip will share one easy way to do that using Excel.
Scenario: You have a long list in Excel and you need to copy a value or a formula all the way down to the end of the long list.
Solution: Use the “fill handle” feature in Excel – but wait, no need to hold down the fill handle while you scroll, and scroll, and scroll down the worksheet.
Tutorial: This fast tip demonstrates one particular way to use the fill handle in Excel.
Scenario: You have received a deposition video or some other video in a VOB format and you need to easily share the video or view the video on all devices.
Solution: Convert the video to an MP4 format using a free program called HandBrake.
Tutorial: We often receive videos that are in VOB format and we would prefer to convert them to a more user friendly MP4 format that plays on more devices. This fast tip demonstrates how to easily convert the file using Handbrake.
Scenario: You have a very large PDF file and performing searches within the PDF is a slow process for each search.
Solution: Increase the search speed by adding an embedded index to the PDF file.
Tutorial: Sometimes we receive very large PDF files with thousands of pages and of course we then need to run searches within the file. When the PDF file is very large, each search can take a while to run. This fast tip demonstrates how to use an embedded index to increase the search speed.
Scenario: You have folders and subfolders containing many PDF files and you need to easily search across all of the PDF files at once.
Solution: Create a full-text index across multiple PDF files.
Tutorial: This fast tip will demonstrate how to create a full-text index across folders and subfolders of PDF files. This enables the user to run searches across all of the PDF files at once, including bookmarks and comments if desired.
Scenario: You have added many redactions across a PDF file – and then someone tells you they would prefer that all of the redactions be formatted a different way.
Solution: Use Adobe Acrobat to bulk edit the redaction formatting across all redactions at once.
Tutorial: Once redactions have been added to a PDF file, if someone has a different preference for how the redactions should be formatted, this fast tip demonstrates how to bulk edit the redaction properties.
Scenario: You have many witness folders on the server and you need to add an Exhibits subfolder underneath each witness folder.
Solution: Use an Excel VBA macro to create the subfolders automagically.
Tutorial: Have you ever needed to add the same subfolder to a bunch of existing folders? For instance, let’s say you have a list of folders that are named by custodian and you need to add an Exhibits subfolder to each and every custodian folder. This fast tip demonstrates how to automate the task using an Excel macro.
Scenario: You need to create a bunch of folders on the server by custodian name in order to organize the incoming electronic data.
Solution: Use an Excel VBA macro to create the folders automagically from a list of names in an Excel worksheet.
Tutorial: When we collect and process electronic data from a number of custodians, we usually create a folder for each custodian to store their data. This fast tip will share a shortcut for creating those folders that can save us a bunch of time.