Database Replacement Solutions in Microsoft Excel 365 with Power Query ~ All Applications lead to Excel. Why not just start there ~ Many businesses hire us to make what we term "Database Replacement Solutions" in Microsoft Excel 365, with Power Query. These are not Databases, as this is Microsoft Excel. Why it works: The advanced [...]
Here is Why I Personally use Power Query in all of my Excel 365 Solutions for Business ~ Because it is just so much easier this way ~ Power Query is why we changed our business model in 2025 ~ Excel and Access , LLC should now be Excel and Power Query, LLC ~ [...]
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. What [...]
Recent Microsoft Excel Tables Project We used Excel Tables instead of an Access Database We Build Custom Database Replacement Solutions in Microsoft Excel We recently completed an Excel Development project for a custom guitar builder. The Excel solution was mostly built with Excel Tables. Some Power Query was used. The Tables provided the data structure [...]
How to Choose the Right Microsoft Database Application(s) for Your Organization's Needs There are four Microsoft databases to choose from, and then there is Excel. Four databases to integrate and automate into one complete, seamless Microsoft Database Solution For best results, integrate your Microsoft Database Solutions with Microsoft Excel Microsoft has four [...]
