Excel Help

>Excel Help

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

Excel Transpose Methods Then and Now

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

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