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 – Identify Unsearchable PDFs Within Folders
This fast tip demonstrates how to use a free tool called Count Anything to identify which PDF files are unsearchable. Sean O’Shea shared this tip in his article entitled Where Are My Unsearchable PDFs. Source: Sean O’Shea
Fast Tip Friday – Remove Background From Photo Using PowerPoint
This fast tip demonstrates how to make a photo transparent by removing the background using Microsoft PowerPoint.
Fast Tip Friday – Signing a PDF Document Electronically
Gone are the days where we need to print a PDF document, handwrite our signature on the paper version, scan the paper into a PDF file, and then email the PDF file. We can use Adobe Reader or Adobe Acrobat to electronically sign the PDF document and save a signed (and flattened) version of the…
Fast Tip Friday – Increase Search Speed Within a Large PDF
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.
Fast Tip Friday – Column Mode Insert Using Notepad++, UltraEdit and TextPad
This fast tip demonstrates how to use column mode (block mode in TextPad) to insert a column using Notepad++, UltraEdit and TextPad. Download Sample Files
Fast Tip Friday – Split Zip Archive Using 7-Zip
This fast tip demonstrates how to create a split zip archive. This is useful if the one large zip file is too large to email or it won’t fit on a single CD. For more information, see my Tools of the Trade series 7-Zip article.
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.