This fast tip demonstrates how to use the VLOOKUP function in Excel to compare two lists of bates numbers and then a couple of ways to visually present the results.
In a previous fast tip, I demonstrated an alternative way to use Excel to compare two lists.
This fast tip demonstrates how to use a free service that will monitor a web page for changes (additions/deletions) and send an email notification. It might be helpful to monitor docket listings or a web page for a specific client or case.
This fast tip demonstrates a built-in feature with MS Word that will insert sample (filler) text that can be used to assist with a training session or designing a template document. The Lorem Ipsum text comes from the publishing and graphic design industries. Each version of MS Word will insert different sample text.
One of my favorite features in MS Word is Format Painter. This fast tip demonstrates how to use it in two ways. Download Sample Files
This fast tip demonstrates how to delete a persistent drive mapping using a DOS command.
This fast tip demonstrates how to restrict editing to specific portions of an MS Word document while making the rest of the document read-only.
This fast tip demonstrates the benefits of using MS Word section breaks instead of tables to list items in your resume. Download Sample Files
Great tip Amy. I only use vlookup about every 2-3 hours of each and every day at work.
One further point, we tend to sort both lists in the same order first as I think there was a time back in the dim past when we didn’t and had some false results.
Wow, that’s a lot of lookups. Ha! Thanks for adding your important point.