Power Query REA Form Using a Power Query Table as a Review, Edit and Append Form ( REA ) A new Method of Excel Development Using a Power Query Table as a Data Review Edit and Append Entry Form. In This Post: We demonstrate how to quickly and easily select, review, [...]
Excel Data Driven Solutions in 2026 Every new Excel solution we build starts with the Data, and it flows downstream from there. Understanding your data, where it comes from, cleaning it up, making sure you have all the columns you need, that is the first step in any custom Excel solution. The last step [...]
Learn Expert Excel Skills ~ From the Top Excel Experts ~ Work with our Team of Excel 365 Experts at Excel and Access, LLC, and our International Team of Associates ~ USA UK CAN AU ~ Programming Excel 365 w/ Power Query is not [...]
Quick Power Query Solutions Power Query sounds complicated, but in actuality, Power Query is quite easy to learn, and pretty easy to use. Sure, it can get complex if you press it, if you add M-Code and such, but to start, it is relatively easy to learn. You can get a great start by watching [...]
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 ~ [...]
Intermediate One-On-One Excel 365 Training When it comes to intermediate Excel training, remote one-on-one training is simply the best way to learn Excel. For one, you don't have to leave the house. Secondly, it is you, the instructor, and your Excel file. No distractions, no other students, just you and our Excel expert. Thirdly, this [...]
Beginner One-On-One Excel Training When it comes to learning Microsoft Excel, remote one-on-one training is the best way to learn. There literally is no faster or more effective way to learn Excel. With Beginner One-On-One Excel Training You work directly with an expert Excel instructor, focused on you and your needs. All of our Excel [...]
Excel Transpose Methods Then and Now Microsoft Excel programmers have long used the PasteSpecial Transpose method to Transpose (Pivot) their data. While very useful, it is a manual process and such it does take more effort than desired. But that was then, this is now, and transposing Excel data just got much easier with the [...]
