Tricentis Tosca: Working with Excel Engine
4.4 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
19 students enrolled

Tricentis Tosca: Working with Excel Engine

Begineer to Advanced Course
4.4 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
19 students enrolled
Created by Prachur Saxena
Last updated 2/2018
English
Price: $99.99
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 11 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will -
  • - Learn about Tosca Excel Modules
  • - Learn about module attributes for each excel module.
  • - Understand the Tosca Excel Model
  • - Learn about usage of Tosca excel modules
  • - Understand some basic operations examples read,write,append,buffer etc..
  • - Practice with simple and advanced examples
  • - Understand Libraries,Reusable TestStep Blocks, While Loops,Repetition, & much more
  • - Be able to complete a project along the learning curve of the course.
  • - Understand how to Troubleshoot issues or common traps
  • - find some additional lessons in Bonus lectures and utilise same in your project completion
Requirements
  • 1. You should have Tosca installed in your system.
  • 2. You should have MS Excel installed.
  • 3. You may have understanding on usage of Tosca Tool. Even if you don't, Don't Worry!!
  • 4. Any knowledge in testing will help.
Description

*****************************

Course Overview:

----------------------------------

This  course has been designed to help you gain practical in-depth knowledge  on Excel Engine. This course consists of Theory, Practical Examples from  simple to advanced, Assignments, Project and Bonus lectures. This  course doesn’t talk’s about any UI automation instead it talks about  excel automation.

This course consists of about 90% practical  examples so that you learn while doing. In your Practical examples you  will also utilize most discussed concepts like string operations,  libraries, execution lists, buffers, repetition, loops, if-then-else etc  and effectively use them in your test case.

So Let's begin the journey and unlock the knowledge on never discussed topic.



Course Curriculum is discussed below:
****************************************************************************************************
In section 2:
--------------
We  will discuss some important qna around post installation activities and  settings required for this engine. This will be covered in first 2  lessons. Then in lesson 3, we will discuss excel object model and how  Tosca is using it? Once we complete this section and build our base with  theory we move onto next section.

****************************************************************************************************
Section 3:
------------
In  this section, We will go one by one, understanding each of the modules  which are available as part of Excel Engine. We discuss their attributes  and how we can use them in our test case.

****************************************************************************************************
Section 4 and 5:
-----------------
In these section, you will learn How to Create TC With\Without specifying the excel range.

****************************************************************************************************

Section 6 and 7:
----------------
In these section, you will go through advanced examples on the excel engine.

*****************************************************************************************************
In Section 8
------------
Here,  we will go through some examples on troubleshooting issues or problems  which you might be facing when working with excel modules related test  cases.

****************************************************************************************************
In section 9:
-------------
Here, You will be part of and own the development of a mini Project in which you will solve a real
world problem. This problem statement occurs frequently in banking and finance industry. We will
first discuss the requirement and then you will build the solution around it.Don’t worry even
though if you couldn’t get to the correct solution I will be discussing the solution with you in
this section.

****************************************************************************************************
in Section 10- Additional Lectures:

You have some additional supportive lectures related to introduction to IDE, sections, creation of new projects,
CALC operations, string operations module,creation of xml module,  etc that can aide in your learning path of this course.

****************************************************************************************************
Queries:

If you have any query related to course please post your questions in QnA section.

****************************************************************************************************

In this course curriculum, you have lot of practical examples to learn from and a real world problem to solve as your tiny project.
Last but not the least I believe you will enjoy the course.

Who this course is for:
  • Anyone can pursue this course.
Course content
Expand all 67 lectures 03:20:57
+ Introduction
1 lecture 04:29

Introduction to Instructor and Course Curriculum.

Preview 04:29
+ Introduction to Excel Engine
5 lectures 21:22
Setting Up The Excel Engine
07:44
Understanding Excel Object Model
05:16

Quiz For Section 2

Quiz For Section 2
6 questions

Please download this initial subset with the help of which you can create your excel related  test cases and can create the project in the end.

Download Initial Subset
00:06
Guide For You: Shortcut for Creation Of Test cases folder structure
00:07
+ Understanding Excel Modules
9 lectures 25:58

What does Open WorkBook Module do? How to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Open Workbook Module
05:55

What does Range Manipulation Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Range Manipulation
04:29

What does Close Workbook Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Close Workbook
01:26

What does Get Active Excel Application Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Get Active Excel Application
01:57

What does Create Range Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Create Range
03:31

What does Set Active WorkBook Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Set Active Workbook
02:09

What does Set Header module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Set Header
02:01

What does Set Active Range Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Set Active Range
02:00

What does Set Active Worksheet Module do? How and When to use it in your test case? What all module attributes does it have? Which module attributes are mandatory?

Set Active Worksheet
02:30
+ Simple Examples - Part 1
7 lectures 17:08

Please download and save this file on your PC. And in your test case, please use the same path where this file resides.

Download Resource For Simple Examples Part 1
00:05
Simple Examples Intro
00:59
Buffer A Cell Value
04:14
Buffer An Entire Row Content
03:41
Buffer an Entire Column Content
02:30
Buffer number of rows in an excel sheet
03:40
Buffer number of columns in an excel sheet
01:59
+ Simple Examples - Part 2
7 lectures 12:35

Please download and save this file on your PC. And in your test case, please use the same path where this file resides.

Download Resource For Simple Examples Part 2
00:05

How to buffer a Excel cell value?

Buffer a Cell Value
03:40

How to buffer entire Excel row?

Buffer an Entire Row Content
01:55

How to buffer entire Excel column?

Buffer an Entire Column Content
02:01

How to get count of used excel columns?

Buffer number of columns in an excel sheet
02:06

How to get count of used excel rows?

Buffer number of rows in an excel sheet
02:41

How to create resuable teststep block? and use it in your excel test cases.

Guide For You: Creating Library of Reusable TestStep Blocks
00:07
+ Advanced Examples - Part 1
7 lectures 24:25

How to create new excel file on local drive?

Creating New Excel File
03:48

How to write columns names or header to external Excel file?

Write Column Names to New Excel
05:47

How to write cell value to external Excel file?

Write to A Cell in New Excel
01:50

How to write rows to external Excel file?

Write values in A Row in New Excel
03:34

How to write and change columns names to external Excel file containing header?

Changing Column Name in the Existing Excel
02:33

How to write columns names to external Excel file and replacing existing ones?

Rewriting Columns in Existing Excel
04:51

How to add new sheet to external Excel file?

Add New Sheet to Existing Excel And An Assignment\Self Assessment
02:02
+ Advanced Examples- Part 2
9 lectures 19:33

How to write values to a specific cell of external Excel file?

Write Content to Specific Cell in Existing Excel
02:31

How to write values vertically or column-wise to the external Excel file?

Filling Row values Vertically in Existing Excel
06:18

This is your first assignment.

2- Assignments\Self Assessments
02:21

CALC concept discussion with usage and implementation.

Guide For You: CALC operations discussion
00:07
Download Resource For Calc Example
00:03

Applying CALC on row values for further use .

Apply CALC on Row Value for Further Use
03:53
Download Resource For XL Comparison Example
00:02

How to compare the excel files?

Comparison of 2 Excel files
04:15

Please download the file on your PC and refer the same file path in your test case.

Download Resource For common Trap
00:01
+ Troubleshooting Issues \ Common Traps
4 lectures 10:55
ProblemAndSolution-1
03:11
ProblemAndSolution-2
02:15
ProblemAndSolution-3
01:52
ProblemAndSolution-4
03:37
+ Project
11 lectures 41:42
Please download the files: an excel and a xml and save it on your PC. Later in your test case please refer the same path where the files are residing.
Download the resources for the Project.
00:07

The requirement or the problem statement discussion for the Project.

Understanding the Problem Statement
03:12

Use this hint to get a roadmap for completion of your project test case.

Business Logic
01:53
Discussion 1- Creating Map
05:03
Discussion 1- Getting Counts
05:17
Guide For You: Splitting Values stored in the Buffer
00:06
Discussion 2 - Repetition Level 1
06:13
Discussion 3 - While Loop Level 2
03:43
Discussion 4 - Repetition Level 3
05:08
Discussion 5 - Xml Verification
05:54
Discussion 6 - Executing the project test case
05:05
+ Additional Lectures
7 lectures 22:48
Introduction to Creation Of New Project
02:48
Introduction To Sections In Tosca
03:07
Calc Operations\Calculations
06:46
Shortcut for creating TestCase Folder Structure
01:30
Creation of Libraries From Resuable TestStepBlock
01:01
Creation of Xml Module
02:25
String Operation Module: Split Value stored in Buffer
05:11