Fast Tip Friday – Cool Visuals in Excel
This fast tip demonstrates how to easily spot patterns using more than simply adding color to a cell.
Similar Posts
Fast Tip Friday – Cut Out Sections of a Screenshot
We create a lot of screenshots in litigation support. We use a number of different software tools to create the screenshots. My favorite is Snagit. This fast tip demonstrates one of my favorite Snagit features and I provide some examples of why I use it. For reference, you can read my previous Snagit article.
Fast Tip Friday – Search and Highlight and Extract Pages
This fast tip demonstrates how to use an Adobe Acrobat action to perform searches across multiple PDF files, highlight all of the terms and extract the pages that have hits highlighted. The highlight colors available to use in the javascript are listed below: color.transparent color.black color.white color.dkGray color.gray color.ltGray color.red color.green color.blue color.cyan color.magenta color.yellow…
Fast Tip Friday – Create Batch File to Relocate and Rename Files
This fast tip demonstrates how to create a batch file that will copy files from one location to another and rename the files in the process. In this tutorial, I referenced three previous articles: Fast Tip Friday – Using DOS to Create File Listing Fast Tip Friday – Excel Fill Handle Double Click Concatenate –…
Fast Tip Friday – Using IFTTT Recipes to Connect Your Favorite Apps and Devices
This fast tip shares a website called IFTTT that allows you to set up automations that will take action automatically.
Fast Tip Friday – Create Excel File Report Using Excel Macro
In electronic discovery matters, we tend to collect a lot of Excel files from our clients. This fast tip is an interesting Excel macro that generates a report of all of the worksheets within all of the Excel files in a folder. Download Sample Files
Fast Tip Friday – Create Excel Pivot Table to Count Values in a Column
This fast tip demonstrates how to create a simple pivot table that will count the unique values in a column. Download Sample Files
Very interesting, Amy. I haven’t tinkered much at all with those functions, one of my team uses the show duplicates function from conditional formatting, will have to spend some time exploring.
Gotta brighten up those Excel reports somehow. Ha!
Thanks for sharing this Amy. I have not done much in the past with Conditional formatting. But will now tinker with it. You were always an expert with Excel.