Excel Automation using Uipath
Excel Automation using Uipath, available at Free, has an average rating of 4.3, with 21 lectures, based on 123 reviews, and has 4109 subscribers.
You will learn about 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 This course is ideal for individuals who are Automation engineers or uipath developers or programmers or back office staff It is particularly useful for Automation engineers or uipath developers or programmers or back office staff.
Enroll now: Excel Automation using Uipath
Summary
Title: Excel Automation using Uipath
Price: Free
Average Rating: 4.3
Number of Lectures: 21
Number of Published Lectures: 21
Number of Curriculum Items: 21
Number of Published Curriculum Objects: 21
Original Price: Free
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- Automation engineers
- uipath developers
- programmers
- back office staff
Target Audiences
- Automation engineers
- uipath developers
- programmers
- back office staff
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
Course Curriculum
Chapter 1: Main Section
Lecture 1: Introduction
Lecture 2: Uipath Installation
Lecture 3: Uipath Tool Overview
Lecture 4: Reading Data from Excel sheet – Theory session
Lecture 5: Reading Data from Excel Sheet – Practical Session
Lecture 6: Writing Range Data to Workbook Sheet | Theory session
Lecture 7: Write Data into Excel Workbook sheet | Practical session
Lecture 8: Insert Data (value) Into Particular Excel Cell | Theory
Lecture 9: Insert Data (value) Into Particular Excel Cell | Practical
Lecture 10: Copy & Past Range Data & Preserve Cells Format
Lecture 11: Copy & Past Range Data & Preserve Cells Format- Practical
Lecture 12: Reading Cell Formula | Theory
Lecture 13: Reading Cell Formula | Practical
Lecture 14: Append Data to Excel Sheet | Theory
Lecture 15: Append Data to Excel Sheet | Practical
Lecture 16: Get Excel Cell Color
Lecture 17: Set Range Color
Lecture 18: Auto Fill Range
Lecture 19: Insert/Delete Rows & Columns
Lecture 20: Creating Batch file for UiPath Automation's
Lecture 21: Way Forward – What Next ??
Instructors
-
Mohammed Shahin
Certified Technical Instructor
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 2 votes
- 3 stars: 18 votes
- 4 stars: 52 votes
- 5 stars: 51 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024