Project Management

Picture of Project Management
Now Only
$389
AUD
35% off
$599 AUD
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 8314 Students

Learn from an experienced project manager who teaches you the tricks of the project management trade.

Increase your value to your employer by discovering and mastering essential quantitative and qualitative project management applications.

A successful project begins with process definition, data collection, and the scoping of project requirements. Every project ends with a motivated project team able to accomplish objectives on time and within budget. Winning projects rely on accurate cost and time estimates, identification of the critical path, and use of tracking and control tools.

In this course, an experienced Project Management Professional will teach you the same powerful tools and techniques that experienced project management professionals rely on every day.

You'll increase the probability of project success by mastering the tricks of the trade: Earned Value Performance Measurement, Gantt Charts, Network Scheduling, Work Breakdown Structure, and Cost-Volume Analysis.

You'll become proficient at recruiting project team members and empowering them to succeed. You'll understand the stages of team development, and you'll gain skills in developing and motivating team leaders. You'll learn how to understand and relate to an organisational culture and the differing characteristics of its work groups.

You'll also learn about project software, statistics, change management, processes, and estimating. And you'll gain valuable experience with project planning, control and data analysis tools.

 

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

In our first lesson, you'll learn how to use a variety of project management data collection tools including check sheets, histograms, performance charts, and process definition tools such as work breakdown structure (WBS) and flowcharts. After you master these tools, you'll be able to increase your project management effectiveness by leaps and bounds.

Estimating is a very important activity for every organization. It helps you calculate time and costs for your project. When you successfully use estimates, your actual cost of project work is very close to your projections. In today's lesson, you'll learn how to apply quantitative and qualitative estimating methods, such as historical analogy, the walk through and Delphi methods, expected value, and estimates under uncertainty.

Earned value is gaining in popularity in project management circles. Although some people view it as a new concept, they're often surprised to learn that it's been around for more than 30 years. In today's lesson, I'll define earned value, describe its history, and discuss its benefits. You'll learn about the graphical and mathematical overview of earned value, and discover how to create a step-by-step earned value performance measurement (EVPM) system.

Gantt charts, along with work breakdown structure (WBS), earned value performance measurement (EVPM), and the precedence diagram method (PDM), make up the big four of project management. A Gantt chart may be the most popular tool associated with project management because it's an easy to follow timeline chart. In today's lesson, you'll learn about the history of Gantt charts, find out how to create one, and discover their benefits and limitations.

Network scheduling, along with earned value, represents one of the most technical aspects of project management. If you enjoy working with charts and numbers, this lesson is right up your alley! As with earned value, the precedence diagram method (PDM) includes a fair amount of terminology and a little bit of tricky math. Today you'll learn the basics of networks and see how they relate to project management. You'll discover activity-on-arc (AOA) and activity-on-node (AON) network scheduling methods and understand how to use task dependencies, dummy activities, and float time.

In today's lesson, we'll take a break from using calculators and studying elaborate models. You'll learn how resource planning, work flow diagrams, and storyboards can help you create and implement an effective project plan. I'll also show you how to define and implement a project change control system and to how control project costs.

Today, we'll discuss a few more tools to help you with your projects. We'll begin with cost-volume analysis, a tool to help you optimize choices using costs, volume, and desired profits. We'll move on to Monte Carlo simulation, a sophisticated tool you can use when you deal with completely random conditions. You'll learn how to use force field analysis, a tool that helps you evaluate a decision based on pros and cons, and apply the Pareto principle, a 200-year-old concept that helps you to focus on what's important.

I believe that too many people in the project management field place too high of an emphasis on the role of project management software. While it has an important role to play as a tool, software is not a substitute for sound planning, effective implementation and control, and positive leadership. In today's lesson, I'll discuss the nature of project management software and help you identify winning techniques and processes. You'll read two case studies to help you understand issues pertaining to software implementation. You'll learn why some people are reluctant to use project management software, and discover ways to evaluate and select a software supplier.

Many project managers and team members struggle to improve their projects' output. Despite their best efforts to improve customer satisfaction, project personnel are often unable to make much progress. The best way to succeed is to use statistics and a data-driven approach to characterize and improve your projects. Today, you'll learn about the measures of location (median, mode, and mean), the normal curve, and measures of dispersion (range, mean absolute deviation, variance, and standard deviation). You'll see how the Taguchi loss function is an alternative to traditional go/no-go inspection. You'll also learn how to measure variation, use prevention, and apply statistical process control (SPC) to help you produce predictable and acceptable results.

Today, we'll discuss the dimensions of the project team. For your project to succeed, you need a skilled project manager and committed capable project team members. You'll learn how to identify essential competencies of an effective project manager, and how to establish a winning project team. You'll understand what it takes to recruit, evaluate, and select project team members. And you'll also learn about the concepts of a core team, extended team, and the overly important project team.

I believe a potent combination of a high-functioning project team and a capable project manager is essential for your success in project management. Effective project teams come together through careful planning and action. In today's lesson, we'll discuss work group theory, contrast formal and informal work groups, and identify informal work group characteristics. You'll learn about the stages of team development, understand why change is so important for your project, and find out why people are reluctant to change. You'll learn how to overcome resistance to change and empower your project team.

Today, we'll discuss fundamental organizational concepts. You'll discover the purpose of an organization chart and learn why a matrix organization is a common project management organizational structure. You'll understand key coordinating principles such as authority, responsibility, accountability, and power. And you'll gain insights into organizational culture by developing a deeper understanding of values and beliefs, the elements of successful delegation, and various theories of motivation and leadership.

Tony Swaim

Tony Swaim

Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas ... Read more

Read Tony Swaim's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

The Learning Environment

From the moment that you enrol in the Project Management you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Ready to get started?

Enrol Now

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.

Microsoft Excel 2007 Intermediate Online Course | Vibe Learning
 

Microsoft Excel 2007 Intermediate

Picture of Microsoft Excel 2007 Intermediate
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 11174 Students

Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity.

Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity. In this practical, hands-on course, you'll learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007's filtering techniques.

You'll see how Excel 2007 can give you further insight into your valuable data. And by learning how to create macros that eliminate repetitive tasks, you'll earn your coworkers admiration and gratitude. With your macro knowledge, you'll be able to manipulate data with the push of a button.

You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by learning how to use Excel's VLOOKUP, INDEX & MATCH, and other time-saving functions.

So get ready for action-packed learning that will take your Excel skills to the next level!

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

In our first lesson, you'll discover why Excel 2007 is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So today, you'll find out how to choose the right chart for telling your story, and then how to create, format, and edit your chart to help others clearly visualize that story.

There are so many great charting features and enhancements in Excel 2007, there's no way we could cover all of them in a single lesson. So today, we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well known, these options can add tremendous value to your worksheets in the right situations. We'll walk through a few of them step-by-step so you'll see the value for yourself.

Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In today's lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?

Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature.

Today, you'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So today, we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart.

Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

Back by popular demand, it's Solver! Today, we'll continue with our topic from the prior lesson, but this time, we'll throw in a little bit of a wrinkle. Instead of me guiding you step-by-step through a practical, hands-on experience with the Solver, I'm only going to guide you to a point because I want to help you master a tool that's as complex as it is powerful. By the end of this lesson, and mostly on your own, you'll have successfully mastered using Solver!

Today's topic is a student (and instructor) favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?

If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start today by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category.

Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In today's lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF and COUNTIF functions, and discuss how to use one of Excel 2007's new functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!

Since functions are such an important and integral part of using Excel, we'll spend our final lesson going over a few more of them. Today, you're going to learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short changed, because we're going to add to the complexity. We're going to use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss!

Chad Wambolt

Chad Wambolt

Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales rangin... Read more

Read Chad Wambolt's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

The Learning Environment

From the moment that you enrol in the Microsoft Excel 2007 Intermediate you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.