Fast Tip Friday – Create Excel Pivot Table to Count Values in a Column
This fast tip demonstrates how to create a simple pivot table that will count the unique values in a column.
Similar Posts
Fast Tip Friday – Column Mode Fill Using Notepad++, UltraEdit and TextPad
This fast tip demonstrates how to use column mode (block mode in TextPad) to replace columns using Notepad++, UltraEdit and TextPad. Download Sample Files
Fast Tip Friday – Get List of All Files in a Folder Using Excel Macro
In a previous FTF video entitled Using DOS to Create File Listing, I demonstrated how to use DOS commands to create a file listing. This fast tip demonstrates how to use an Excel VBA macro to generate a file listing in Excel. In other FTF videos I have demonstrated how to use Excel VBA macros…
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 – Search and Redact Regex Text Patterns Using Adobe Acrobat
This fast tip demonstrates how to search for custom text patterns using regular expressions and then redact the text. UPDATE: When searching for the XML file locations, you may need to unhide system files before running the search so that you can see this additional location under your user profile: C:\Users\[user profile name]\AppData\Roaming\Adobe\Acrobat\[Acrobat version]\ Preferences\Redaction\ENU. You can…
Fast Tip Friday – Search and Highlight Across Multiple PDFs
This fast tip demonstrates how to use an Adobe Acrobat action to import a search term list, perform searches across multiple PDF files, and highlight all of the terms. The highlight colors available to use in the javascript are listed below: color.transparent color.black color.white color.dkGray color.gray color.ltGray color.red color.green color.blue color.cyan color.magenta color.yellow If you…
Fast Tip Friday – 3 Privacy Tips For Your LinkedIn Profile
This fast tip demonstrates several tips for controlling the privacy of your LinkedIn profile. If you don’t have a LinkedIn profile, you should definitely create one. Nowadays, all professionals are expected to have one. Not having a LinkedIn profile can leave a poor impression.