UiPath Excel Automation - Activities and Scenarios

Learners
Sat, Jul 10, 2021, 3:00 PM (IST)

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


Hosts

  • Vibhor Shrivastava

    Vibhor Shrivastava

    UiPath

    Global Community Advocacy Manager

  • Basavadarshan G N

    Basavadarshan G N

    UiPath

    Program Manager - Industry Enablement

Organizers

  • Vibhor Shrivastava

    Vibhor Shrivastava

    UiPath

    Global Community Advocacy Manager

    View Profile
  • Rohit Radhakrishnan

    Rohit Radhakrishnan

    UiPath

    Community Manager - APJ

    View Profile
  • Cristina Vidu

    Cristina Vidu

    UiPath

    Global Manager, Marketing Community

    View Profile
  • Diana Gray

    Diana Gray

    UiPath

    Community Marketing Manager, Americas, UiPath

    View Profile