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 – Using Excel VLOOKUP to Compare Lists of Bates Numbers
This fast tip demonstrates how to use the VLOOKUP function in Excel to compare two lists of bates numbers and then a couple of ways to visually present the results. In a previous fast tip, I demonstrated an alternative way to use Excel to compare two lists. Download Sample Files
Fast Tip Friday – Create Subfolders Using Excel Macro
Have you ever needed to add the same subfolder to a bunch of existing folders? For instance, let’s say you have a list of folders that are named by custodian and you need to add an Exhibits subfolder to each and every custodian folder. This fast tip demonstrates how to automate the task using an…
Fast Tip Friday – Excel Fill Handle Double Click
This fast tip demonstrates one particular way to use the fill handle in Excel. Download Sample Files Source: David Carns
Fast Tip Friday – Use Checkboxes to Select Items in Windows
This fast tip demonstrates how to select files in Windows Explorer using checkboxes. Sean O’Shea shared this tip in his article entitled Check Out What Windows Explorer Can Do. Source: Sean O’Shea
Fast Tip Friday – Using Excel to Compare Two Lists
All roles within a legal team have had the need to compare two lists of bates numbers. This fast tip will share one easy way to do that using Excel. Download Sample Files
Fast Tip Friday – Create Hyperlinks to All Files in a Folder Using Excel Macro
This fast tip demonstrates how to use an Excel VBA macro to generate a file listing in Excel and then add hyperlinks to each file. Download Sample Files