Teaching analytics with modern Excel
As an Excel user, you likely engage in routine workflows week after week. Perhaps you need to consolidate files from a specific email into a folder each week, create approval workflows for budgets and …
Continue Reading about How to get started with Power Automate for Excel →
Excel continues to be an essential tool for many business professionals, often utilized for swift ad hoc analyses, reporting, or data entry tasks. However, Excel's true potential over time frequently …
In a previous post we delved into the distinctions between VBA (Visual Basic for Applications) and Office Scripts for Excel: To summarize, although many Excel automation tasks can be …
Continue Reading about How to write your first Office Script for Excel →
If you've spent any time in Excel as an analyst, you're well aware of the significant amount of busywork involved. Manually adding different formats, PivotTables, removing unwanted columns, creating …
Continue Reading about How to compare Office Scripts and VBA for Excel →
