Microsoft's Power Platform offers Excel users an accessible and powerful gateway to build workflows, websites, and even applications within a low/no-code environment that seamlessly integrates with …
How to run an Office Script on all Excel workbooks in a folder with Power Automate
In a previous post, we explored how to use Office Script to automate formatting and enhance features in an Excel workbook: But how do you extend this automation to multiple Excel workbooks? …
Office Scripts for Excel: How to share your scripts
Sharing your Office Scripts in Excel can greatly enhance collaboration and efficiency, whether you're working within your team or across different organizations. In this post, we'll explore how to …
Continue Reading about Office Scripts for Excel: How to share your scripts →
How learning Markdown can help you get more from AI
Artificial intelligence has introduced powerful new ways to enhance productivity, especially in Excel tasks related to data analysis, visualization, and more. However, the quality of your outputs from …
Continue Reading about How learning Markdown can help you get more from AI →
How to choose the right free tools for AI-powered Excel tasks
AI is significantly enhancing Excel, making it a more powerful tool for data analytics. In this post, we explore a range of free AI-powered tools that enhance Excel's functionality, aimed at those who …
Continue Reading about How to choose the right free tools for AI-powered Excel tasks →
Python in Excel: How to generate fake data with Faker
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 →