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.
This fast tip demonstrates how to easily spot patterns using more than simply adding color to a cell.
This fast tip will demonstrate how to use the Bulk Rename Utility software with a text file that will instruct the software how to rename the files. To learn more about the concatenate function used in this tutorial, see my article entitled Concatenate – Fancy Word, Simple Meaning. Download Sample Files
This fast tip demonstrates one way to convert a date-time value to date-only in Excel. Download Sample Files
This fast tip demonstrates how to apply paragraph formatting in MS Word to avoid widows and orphans, as well as controlling whether a paragraph is allowed to break across two pages.
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. Download Sample Files
This fast tip demonstrates how to export Excel comments to an MS Word document. The list of comments will also include the cell reference and the comment author. Download Sample Files
This fast tip demonstrates how to use the reveal formatting feature in Microsoft Word. It can really save the day!
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.