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.
This fast tip demonstrates how to create a simple pivot table that will count the unique values in a column.
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 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 column mode (block mode in TextPad) to replace columns using Notepad++, UltraEdit and TextPad. Download Sample Files
This fast tip demonstrates how to use conditional formatting in Excel to highlight duplicate values within a column of data. In another Fast Tip Friday, I demonstrated how to highlight duplicate rows using Excel. Download Sample Files
This fast tip demonstrates how to save web pages to a PDF file using Adobe Acrobat.
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