Blue Prism: Excel Automation

English | 1h 26m | Video 720p | Subtitles

Microsoft Excel became one of the world's most popular business applications because it helps professionals efficiently organize, analyze, and present information. With Blue Prism, a powerful robotic process automation (RPA) tool, you can be even more productive with Excel. Blue Prism comes with an Excel VBO file that you can leverage to quickly start automating key Excel processes. In this course, join Marchela Bozhilova as she goes over the basics of Excel automation in Blue Prism. She shares best practices as she demonstrates how to create an end-to-end process to generate a consolidated report that extracts data from other sources. Along the way, she covers key Excel VBO functionality, including how to work with environment variables and filter collections.

 

Topics include:

 

Creating a queue

Loading a queue collection and action

Creating a consolidated report

Filtering collections 

Getting data from weekly reports

 

Homepage:

https://www.lynda.com/Blue-Prism-tutorials/Blue-Prism-Excel-Automation/2816005-2.html