Teaching analytics with modern Excel
Office Scripts provide an exciting new way to automate solutions for Excel workbooks using a variant of the TypeScript programming language. As with any programming language, it's crucial to know how …
Continue Reading about How to understand console.log() in Office Scripts for Excel →
If you're an Excel user aiming to streamline your workflow and that of your coworkers, Office Scripts are an exciting new tool to explore. These scripts can automate repetitive tasks, making your …
Continue Reading about How to understand function main() in Office Scripts for Excel →
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 →
