Blue Prism: Excel Automation
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to streamline Excel processes using Blue Prism, a powerful robotic process automation (RPA) tool.
Syllabus
Introduction
- Excel automation in Blue Prism
- What you should know
- Set up
- Page references
- Create a queue
- Global data items
- Load queue collection
- Load queue action
- Environment variables overview
- Environment variables demo
- Generate file path
- Check file exists
- Create consolidation report instance
- Create consolidation report file
- Show consolidation report file
- Get files from directory
- Loop stage
- Open weekly report
- Remove blank rows
- Get worksheet as collection
- Filter collection action
- Filter collection expression
- Get cell value
- Write collection
- Get next empty cell
- Create a worksheet
- Extract GL accounts: Collection contains value
- Extract GL Accounts: Add row
- Filter weekly report data
- Calculate GL account balance
- Prepare summary tab data
- Save consolidated report
- Run end to end process
- Next steps
Taught by
Marchela Bozhilova
Related Courses
Introducing Blue PrismLinkedIn Learning Getting Started with Blue Prism RPA
Pluralsight Blue Prism Foundation Training
Blue Prism via Coursera Robotic Process Automation
YouTube Robotic Process Automation
YouTube