Power Automate Desktop Excel Automation Tutorial (Part 2 of 3)

Published: 19 August 2021
on channel: MS Power Automate
3,503
37

To automate your work on Microsoft Excel with Microsoft Power Automate Desktop, you'll need to know how to use the common Excel automation actions.

Here's part 2 of the video as promised! (You can find Part 1 here:    • Power Automate Desktop Excel Automati...  )

In part 2, you'll learn about the advanced Excel actions in Microsoft Power Automate Desktop:

00:00 Introduction
00:22 Select cells and get selected cells from Excel worksheet
01:08 Copy & paste cells, insert and delete rows and columns
01:32 Get first free row on column vs Get first free column/row from Excel worksheet
03:47 Exercise - combine various Excel actions above with for each loop

Check out these other useful Excel videos:

Excel Automation Part 1 (basic Excel actions including Launch Excel, Read from Excel, write to Excel, etc.) -    • Power Automate Desktop Excel Automati...  

Excel Automation Part 3 - (Compare and match values in each row of an Excel file + Sum up values in 2 columns in Excel) -    • Power Automate Desktop Excel Automati...  

How to loop through each row in Excel -    • How to loop through each row in an Ex...  

Get first free column/row giving the wrong value? Check this video:    • Solved: Get first free column/row fro...  

Keep in touch!

Website https://mspowerautomate.com/

Twitter   / msautomate  

Facebook   / ms-power-automate-105388391663527  

LinkedIn   / power-automate  

#RPA #PowerAutomateDesktop #PowerAutomate #Automation #RoboticProcessAutomation #Microsoft


Watch video Power Automate Desktop Excel Automation Tutorial (Part 2 of 3) online without registration, duration hours minute second in high quality. This video was added by user MS Power Automate 19 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,503 once and liked it 37 people.