How to Manage Software Testing using Microsoft Excel

Learn how to build all required documents and manage software testing and Quality Assurance using Microsoft Excel
4.1 (6 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
241 students enrolled
$20
Take This Course
  • Lectures 10
  • Contents Video: 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2014 English

Course Description

Have you ever wondered how complex applications are build and what is the best way to ensure that they don't have any defects. In some organizations for every application developer there are multiple testers that validate the work, which is done by developer. Sometimes testers use sophisticated software packages to manage quality assurance, but what if you don't have these expensive tools

Welcome to the course, where we teach you about software testing and how you can manage all the phases of the testing using Microsoft Excel 2010. This course shows you how to build a real-world ready documents using Microsoft Excel and how you can use them to effectively manage the quality assurance for the software development process. . Designed by HowToAnalyzeData, a global training partner, this course covers all of the best activities to get you started.

In this training class, students will to gain the necessary skills to create on how to use Microsoft Excel to create, edit, format, and manage project management plan, timelines, quality assurance process and will understand how to build all required documents used in the process from scratch. We explain you the purpose of each document , the value it delivers for software testing and quality assurance, how to build it and how to use it in the real world scenario.

Class Goals:

  • Learn about software testing and quality assurance process
  • How to define test phases for software quality assurance project
  • How to create a test script in preparation for testing
  • What is the test coverage and how to make sure you cover all required scenarios using Microsoft Excel.
  • How you can report results of quality assurance to the management and team members.
  • Review out of the box Microsoft Access database, which comes with the product, for defects and issue management

  • What are the requirements?

    • Microsoft Excel 2010 installed
    • Microsoft Access 2010 installed (Optional - helpful to follow one of the videos)
    • Basic understandin of how to launch applications in Windows
    • Understanding of Files and how to save files

    What am I going to get from this course?

    • How to define test phases for software quality assurance project
    • How to create a test script in preparation for testing
    • What is the test coverage and how to make sure you cover all required scenarios using Microsoft Excel.
    • How you can report results of quality assurance to the management and team members.
    • Review out of the box Microsoft Access database, which comes with the product, for defects and issue management
    • Learn about software testing and quality assurance process

    What is the target audience?

    • Software developers
    • Quality analysts
    • Consultants
    • Project Managers
    • Learners of Microsoft Excel

    What you get with this course?

    Not for you? No problem.
    30 day money back guarantee.

    Forever yours.
    Lifetime access.

    Learn on the go.
    Desktop, iOS and Android.

    Get rewarded.
    Certificate of completion.

    Curriculum

    Section 1: Course Overview
    Introduction
    Preview
    01:29
    What is software testing and quality assurance
    Preview
    06:54
    How to use material in this course
    Preview
    01:12
    Section 2: Managing Software Testing and Quality Assurance with Microsoft Excel
    How to define test phases using Microsoft Excel
    Preview
    16:37
    How to build test cases with Microsoft Excel
    08:09
    How to create a test script with Microsoft Excel
    08:34
    How to ensure test coverage using Microsoft Excel
    11:43
    How to report test results using Microsoft Excel
    11:35
    Using Prebuilt out of the box Microsoft Access database for manage defects
    03:33
    Section 3: Conclusion
    Conclusion
    01:08

    Students Who Viewed This Course Also Viewed

    • Loading
    • Loading
    • Loading

    Instructor Biography

    Vadim Mikhailenko, Enterpreneur, Consultant, Public Speaker, Educator

    Hi, I am Vadim, and I am here to help you solve your problems. I am enterprenuer, family man and experienced educator. I have been and experienced consultant, for more than 20 years and I am also a professional educator and share my knowledge with college students. I hold MBA and Master in Computer Science degrees and excel in using technology to solve business problems

    I have created this site to share with you how to reach your family goals by saving money and making make smart decisions to take you life to the next level. I’m always trying different things in my life and capture what works (and what doesn’t). I am excited to teach you my thought process, how I analyzed the data and tried different things to find the most effective approach. This site is organized as a set of training courses, which will teach you different tool, tricks and techniques of smart family decision making.

    Ready to start learning?
    Take This Course