- Introduction
- Uipath Installation
- Uipath Tool Overview
- Reading Data from Excel sheet - Theory session
- Reading Data from Excel Sheet - Practical Session
- Writing Range Data to Workbook Sheet | Theory session
- Write Data into Excel Workbook sheet | Practical session
- Insert Data (value) Into Particular Excel Cell | Theory
- Insert Data (value) Into Particular Excel Cell | Practical
- Copy & Past Range Data & Preserve Cells Format
- Copy & Past Range Data & Preserve Cells Format- Practical
- Reading Cell Formula | Theory
- Reading Cell Formula | Practical
- Append Data to Excel Sheet | Theory
- Append Data to Excel Sheet | Practical
- Get Excel Cell Color
- Set Range Color
- Auto Fill Range
- Insert/Delete Rows & Columns
- Creating Batch file for UiPath Automation's
- Way Forward - What Next ??
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
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
Other Courses
Video editing and logo animation in adobe premiere pro cc
Create complete professional logo animation from start to end in adobe premiere pro cc
How to Make a Professional WordPress Website - Simple & Easy
Setup Your Wordpress Website in Minutes. Learn to register a domain Name & Web Hosting. Easy to understand and start.
Eat 5 Servings of Fruits & Vegetables Every Day
Optimize Health and Extend Lifespan with this Simple Recommendation
About the instructors
- 4.38 Calificación
- 30460 Estudiantes
- 3 Cursos
Mohammed Shahin
Certified Technical 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.
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
Student feedback
Course Rating
Reviews
it is a good course for beginners, I am looking forward to seeing a more advanced course
It was too good learning experience. Please help me in learning more options about Vlookup and Pivot tables
nyc explanation