Tables & Data, Tips, Tips & Shortcuts How to Convert Text to Dates with Text to Columns August 28, 20195 comments
Tables & Data, Tips, Tips & Shortcuts Data Cleansing Challenge: Convert Text to Time Values April 24, 201985 comments
Tables & Data, Tips, Tips & Shortcuts How to Add New Rows to Drop-down Lists Automatically – Dynamic Data Validation Lists August 13, 201839 comments
Tables & Data, Tips, Tips & Shortcuts How to Create Drop-down Lists in Cells – Data Validation Lists August 8, 201847 comments
Macros & VBA, Tables & Data The Ultimate Guide to Excel Filters with VBA Macros – AutoFilter Method July 12, 201871 comments
Macros & VBA, Tables & Data Why Table Number Formatting Doesn’t Copy Down and How to Fix It March 8, 201824 comments
Macros & VBA, Tables & Data, Tools 3 Ways to Remove Duplicates to Create a List of Unique Values in Excel October 18, 201771 comments
Formulas, Macros & VBA, Tables & Data, Tips, Tips & Shortcuts 3 Ways to Delete Entire Blank Rows in Excel + Video Tutorial October 5, 201742 comments
