UiPath Excel Automation - Activities and Scenarios

Jul 10, 2021, 9:30 – 11:00 AM

83
RSVPs

In this session, we will look at most of the excel functions available with UiPath along with a workshop to see some practical Explanations of Real-Time Scenarios.

About this event

Microsoft Excel spreadsheet software has become an integral part of most business organizations for analyzing, budgeting, or organizing client sales lists.

Having said that, most of the automation requires an Interaction with Excel.

In this session, we will look at most of the Excel Functions available with UiPath along with a workshop to see some practical Explanations of Real-Time Scenarios.

This session will have  2 Parts:

Part # 1: Explaining all the below activities of excel

  • Reading excel in UiPath
  • Excel vs workbook activities
  • Write data in excel
  • Insert/delete rows in excel
  • Insert/delete columns in excel
  • Copy sheet – excel
  • Delete range in excel - UiPath
  • Copy – values / formula / formats
  • Get workbook sheets in excel
  • Look up range in excel
  • Append range – UiPath

Part# 2 - Workshop 

Practical explanation of Real-Time Scenarios - Attendees can Follow and Build Along. There would be a Sample Excel Provided to follow along with the Presenter.

  • Refresh multiple pivots in excel
  • Append data to dynamic range
  • Split CSV data to multiple excel
  • Utilize joins in excel

📌Download data for exercise  

Speaker

  • Mukesh Kala

    Boundaryless

    RPA Manager & UiPath MVP

Hosts

  • Vibhor Shrivastava

    UiPath

    Director - Global Community Advocacy

  • Basavadarshan G N

    UiPath

    Program Manager - Industry Enablement

Organizers

  • Rohit Radhakrishnan

    UiPath

    Community Manager - APJ

  • Cristina Vidu

    UiPath

    Global Manager, Marketing Community

  • Diana Gray

    UiPath

    Community Marketing Manager, Americas, UiPath

  • Mukesh Kala

    Boundaryless

    RPA Manager (Boundaryless) | UiPath MVP