How to create a Project Plan using Microsoft Excel

Learn about how to build Project Plan in Microsoft Excel. Learn how it is done in real life and apply the knowledge.
2.7 (3 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.
59 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 15
  • Length 2 hours
  • Skill Level All Levels
  • 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 4/2014 English

Course Description

Imagine that instead of learning about too many features of the software product you can learn it solving a specific business problem by doing a real world hands on solution. Like creating a project plan? That you can learn key features of Excel by watching how professionals use it.

That is why we have created this course for you.

I am excited to share with you not just the features and capabilities of the product but show what you can do with them. This way you can immediately apply what you learned and improve you career, life and anything where you can use Microsoft Excel and do planning.

How is it useful? Imagine what if you have a great idea for the new product and would like to secure the funding. Or you have a great marketing idea. Or you want to open up the business? Or plan family gathering? And you want to learn Microsoft Excel at the same time? What is the common between all these things? That is right - project plan. With this course you can learn how to do it all. You can see how professionals do it and you can apply this knowledge to become a better person. You can plan the tasks, estimate the costs and do it all in Microsoft Excel. And when you done you can take it to your boss or display it to your team or share with other decision makers to get them excited about your idea? And guess what – by doing it all you will learn Excel at the same time.

And on top of that we teach you how project plan could be used in real life to help you in your day to day activities and interactions. I have two examples from the real life business project I was working on and I share with you key tasks and how to build them as part of this course.

In this course we take you step by step on how to build a project Plan in Microsoft Excel. At the end of the class you would be able to build it from scratch or reuse and enhance the files we give you as part of the course, based on your business needs.

Thanks for your trust in us. And if you like this course make sure to check us out at www.howtoanalyzedata.net.

Topics Covered:

  • 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

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 Excel 2010 Software

What am I going to get from this course?

  • Learn key features of Microsoft Excel by building hands on practical file which could be used for different needs
  • Learn how to quickly calculate resources needed to acomplish the business objective
  • Learn how to use the tools you already have to build presentable documents that can be shared with decision makers to help you communication your intentions correctly
  • Learn 7 must know capabilities
  • Basics of formatting
  • Basics of calculations in Excel
  • Sorting in ascending and descending order
  • Undo and redo
  • Saving and protecting the documents
  • Printing of the documents
  • Saving as pdf

What is the target audience?

  • Project Managers
  • Resource Managers
  • Business owners
  • Enterpreneurs
  • Project Coordinators
  • Team Leaders
  • Marketing Managers
  • Organization's managers

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: Introduction and what are we going to learn
Why create project plan and why use Microsoft Excel for that
Preview
02:24
How to use Material in this course
Preview
02:08
What are your options to get answers to your business questions
Preview
02:26
Section 2: Helpful features of Microsoft excel I use every day
Microsoft Excel 2010 - Beginners overview in less than 30 minutes
Preview
18:30
Microsoft Excel 2010 - 7 must know features for the beginners
26:16
How to create sequence for numbers and dates
Preview
05:48
Section 3: How to create a project plan using Microsoft Excel
What is the project plan and how would you benefit by having it
Preview
05:07
Lets Do It. Build High Level project plan using Microsoft Excel
Preview
09:04
Benefits of creating Project Plan. How can you use it in your day to day work
Preview
07:00
Lets Do it. Build a detailed Project Plan
13:15
Why use Microsoft Excel to Create a project plan
04:22
Lets Do it. Additional Examples of Project Plans
02:41
Lets do it. Sample Project Plan to upgrade business computers
13:39
Conclusion
01:14
Section 4: Supplemental course materials
Course Notes
14 pages

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