Receiving the Microsoft Excel MVP & Microsoft Access MVP Awards I am honored to share that I have been recognized as both a Microsoft Excel MVP and a Microsoft Access MVP. ( To be awarded in both Excel and Access is rare, currently there are estimated to be around 20 people worldwide with this combination. [...]
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 [...]
Power Query Joins or Lookup Functions ~ Old School Programming (Pre-2018) Versus New School Development (Post-2018) ~ Excel has Changed: Power Query has never been used more than it is now, neither have Excel Tables, both are quickly gaining acceptance and momentum. Microsoft has been very clear on the future direction of Excel 365. Online, [...]
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 [...]
FLUID Excel Solutions for Any Organization ~ Custom Excel 365 Solutions w/ Power Query for Business, Government, Education, Non-Profits, & Individuals ( We Mentor ) ~ Excel 365 changes almost daily now. Microsoft Excel is in a constant state of change. As such, so should custom Excel programming. Hence FLUID Excel solutions. The [...]
Dynamic Excel 365 Tracker Templates for Business ~ FLUID Excel Solutions for Business ~ If you run a business, you know there are certain data points you need to track to run your business properly. You may want to track sales, new hires, and even inventory. Anything that you want to track, should be built [...]
Excel GroupBy Function for Interactive Reporting Interactive, Dynamic, and Automated, the new Excel GroupBy Function is going to be front and center in Excel reporting and analysis for years to come. A nice addition to custom Excel Dashboards. With so many user-selected options, this function is designed to be interactive. 877-392-3539 Our Excel [...]
The Microsoft Excel FILTER Function is my FAVORITE Excel 365 Function The Excel 365 FILTER Function is the one Excel Function I could not Program Without I base much of my user interface on the use of the FILTER Function. The function allows the user to drive the Excel solution. With the FILTER Function, you [...]
Modeling Dynamic Excel 365 in 2024 for Business It is February 2024 and the solutions I am developing right now will for my business clients will most likely be outdated within the year. Why? Because the Microsoft Excel Team has been making so many monumental changes in Excel, that Excel 365 is now called "Dynamic [...]
Microsoft Excel Lead Tracker Excel has changed, see our latest post on Microsoft Excel 365 Trackers for Business, 2025. Our best Excel 365 Trackers for Business are based on Power Query. Our Microsoft Excel Lead Tracker allows you to Instantly see where your best leads originate. Excel [...]
