Analytics & AI for Modern Excel
Office Scripts for Excel, as the name suggests, is a programming language that indeed requires coding. To ease the learning curve and offer a straightforward starting point for script creation, Office …
Continue Reading about How to understand Record Actions in Office Scripts for 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 →
In a previous blog post I showed how to get over limitations of creating dummy datasets directly in Microsoft 365 Copilot by asking for a Python script instead, particularly the faker …
Continue Reading about Python in Excel: How to generate fake data with Faker →
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 →
We've probably all been there: receiving countless emails from our boss, struggling to keep track of them. Despite trying various techniques in Outlook or in other tools, things just aren't clicking. …
Continue Reading about How to track incoming emails in Excel with Power Automate →
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 →
