Fast Tip Friday – Make Excel Subtotals More Noticeable
This fast tip demonstrates how to format subtotals in Excel so that they are more noticeable.
This fast tip demonstrates how to format subtotals in Excel so that they are more noticeable.
This fast tip shares a website called IFTTT that allows you to set up automations that will take action automatically.
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…
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…
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.
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
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