Beyond the Basics: Excel, Email, and PDF Automation Mastery with UiPath

Course Provider

Nanyang Business School

Certification

Continuing Education and Training Certificate

Introduction

In this intermediate-level UiPath Studio course, participants embark on a journey to explore the world of Robotic Process Automation (RPA) in depth, acquiring proficiency in advanced automation techniques. This course serves as a crucial steppingstone for those seeking to enhance their RPA skills.

The course commences by delving into Data Tables and Excel intricacies, enabling efficient data management, including data extraction and report generation. Learners will not only master effective data handling but also transform it into actionable insights. Furthermore, a significant portion of the course focuses on automating email tasks using Microsoft Outlook. Learners will learn how to streamline communication workflows and significantly reduce manual efforts in managing email-related processes.

Another critical skill taught in this course is working with Portable Document Format (PDF) files for data extraction. Learners will gain hands-on experience in automating tasks involving data extraction from PDF documents, essential in industries dealing with high volumes of structured and unstructured data.

Advanced data manipulation is a core focus, with learners becoming proficient in using arrays, lists, and dictionaries to handle complex data structures effectively. This skill is particularly valuable when managing diverse datasets and conducting data-driven automation. Error handling and RPA testing are vital aspects of creating reliable automation solutions, and this course equips learners with the skills to address unexpected situations and ensure the robustness of their automation projects. They will learn to build error-handling mechanisms and conduct thorough testing, making their robots resilient and dependable.

In addition to technical skills, this course also covers automation implementation methodologies. Learners will understand how to strategically approach automation projects, ensuring alignment with business objectives and delivering tangible benefits. This knowledge is crucial for effective RPA implementation in real-world scenarios.

Upon successful course completion, learners will possess a comprehensive skill set covering UiPath Studio features. They will be well-prepared to design and develop efficient and reliable automation solutions. Practical projects integrated into the curriculum will provide learners with the hands- on experience necessary to excel in their professional automation endeavors.

Upon successful completion of the course, learners will be awarded an "NTU Certificate of Completion".

 


 
At the end of the course, learners will be able to:
  • Create, customize and populate DataTable variables.
  • Differentiate between the categories of activities used when working with Excel files: Workbook activities and Excel App Integration activities.
  • Use specific modern design activities to work with Excel files to read data, write data and save files to meet automation requirements
  • Use the most common methods for DataTable manipulation.
  • Automate the retrieval of email messages using Microsoft Outlook
  • Automate the interaction with emails by filtering and downloading attachments.
  • Automate the sending of email using Microsoft Outlook
  • Automate the extraction of information from PDF documents.
  • Automate the extraction of information of fluctuating values from PDF documents.
  • Manipulate data using arrays, lists and dictionaries variables to meet automation requirements
  • Use the common exception handling techniques and identify when they should be used.
  • Create basic and data-driven test cases for RPA workflows.
  • Describe the UiPath implementation methodology and its benefits
  • Describe the roles and responsibilities of the people involved throughout the implementation process from both the UiPath and Client team sides.
  • Identify solutions to some of the most common challenges faced throughout the automation implementation process.

Throughout the course, learners will gain proficiency in working with DataTables and Excel, equipping them with the ability to efficiently manage and manipulate data. Additionally, learners will acquire valuable skills in automating email processes using Microsoft Outlook. They will learn to send emails, manage attachments, and organize email communications seamlessly, enabling efficient email-related tasks in automation projects. Learners will also delve into the intricacies of PDF automation, mastering the art of extracting and processing data from PDF documents effectively. They will explore methods for extracting structured data from PDFs, empowering them to incorporate valuable PDF content into their automation workflows. Furthermore, the course will equip learners with advanced data manipulation techniques using arrays, lists, and dictionaries. This toolkit will enable learners to store, process, and retrieve data dynamically, optimizing the efficiency and flexibility of their automation projects. An essential aspect of the course is to develop proficiency in error and exception handling. Learners will learn how to handle unexpected situations gracefully, ensuring their robots can recover from errors and maintain the stability of automation processes. Learners will be introduced to RPA testing methodologies, learning how to thoroughly test their automation projects and validate their functionality before deployment. This testing phase will help ensure successful automation implementation, minimizing errors and maximizing the effectiveness of the automation solution. Lastly, the course will introduce learners to automation implementation methodology, providing them with a structured approach to plan, design, and implement automation solutions effectively. By adhering to best practices and standards, learners will be well-prepared to tackle real-world automation challenges in their professional endeavors.

The UiPath Studio Intermediate RPA course is ideal for individuals who have completed the “Introduction to Robotic Process Automation with UiPath: Building Strong Foundations” or any basic RPA training or possess foundational knowledge of UiPath Studio. Business analysts, process owners, software developers, and professionals seeking to advance their RPA skills will benefit from this course, as it provides a comprehensive understanding of topics such as DataTables, Excel automation, email automation, PDF automation, data manipulation, error handling, RPA testing, and automation implementation methodologies.

Standard Course Fee: S$2,180.00

SSG Funding Support

 Course fee

Course fee payable after SSG funding, if eligible under various schemes

 

BEFORE funding & GST

AFTER funding & 9% GST

Singapore Citizens (SCs) and Permanent Residents (PRs) (Up to 70% funding)

S$2,000.00

S$654.00

Enhanced Training Support for SMEs (ETSS)

S$254.00

SCs aged ≥ 40 years old
SkillsFuture Mid-career Enhanced Subsidy (MCES)
(Up to 90% funding)

  • Standard course fee is inclusive of GST.
  • NTU/NIE alumni may utilise their $1,600 Alumni Course Credits. Click here for more information.

 

Read more about funding

Mr Michael Tan

In 2021, Michael brought his expertise to the Nanyang Business School (NBS), following a decade-long tenure at the Institute of Systems Science, National University of Singapore. Distinguished by a slew of best teaching awards, he's been a formidable force in executive education and postgraduate instruction. The topics he taught include Robotics Process Automation and Business Process Reengineering. At present, he spearheads the "Robotics Process Automation in Analytics" course for NBS's Master of Science in Business Analytics program.
Beyond academia, Michael wields a decade-spanning, hands-on prowess in software development, business analysis, and project management. His achievements span from digitizing bank data to architecting systems for an African government and the esteemed IMF World Bank. He holds a Bachelor’s Degree in Computer Science and a Master of Business Administration, both from the National University of Singapore, cementing his prowess at the intersection of technology and business.