Learn Microsoft Excel by building real world ready documents
0.5 (1 rating)
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.
35 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Microsoft Excel by building real world ready documents to your Wishlist.

Add to Wishlist

Learn Microsoft Excel by building real world ready documents

Learn how to build project management, software testing and quality assurance real world ready documents using MS Excel
0.5 (1 rating)
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.
35 students enrolled
Created by Vadim Mikhailenko
Last updated 6/2014
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Microsoft Access 2010
  • Microsoft Excel 2010
  • Understanding of File System
  • Access to the Web Browser to watch educational videos
  • Internet access
Description

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.

Who is the target audience?
  • Analysts
  • Testers
  • QA Team leads
  • Quality assurance analysts
  • Consultants
  • Project Managers
  • Team Leaders
Students Who Viewed This Course Also Viewed
Curriculum For This Course
21 Lectures
02:13:24
+
How to create a Project Plan using Microsoft Excel
9 Lectures 01:03:41


Benefits of creating project plan using Microsoft Excel
07:00

Lets Do it. Building Detailed project plan
13:15

Lets do it. Build project plan to upgrade business computers to the newer models
13:39

Lets do it. Tips and Tricks.
08:29

Why create project plan using Microsoft Excel
04:22

Lets do it. Additional examples of Project Plans
02:41

Download materials from this section
00:04
+
How to Manage Software Development testing and quality assurance with Excel
7 Lectures 01:00:19
How to define test phases using Microsoft Excel
16:37

How to Build software Test cases using Microsoft Excel
08:09

How to create a test script using Microsoft Excel
08:34

How to validate test coverage using Microsoft Excel
11:43

How to report Quality Assurance and software test results using Microsoft Excel
11:35

Using Out of the box Prebuilt Microsoft Access Database for issue tracking
03:33

Download materials from this section
00:08
+
Conclusion
1 Lecture 01:08
Conclusion
01:08
About the Instructor
Vadim  Mikhailenko
4.1 Average rating
796 Reviews
17,021 Students
8 Courses
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.