Udemy

Excel Automation using Uipath

Hands-on Course Excel Automation ---------------------------------------------------------------------------------------
Free tutorial
Rating: 4.3 out of 5 (122 ratings)
4,005 students
1hr 29min of on-demand video
English
English [Auto]

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

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

Instructor

Certified Technical Instructor
Mohammed Shahin
  • 4.4 Instructor Rating
  • 1,900 Reviews
  • 36,024 Students
  • 3 Courses

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.

Below are his areas of expertise:

- Telecom as he worked with Etisalat the leading Telecom service provider in the region as a Technical Instructor providing Telecom, GPON, IoT, Cloud, Networking and so many other courses.

 - Strong A/V Broadcast Knowledge ,Consumer Electronics, Networking. 

Mohammed Marwan have helped Thousands of people from around the world to learn & improve from their technical knowledge & skills.

He is passionate about providing training and teaching people about the technology in a very simple way without making things complicated for the students. 

He is delivering currently the below courses:

1- Internet of things (IoT)

2- Artificial Intelligence (AI)

3- Machine Learning using Microsoft Azure

4- Data Science using Python

5- Basics of Python Programming

6- Advanced Python Programming

7- Robotics Process Automation (RPA) using UiPath

8- Chatbot designing using Python & Dialog flow.

9- Augmented Reality ,

10- Thingworx IoT Application platform

11-Smart Home solutions (Fibaro).

12- Wimax Vs. FixedLTE .

13- High end routers (D-link, Linksys, TP-link).

14- IT Fundamentals

15- IPTV & STB basics

16- Fiber Fox splicing tool

17- WIFI basics

18- WIFI Analyzer

19- GPON Test Equipment's , VFL, OTDR , power meter , LFI , fiber scope

Top companies trust Udemy

Get your team access to Udemy's top 26,000+ courses