Price
$24
Course Type
Online
Duration
3 hours
Date
Various dates throughout the year
Entry Requirements
Beginner Level

About this course

Imagine that you can learn how to build project management, software testing and quality assurance real world ready documents using Microsoft Excel. This way you are not just learning Excel, but also building ready to use documents, which could be used in your day to day work. And you also learning the skill on how to create working products in Excel. We have the course for you. Designed by HowToAnalyzeData.net, 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 excel to create, edit, format, and manage project management plan, timelines, quality assurance process and will understand how to build all required documetns used in the process from scratch.

Class Goals:

How to Build Project Plan documents using Microsoft Excel

  • What is the project plan
  • Why is it helpful to create project plan? Why would you do it in Microsoft Excel.
  • How can you benefit from the course
  • Create Project plans for below scenarios
    • 1.0 Select new storage for the small business.
      • What is involved? How to estimate the costs? How to select the timeline and engage right resources to implement it?
    • 2.0 Upgrade business computers to the newer models.
      • What is involved? How to estimate the costs? How to select the timeline and engage right resources to implement it?
  • How to build a Project Plan using Microsoft Excel
    • Step by step instructions
    • How to use created document
  • Where to find additional examples

How to Build Testing and Quality Assurance Documents using Microsoft Excel

  • 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

Our Teaching Philosophy

Here's a refreshing concept in computer online training : We actually care about your goals and focus on helping you reach them.

We create high quality IT training videos focusing on solving specific business challenges.

Imagine the satisfaction of learning on how to solve specific business problem with factual information. Instead of focusing on features of the product we focus on what you can actually accomplish with the tool to solve your challenge. Our main goal is to Solve any business challenge with data and answer any business question with facts. With our videos, you're on the fast track to get your challenges solved and skill mastery on the topics where you need help.

  • We know you're looking to solve specific business problem. How about learning the tool not just by learning the features, but by building a real world document. Or creating a real world project plan. That's why our project-based video tutorials give you relevant skills to apply to real life case studies, projecting the experience of our experience educators. Each course is segmented into different chapters so you can learn sequentially or jump to topics of specific interest.
  • Our video experts are coaches Our experts show you HOW the software works using real-world project examples. In many cases, practical working files are included so you can work alongside the tutor. And we always give you free samples of created files, which you can customize to for your own needs
  • And we give you homework. You are expected to do specific assignments in the class to reinforce your learning. Because without it you lose most of the information you have reviewed. With our courses expect to master the skills you need to succeed Customers tell us they're using their new skills immediately to confidently complete projects and delight colleagues and clients
  • For those of you who need immediate help we offer consulting services. Please contact us for details, if you have a problem to solve.

We're passionate about delivering the best, most affordable project-based computer software training videos, perfect for business professionals, consultants, knowledge workers, entrepreneurs, business owners, and others.

Learn from broadcast-quality production methods and leading accredited authors, Our courses are really do rival classroom-based training courses, but at a fraction of the cost and on your own schedule.

What are the requirements?

  • Microsoft Access 2010
  • Microsoft Excel 2010
  • Understanding of File System
  • Access to the Web Browser to watch educational videos
  • Internet access

What am I going to get from this course?

  • Over 21 lectures and 2 hours of content!
  • 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
  • What is the project plan
  • Why is it helpful to create project plan? Why would you do it in Microsoft Excel.
  • How can you benefit from the course
  • Create Project plans for below scenarios
  • How to build a Project Plan using Microsoft Excel
  • 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.

What is the target audience?

  • Analysts
  • Testers
  • QA Team leads
  • Quality assurance analysts
  • Consultants
  • Project Managers
  • Team Leaders
Enquire now

Enquire now