Microsoft Excel Programmers

>Microsoft Excel Programmers

Excel Development Step by Step

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 [...]

Dynamic Excel Changes in 2023

Changes Continued in Dynamic Excel # in 2023 I am sitting on a train, looking out the window at the Pacific Ocean, as I make my way to Santa Barbara to celebrate the Christmas holiday with family. Nothing to do for the next 5 hours.  Given that the year is coming to an end, this [...]

Using VStack to Consolidate Excel Datasets

Using Excel VStack to Consolidate Datasets Let's start with this, why would you want or need to consolidate datasets in Microsoft Excel?    Because your Excel programmer decided to place like data across multiple tabs and multiple workbooks. They could have just as easily if not more easily, put all of the data in one [...]

Interactive Reports in Excel Just Got Easier

Interactive Reports in Excel Just Got Easier Until recently, when you wanted to build an interactive and dynamic Excel report, one that allowed the user to build a quick report, on the fly, you would need to write many formulas, and often you would need to add complex VBA/macros.  But the times are changing.  Microsoft [...]

Intermediate Excel Programming Skills

10 Intermediate Excel Programming Skills to Advance Your Career   Can improving your Excel skills help to advance your career? Microsoft Excel is the most used spreadsheet application on the market today.  If you work in business, or in an office, chances are that you work with Microsoft Excel on a daily basis.  Knowing these [...]

Microsoft Excel Lead Tracker Application

  Microsoft Excel Lead Tracker   Our Microsoft Excel Lead Tracker allows you to Instantly see where your best leads originate.   Excel Should Be Easy To Use   Our Excel Lead Tracker Application Our Excel Lead Tracker application uses a custom Microsoft Excel UserForms graphical-user-interface to capture incoming leads as well as [...]