Microsoft Excel Automation in StudioX

About the UiPath StudioX Excel Course  

The Excel Automation with StudioX course offers a beginner to intermediate journey into building Excel automation in UiPath StudioX. It explains how to configure the Cell, Range, Pivot, Chart, and Workbook activities. Once complete, you should be able to effectively automate tasks involving the use of Excel files 

The UiPath StudioX Excel Automation course is aimed at beginners. It takes 2 hours and 40 minutes to complete. Once finished, you will receive a diploma of completion. 

Product Alignment: This training is based on the UiPath StudioX 2021.10 product version but is applicable to newer versions as well. 

Course Prerequisites 

Before taking this course, you should complete the following courses: 

• Build Your First Automation with StudioX 
• File and Folder Automation in StudioX 
• Decisions, Iterations, and Scenarios in StudioX 
• Email Automation in StudioX 

Course Audience 

This course is aimed at business users. 

Excel Automation with StudioX Agenda 

The UiPath StudioX Excel Automation course covers an introduction to automation with Excel. The full agenda covers: 

What is Excel Automation 

• Microsoft Excel Automation 

How to Use the Activities 

• How to Use Cell Activities 
• How to Use Range Activities 
• How to Use Pivot Activities 
• How to Use Chart Activities 
• How to Use Workbook Activities 

Practice 

• Practice – Book Sales Report – Part 1 
• Practice – Book Sales Report – Part 2 

Check Your Knowledge  

UiPath StudioX Excel Learning Objectives 

At the end of the UiPath StudioX Excel course, you should be able to: 

• Effectively automate tasks involving the use of Excel files. 
• Explain how to use the Actions and Resources from the Excel activities category. 
• Adapt the automation project to dynamic Excel ranges.