Access Power Automate directly from the ‘Automate’ tab within Excel. To streamline the process, opt for a pre-existing template specifically designed for sending emails based on selected rows.

Use Excel’s “Get Data from Folder” feature to import and combine multiple trial balance files into a single query. Clean and transform data using Power Query to prepare it for analysis.

One of the more interesting announcements at Build, however, is about how the company is bringing generative AI to Power Automate, its process and workflow automation platform.