Power Pivot/Query/BI, Power Query Split by Delimiter into Rows (and Columns) with Power Query November 4, 202011 comments
Power Pivot/Query/BI, Power Query How to Count Unique Rows with Power Query September 16, 2020Add comment
Power Pivot/Query/BI, Power Query How to Import PDF Files into Excel with Power Query June 17, 202039 comments
Power Pivot/Query/BI, Power Query How to Merge Tables with Power Query – Similar to Vlookup June 3, 20206 comments
Macros & VBA, Power Pivot/Query/BI, Power Query VBA Macro to Create Power Query Connections for All Excel Tables May 27, 202026 comments
Power Pivot/Query/BI, Power Query Power Query Overview: An Introduction to Excel’s Most Powerful Data Tool May 13, 2020131 comments
Power Pivot/Query/BI, Power Query 4 Ways to Fix Date Errors in Power Query + Locale & Regional Settings April 29, 202015 comments