Power Query Tables

Tables Beginner to Advanced

Tables Beginner to Advanced

Tables Beginner to Advanced Tables, are still a largely unknown feature in Microsoft Excel development: Most Excel users have never heard of Excel Tables. Many Excel programmers still do not use Excel Tables. Fewer of those Excel programmers work with Power Query Tables. Luckily most have used or still use Pivot Tables. A handful of [...]

March 27th, 2026|Tags: Power Query Tables, List Tables, Hire our team of Power Query programmers, Pivot Tables, Excel Tables|6 Comments

Using Excel 365 DAF with Tables

Using Excel 365 DAF with Tables

Microsoft Excel 365 Dynamic Array Functions to use w/ Excel Tables ~ Filter ~ Unique ~ ChooseCols ~ Take ~ GroupBy ~ PivotBy ~ Use Excel DAFs to Select Data from an Excel Table If you want to extract data from an Excel Table, these Dynamic Array Functions are the ones to look at. [...]