How to do Mail Merge in Power Automate (Full Tutorial)
This video tutorial shows how to do advanced mail merge in Microsoft Power Automate. Learn how to use a Word template with placeholders, Excel as a data source, and Power Automate to do the mail merge automatically. You also learn…
ChatGPT & Excel – The Power DUO (Full Tutorial)
Generate Excel formulas, graphs, and VBA code with ChatGPT and your everyday words. This complete tutorial shows how to get advanced Excel help in OpenAI’s ChatGPT. By the end of this video, you have learned how to use ChatGPT as…
ChatGPT-based Autonomous Agents – Beginners Guide to Genta
ChatGPT-based Autonomous Agents are a reality š®š Use your everyday words and automate everything. You no longer need to be a programmer to automate webpages, Excel, or applications. ChatGPT and Computer Vision power the software. Thanks to Genta from Cognillo…
Excel in Microsoft Power Automate – Beginners Tutorial
This video tutorial shows how to update Excel with Microsoft Power Automate. Learn how to update multiple sheets simultaneously, add advanced conditions, and run Office Scripts – VBA Macros on steroids. š Download the course materials: https://andersjensen.org/microsoft-power-automate/excel VIDEOS FOR YOU:…
How To Read Excel And Do An Online Search In UiPath RPA – Full Tutorial
This video tutorial shows, how to read an Excel sheet, do an online web search and save the results back to Excel. Anders Jensen will develop a full RPA solution live, giving you his thoughts and answering questions live. š…
Comparing two Excel Sheets in UiPath (Tutorial from Start to Finish)
This video tutorial shows how to compare Excel sheets in UiPath. The tutorial starts with converting the Excel sheets into DataTables and then use a nested For Each loop to make the comparison. First, it’s shown how to find matching…
šµLive Currency Rates in Excel (Full Tutorial)
This video tutorial shows, how to get live updated currency rates into Excel and do real-time currency conversions. We’ll do a REST API request and use the result to do the currency conversion in Microsoft Excel. The technique is simple.…
UiPath Video Tutorial for Excel Activities
Examples for all Excel Activities from UiPath Studio. 0:00 Intro 0:41 Chapters 1:20 Excel Application scope and Read and Write Range 3:25 Read, Write and Append CSV 7:20 Workbook Read and Write Range 9:30 Workbook Append Range 10:20 Workbook Read…
Excel trigger UiPath Robots (HTTP POST VBA script)
How to start a process with parameters on #UiPath Robots from the #Excel using VBA scripts. 0:00 Preview 0:47 Intro 1:20 Idea that a lot of companies use big excel for the base of process 2:02 I will not use…
How to create a Drop Down List in Excel
This video tutorial shows, how to create drop down lists in Microsoft Excel (also reffered to as Data Validation lists). It is also explained, how to do dependent/dynamic drop down lists in Excel. You could also watch: šµ Power Automate…