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
$20
Take This Course
  • Lectures 21
  • Contents Video: 2 hours
    Other: 0 mins
  • 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

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?

  • 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

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
Course Overview
Preview
03:00
What are you going to learn in this course
Preview
01:16
How would you benefit from this course
Preview
02:15
Focusing on the features that you need
Preview
01:33
Section 2: How to create a Project Plan using Microsoft Excel
What is the project Plan
Preview
05:07
How to build high level project plan in Microsoft Excel
Preview
09:04
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
Article
Section 3: How to Manage Software Development testing and quality assurance with Excel
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
Article
Section 4: 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