MS Excel

This fast tip demonstrates how to use the Excel Power Query Modulo feature to clean up a report and make it more user friendly.   Download Sample Files    

This fast tip demonstrates how to create a batch file that will copy files from one location to another and rename the files in the process. In this tutorial, I referenced three previous articles: Fast Tip Friday – Using DOS to Create File Listing Fast Tip Friday – Excel Fill Handle Double Click Concatenate –…

This fast tip demonstrates how to use the Transpose feature in Excel.

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 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

This fast tip demonstrates how to create a simple pivot table that will count the unique values in a column. Download Sample Files

This is an adaptation of a recent article written by Jeff Bennion for the Above the Law blog. In my legal career, I have formatted hundreds of Excel files for printing, at the request of an attorney who is uncomfortable using Microsoft Excel. I use many of the same steps that Jeff mentions in his…

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

This fast tip demonstrates how to use an Excel VBA macro to generate a folder listing in Excel. In a previous Fast Tip Friday tutorial, I demonstrated how to get a list of all files in a folder using an Excel macro. Download Sample Files

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…

This fast tip demonstrates how to format subtotals in Excel so that they are more noticeable. Download Sample Files

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 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. Download Sample Files

This fast tip demonstrates one way to convert a date-time value to date-only in Excel. Download Sample Files

This fast tip demonstrates how to easily spot patterns using more than simply adding color to a cell. Download Sample Files

This fast tip demonstrates how to export Excel comments to an MS Word document. The list of comments will also include the cell reference and the comment author. Download Sample Files

This fast tip demonstrates how to use the freeze panes feature in MS Excel.

This fast tip demonstrates one particular way to use the fill handle in Excel. Download Sample Files Source: David Carns

This fast tip demonstrates how to use conditional formatting in Excel to highlight duplicate rows, sometimes referred to as duplicate records. In a previous Fast Tip Friday, I demonstrated how to highlight duplicate values using Excel. Download Sample Files