Book Image

UiPath Associate Certification Guide

By : Niyaz Ahmed, Lahiru Fernando, Rajaneesh Balakrishnan
Book Image

UiPath Associate Certification Guide

By: Niyaz Ahmed, Lahiru Fernando, Rajaneesh Balakrishnan

Overview of this book

UiPath is the most popular vendor in the Robotic Process Automation (RPA) industry. If you're an RPA enthusiast or citizen developer who wants to succeed in the industry, achieving this certification can help you get accredited and ready for real-world challenges using UiPath. UiPath Associate Certification Guide offers complete, up-to-date coverage of the UiPath RPA Associate certification exam to help you pass on the first attempt and get certified. The book is written in a clear, succinct way with self-assessment questions, quizzes with answers at the end of each chapter, exam tips, and mock exams with detailed answers and explanations. You'll start by getting to grips with the basic concepts of UiPath RPA, and then progress to an in-depth discussion of all the concepts required for Associate certification. Finally, you'll develop UiPath skills by gaining the required knowledge and implement these skills using sample business cases. By the end of this UiPath book, you'll have covered everything you need to pass the exam, gained the knowledge you need to work on real-world case studies, and learned how to apply the various concepts to build enterprise-level use cases.
Table of Contents (24 chapters)
1
Part 1: Importance of RPA
6
Part 2: UiPath Studio
15
Part 3: Use Case and Exam Preparation
20
Chapter 17: Mock Exam 1
21
Chapter 18: Mock Exam 2

Chapter 9: Learning the Uses of Data Tables and Exploring Excel Automation

We discussed different types of variables and arguments in the previous chapter. However, there is another very special type of variable, which we call data tables. We use data table variables to process more structured data that is organized in a tabular form. We use Microsoft Excel almost every day to perform different functions in an organization. For example, a finance department may use Excel regularly to generate reports, perform calculations, and reconcile financial data. As a result, many companies and/or departments have already started automating the actions performed manually in Excel.

This chapter focuses on learning how to automate Excel using UiPath and how data table variables can be used to support Excel automation.

The chapter consists of the following sections:

  • Exploring data tables
  • Creating and customizing data table variables
  • Interacting with Excel files
  • Practicing...