This fast tip demonstrates how to create a dropdown list in an Excel workbook that pulls in values from a list in another workbook.
In another Fast Tip Friday, I demonstrated how to create a dropdown list from another worksheet.
This fast tip demonstrates how to easily remove names from the auto-complete list in Outlook.
Have you ever wondered what is taking up so much space on your hard drive? Have you ever wanted to get an overview of the file contents that just arrived on an external drive? This fast tip demonstrates how to use Treesize Free to break down hard disk space usage down to the file level.
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 will demonstrate how to use DOS commands to create a file listing. In another Fast Tip Friday, I demonstrated how to get a list of all files in a folder using an Excel macro. Download Sample Files
This fast tip demonstrates how to use Revo Uninstaller to do a much more thorough software uninstall process. Most default uninstallers provided by the software creator will leave orphan files on your computer.
This fast tip demonstrates how to save a web page to your hard drive.
Very good Amy, showing off some of the more advanced database like (or database-lite) features of Excel.
Thanks Matthew. I am trying to choose topics that are easy to implement.