Hire our team of Power Query programmers

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, PivotBy Function, Excel Tables, Power Pivot Tables, List Tables|6 Comments

Onsheet versus Offsheet Excel Programming

Onsheet versus Offsheet Excel Programming

On-Sheet Versus Off-Sheet Excel Programming FLUID Excel Development "Fluid Excel Development": How you program Excel today will be different than how you will do it in say, just 6 months, as Excel 365 is in a constant state of flux, and as such, so should your Excel development methods, hence FLUID Excel Development. [...]