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, [...]
Custom Excel 365 Solutions Take a lot of Experience to Program There is a huge difference between fixing an existing Excel workbook and building a new one from scratch. ~ Knowing how Excel works and knowing how to build a 100% automated & Integrated, forward-looking, 100% custom solution, in Excel 365 for Teams are not [...]
Evaluating Power Query Usage in Microsoft Excel Is Power Query a viable component in a fully automated Microsoft Excel 365 Solution for Business? If so, in what capacity? How far do you take Power Query; how do you leverage its POWER. Let's find out, via a few examples What is Optimal Usage of Power [...]
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. [...]
Easily Comparing External Records with Power Query Easily Comparing External Records with Power Query is what this post is all about, and lately, it is what Excel is all about. Power Query simplifies Excel programming, and Power Query makes comparing records form different data sources a snap. ~ Use Joins Instead of Lookups ~ [...]
Many Excel Experts use Joins Instead of LOOKUP Functions Top Excel experts agree the best custom Excel solutions have very few moving parts. Nothing for the user to type, nothing for the user to copy and paste, nothing for the Excel user to do at all. Top Excel Consultants know one way to simplify your [...]
Dynamic Excel 365 Development - Step by Step Index/Match or XLookup, Concatenate/Concat or TextJoin, GroupBy, Pivot Tables or PivotBy. Hundreds of cells with formulas, or just one dynamic one that Spills. How you program Excel has changed; Excel Development Step by Step will help you to get up to date. Requirement, Excel 365. It is [...]
Location, Talent, Results: What Matters Most for the Success of Your Project? The quality of the work should come before everything else, for best results LOCATION - Location can be very important, and it definitely matters if you want local onsite help. Firms having the ability to travel onsite to the client is an [...]
XUMO: Microsoft Access Database Development. XUMO/Comcast needed a fully integrated and automated solution in Microsoft Access and Excel for their Hi-Tech Business Startup. The Project: When new business startup XUMO (Eventually acquired by Comcast) needed a Smarter Microsoft Access database developed, they hired our company to build their new business model, the software [...]
Behind the Project How We Customized Excel & Access Training for the British Red Cross A look behind the scenes at how a one-on-one training engagement went from an initial email to customized Excel and Access training delivered across multiple countries. Where It Started It started with a simple request. A Finance, Grants Management and [...]
