Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Automation using Uipath
Rating: 4.5 out of 5(143 ratings)
4,583 students

Excel Automation using Uipath

Hands-on Course Excel Automation ---------------------------------------------------------------------------------------
Created byMohammed Shahin
Last updated 7/2021
English

What you'll learn

  • Read Data from excel workbook
  • Read specific row from our excel sheet
  • Write range data to work book sheet
  • Insert data (value) into a particular cell
  • Copy & Past Range data and preserve the cells format
  • Read Cell formula
  • Append data to excel sheet
  • Get cell color
  • Set cell color
  • Select range
  • Auto fill range
  • Insert/Delete columns and rows
  • Bonus : Creating a batch file

Course content

1 section21 lectures1h 29m total length
  • Introduction7:07
  • Uipath Installation2:23
  • Uipath Tool Overview9:34
  • Reading Data from Excel sheet - Theory session7:38
  • Reading Data from Excel Sheet - Practical Session10:45
  • Writing Range Data to Workbook Sheet | Theory session2:33
  • Write Data into Excel Workbook sheet | Practical session4:53
  • Insert Data (value) Into Particular Excel Cell | Theory2:08
  • Insert Data (value) Into Particular Excel Cell | Practical3:38
  • Copy & Past Range Data & Preserve Cells Format2:50
  • Copy & Past Range Data & Preserve Cells Format- Practical2:18
  • Reading Cell Formula | Theory1:17
  • Reading Cell Formula | Practical2:45
  • Append Data to Excel Sheet | Theory2:03
  • Append Data to Excel Sheet | Practical2:38
  • Get Excel Cell Color2:38
  • Set Range Color3:55
  • Auto Fill Range4:26
  • Insert/Delete Rows & Columns3:46
  • Creating Batch file for UiPath Automation's8:03
  • Way Forward - What Next ??1:56

Requirements

  • No Pre-requisite

Description

Free Course which cover all the required knowledge for Excel Automation using RPA


COURSE DESCRIPTION:

We do many tasks daily using Microsoft excel, and we spend a lot of time doing the same task.

In this course we are going to learn how to automate such a repeatable and daily Excel tasks and activities using RPA tool which is (Uipath). We will demonstrate 10 features available in Uipath which you can use to start doing some automation.

This course does not require you to be a programmer or a technical person, you just need to be welling to learn new skills.


Note: Programming experience is not required in this course.


In this course we will cover the followings:

•Read Data from excel workbook.

•Read specific row from our excel sheet.

•Write range data to work book sheet.

•Insert data (value) into a particular cell.

•Copy & Past Range data and preserve the cells format

•Read Cell formula.

•Append data to excel sheet.

•Get cell color.

•Set cell color.

•Select range

•Auto fill range.

•Insert/Delete columns and rows.

•Bonus : Creating a batch file


We will use Uipath tool to practice.

UiPath is a popular and progressive Robotic Process Automation (RPA) tool that enables users to automate various aspects of business processes. It provides an open-source platform that promotes collaboration and automation of repetitive tasks. It is used in various fields such as banking, healthcare, finance, and many more.


About the instructor : 

Mohammed Marwan is a Certified ILM Instructor having more than 10 years of experience in Training and Development (for both Technical and Non-Technical fields) with an excellent communication /presentation skills and developing training materials for multinational organizations.

He is delivering currently the below courses:

1- Internet of things (IoT), (Duration : 1 days)

2- Artificial Intelligence (AI), (Duration: 2 days)

3- Machine Learning using Microsoft Azure (2 days)

4- Data Science using Python (2 Days)

5- Basics of Python Programming (Duration : 3 days)

6- Advanced Python Programming (Duration : 3 days)

7- Robotics Process Automation (RPA) using UiPath (Duration : 2 days)

8- Chatbot designing using Python & Dialog flow.( Duration: 1 day)

9- Augmented Reality , (Duration: 1 days)

10- Thingworx IoT Application platform (Duration : 5 days)

11- Machine learning using Python

12- Deep learning using Python

13- Microsoft Power Bi

14- Raspberry pi mini computer 

Who this course is for:

  • Automation engineers
  • uipath developers
  • programmers
  • back office staff