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 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 [...]
Microsoft Excel Should Be Easy to Use Based on my 37 years of programming in Microsoft Excel, I can personally tell you that there is absolutely no reason for Excel to frustrate you, or for Excel to be difficult to use. Simply put, Microsoft Excel should be easy to use. If Excel is not [...]
