Category: Excel

Posted on: September 8, 2020 Posted by: ndconsultingllc Comments: 0

Excel: Sort Column By Color

Sorting in Excel is a pretty simple #techtip, but thought I would share since several clients did not know Excel allows sorting by cell color. Use case: You have a column filled with data, and you’ve used colors to code the values. You want to sort all the “green” cells…

Posted on: July 23, 2020 Posted by: ndconsultingllc Comments: 0

Excel – Multiple Tabs to CSV

The Problem Several associates have asked me how to easily export an Excel workbook with multiple Excel tabs into a CSV file. I find myself going back to this script very frequently, particularly when I have data that I need to import into a database table. Using PowerShell, you can easily…