automation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/automation/ Bestselling Excel and Power BI Courses Tue, 05 Dec 2023 13:28:33 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png automation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/automation/ 32 32 How To Send Microsoft Forms Responses to Outlook With Power Automate (and how to make it conditional) https://www.xelplus.com/power-automate-with-forms/ Thu, 30 Sep 2021 08:00:00 +0000 https://www.xelplus.com/?p=9799 It's super easy to setup an automation in Power Automate to get notified when someone submits their answers in a Microsoft Form. You can also add a condition, so you get an email or mobile notification only when a specific answer is submitted.

The post How To Send Microsoft Forms Responses to Outlook With Power Automate (and how to make it conditional) appeared first on Xelplus - Leila Gharani.

]]> How to Use Office Scripts with Power Automate https://www.xelplus.com/office-scripts-with-power-automate/ Thu, 12 Aug 2021 08:00:00 +0000 https://www.xelplus.com/?p=9855 Learn to combine Office Scripts with Power Automate so you can run your macros without opening your files. You'll learn how to create a script, how to loop through each sheet in the script and how to setup Power Automate to apply the script to every file in a folder.

The post How to Use Office Scripts with Power Automate appeared first on Xelplus - Leila Gharani.

]]> Introduction to Office Scripts https://www.xelplus.com/office-scripts-macros-on-the-web/ Fri, 28 May 2021 11:09:00 +0000 https://www.xelplus.com/?p=10010 This example gets you started with Office Scripts in Excel. You'll learn how to record a macro and how to modify the script to get a dynamic range. You'll also learn where to find the Office Script and how to save it with your workbook.

The post Introduction to Office Scripts appeared first on Xelplus - Leila Gharani.

]]> What’s the Difference Between Excel VBA and Office Scripts https://www.xelplus.com/excel-vba-vs-office-scripts/ Mon, 24 May 2021 11:19:00 +0000 https://www.xelplus.com/?p=10101 What's the difference between Excel VBA macros and Office Scripts? Do you need to switch from VBA to Office Scripts? Find out in this detailed article. I show examples of what you can achieve with VBA and the current status of Office Scripts and explain what each is for.

The post What’s the Difference Between Excel VBA and Office Scripts appeared first on Xelplus - Leila Gharani.

]]> How to Send an Email from Excel with Attachments https://www.xelplus.com/email-from-excel-with-attachments/ Thu, 29 Apr 2021 08:00:00 +0000 https://www.xelplus.com/?p=10132 Guess what? You can send bulk personalized emails directly from Excel with attachments. You don't need any VBA or external add-ins. It's really easy to set this up.

The post How to Send an Email from Excel with Attachments appeared first on Xelplus - Leila Gharani.

]]> Learn Excel Macros in 10 Minutes https://www.xelplus.com/learn-excel-macros/ Fri, 02 Apr 2021 04:48:00 +0000 https://www.xelplus.com/?p=10171 If you find yourself repeatedly performing the same steps in the same order in Excel, your brain should immediately declare, “I should automate this with an Excel macro!”. You will see that VBA doesn't have to be scary and that you can easily generate VBA code by recording your actions.

The post Learn Excel Macros in 10 Minutes appeared first on Xelplus - Leila Gharani.

]]> How to Use Power Automate https://www.xelplus.com/learn-power-automate-examples/ Tue, 16 Feb 2021 12:00:00 +0000 https://www.xelplus.com/?p=10300 Learn how to use Microsoft's Power Automate with examples. With Power Automate you get to automate boring and repetitive tasks across applications. We take a look at two examples: Bulk PDF creation and a Planner to Outlook automation.

The post How to Use Power Automate appeared first on Xelplus - Leila Gharani.

]]>