Fast Tip Friday – Make Excel Subtotals More Noticeable
This fast tip demonstrates how to format subtotals in Excel so that they are more noticeable.
Similar Posts
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 – Search and Redact Text Patterns Using Adobe Acrobat
This fast tip demonstrates how to search for email addresses, social security numbers, credit card numbers and dates within a PDF file and then redact any personal identifying information (PII). NOTE: The Search & Remove Text function can handle a maximum of 500 PDFs at a time. In another Fast Tip Friday tutorial, I demonstrated…
Fast Tip Friday – Edit Bates Numbers Using Excel Substitute Formula
This fast tip demonstrates how to use the SUBSTITUTE formula in Excel. NOTE: While I realize that we could simply replace JONES_ with JONES- in this example, I wanted to keep things simple and leave it up to your imagination to see how useful this formula could be one day in your future. 🙂 Download…
Fast Tip Friday – Download Web Pages Using HTTrack Website Copier
This fast tip demonstrates how to download pages from a website, in case you need to get a “snapshot in time” of a website for a litigation matter, using free software called HTTrack Website Copier. In a previous tutorial, I demonstrated how to download web pages to PDF using Adobe Acrobat.
Fast Tip Friday – Create Dropdown List From Another Worksheet
This fast tip demonstrates how to create a dropdown list in an Excel workbook that pulls in values from a list in another worksheet. In a previous Fast Tip Friday, I demonstrated how to create a dropdown list from another workbook. Download Sample Files
Fast Tip Friday – Bookmark and Copy Lines Using Notepad++, UltraEdit and TextPad
This fast tip demonstrates how to perform a search in a load file, bookmark the resulting lines, and copy the bookmarked lines to a new text file. Download Sample Files