Microsoft Project 2010 Fundamentals

Picture of Microsoft Project 2010 Fundamentals
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 2820 Students

Discover how to effectively plan, implement, and control projects using Microsoft Project 2010, the world's most popular project management software.

Discover how to effectively plan, implement, and control projects using Microsoft Project 2010. In these lessons, you'll learn how to use Microsoft Project to think through and organise your project's details, plan a schedule, sequence tasks, produce a baseline, assign resources and costs, track your progress, identify and analyse variances, and revise your project plan.

Once you've constructed a basic schedule, you'll see how to enlarge it and share it with clients and co-workers. In addition, you'll learn Microsoft Project's techniques for fine-tuning different aspects of your project, including splitting tasks for work interruptions and defining material consumption rates.

The knowledge you gain from this course will help you avoid going down dead-end alleys and prevent you from overloading your schedule. If you encounter trouble on your project, you'll be able to apply a number of powerful problem resolution techniques to help get your project back on track.

No matter how complex your projects are, Microsoft Project will help you cut them down to size. By the end of the course, you'll be able to produce project plans that wow your audience and empower you to achieve your business goals.

 

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.

<p>Microsoft Project can help you manage your project's schedule, costs, and scope in a way that you've never dreamed of. Too often, Project users never use this powerful tool to its fullest potential. In your first lesson, you&rsquo;ll discover how to improve your project by adopting a formal management approach. You&rsquo;ll get a quick overview of Project Management, and then you&rsquo;ll learn the basics of Microsoft Project, including a summary of the Gantt Chart view and ways to create and enter project tasks.&nbsp; </p> <p>&nbsp;</p>

If you're looking for ways to keep organized, you'll see just how to do that in today's lesson! We'll walk through steps to create a project schedule in no time flat. Once you create and enter tasks in Project's Gantt Chart view, you&rsquo;ll set a schedule by using a calendar and assigning lead times. Then, you&rsquo;ll need to create task dependencies, sometimes known as links. You'll see how to perform these activities and, in the process, you&rsquo;ll become comfortable using Project's many dialog boxes. Before you know it, you'll be creating schedules for all your projects with little effort.

You won't get too far with your project without adding resources. While tasks create the backbone of your project, people, equipment, and material bring your project to life. In this lesson, you&rsquo;ll find out how to apply two types of Project resources&mdash;work resources, and material resources. We'll look at two more dialog boxes&mdash;Resource Information and Assign Resources&mdash;and you'll learn how to analyze resources by using the Resource Sheet and Resource Usage views.&nbsp;

No matter what project you work on, the bottom line is always important. So get ready to add the final piece to your basic project schedule&mdash;costs. We'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued costs. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to assign different costs for the same resource and analyze the overall costs for your project by using the Cost Table.

Successful project managers are known for their efficiency and for safeguarding private information. Microsoft Project provides two excellent methods to help you in these areas: project templates and project security. You&rsquo;ll find out how to use some of the many templates Project has to offer, including the Residential Construction template and the New Product template. You'll also learn how to protect your project information with backups, passwords, and write protection. Then you&rsquo;ll discover how to put Project&rsquo;s task constraints to good use.

In this lesson, you&rsquo;ll discover how easy it is to modify your basic schedules and work with project data. You'll look at the various Project views, such as the Calendar, Leveling Gantt, and the Network Diagram. And if you don't like the default colors or fonts in your schedule or table, you'll be well-prepared to make changes. You'll even learn how and why you might want to create a combination view; add notes to your project; or sort, filter, and group data.&nbsp;

Many projects experience schedule compression when management or clients ask that the project be completed sooner and for less. In today's lesson, you&rsquo;ll discover how to improve your schedule's performance. You&rsquo;ll explore the Project Statistics dialog box, and you&rsquo;ll learn how to determine the ideal starting point in terms of planned costs and completion dates. You'll see how to change task dependencies to speed up your project, and also find out how to split tasks to add more lead time. You'll also learn how to create recurring tasks and attach&eacute; notes to your project&rsquo;s task bars.

Before you implement your project, you need to create a baseline. This will help you track actual results against what you originally set out to accomplish. Microsoft Project makes it possible to set up a baseline with a few mouse clicks. You'll learn how to create a baseline and then see a variety of ways, including using the Tracking toolbar, to record your actual project results.

Here's where things really start to come together! You'll learn how to compare actual results to your baseline by using the Gantt Chart and reviewing a table. You'll discover how useful status identifiers and progress lines can be to quickly gain information about your project's position. You&rsquo;ll also begin using the Tracking Gantt and filters to automatically identify slipping tasks. You'll also take a stroll through the basics of variance analysis by discussing the Start and Finish Date, Resources, and Work Variance Tables.

<p>Once your project gets rolling, outsiders will probably want to know how things are going. It can be a real time drain answering each request individually. When others request information from you, Microsoft Project offers the perfect solution: Reports. We'll go over 20 standard reports in five different categories in today's lesson. By the time you finish, you'll be well acquainted with Project&rsquo;s reporting capabilities, and also, know how to create Visual Reports as Project automatically exports data to Microsoft Excel and Visio.&nbsp; </p> <p><b>&nbsp;</b></p>

Now that you're using reports to share project information, you'll occasionally need to print out various views and tables. In this lesson, you&rsquo;ll delve into printing Microsoft Project documents. You'll be a master at creating different views of your project with the Page Setup dialog box, and you'll clearly understand the mechanics of the Print dialog box and the Print Preview.

No project is complete until it's officially closed. In this final lesson, you'll find out how to close your project and use the Organizer to help you customize and copy views for future projects.

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 Microsoft Project 2010 Fundamentals 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.

Still looking?

Check out the following courses related to Microsoft Project 2010 Fundamentals:

Essentials of Writing Online Course | Vibe Learning
 

Essentials of Writing

Picture of Essentials of Writing
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 6768 Students

Master the essentials of writing so you can excel at business communications, express yourself clearly online, and take your creative literary talents to a new level.

Master the essentials of writing, and become the stellar wordsmith you always wanted to be! In this course, you'll develop the skills you need to excel at business communications, express yourself clearly online, and take your creative literary talents to a new level.

Whether you're hoping to get a better job, write for a blog, or publish your short story, this course will give you the writing tools you need for success. It's also a perfect choice for students who speak English as a second language.

You'll gain confidence right away as you practice free writing and discover how to create solid drafts. You'll improve your writing skills by learning to select strong and persuasive words, spell correctly, and choose the right punctuation. Then you'll find out how to put it all together by crafting well-written sentences, building effective paragraphs, and organising your material logically. And finally, you'll explore ways to make the most of e-mails and other forms of electronic communication.

With the knowledge and hands-on practice you gain from this course, you'll be able to express yourself clearly and persuasively in writing—both in your personal life and in the business world.

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.

Welcome to Lesson 1, where you&rsquo;ll learn important concepts to help you write better today!&nbsp; You&rsquo;ll learn a strategy that will free up every bit of your existing writing skills and help you gain confidence when you write. Practice begins now with a new technique that will help you get your thoughts out onto the page so you can work with them.&nbsp; It&rsquo;s a great way to start on your goal of becoming a confident, accomplished writer.&nbsp; Whether you need to write on the job or you&rsquo;re eager to write for publication, this lesson will help!

Prepare yourself for some major upgrades on your ability to choose effective words!&nbsp; In this lesson you'll learn to recognize what kinds of word choices work and why.&nbsp; You&rsquo;ll come away with an understanding about word choices that cause your readers to feel confused or uninterested.&nbsp; You'll have the pleasure of discovering how to find the word you want and also how to goof around with words so you enjoy writing more.&nbsp; Finally, you'll practice, practice, practice.&nbsp; It&rsquo;s fun, so feel free to dive in and splash around!

It&rsquo;s time for spelling practice. Not only will you review problem words, but you&rsquo;ll get acquainted with 10 helpful rules and five helpful tips to make you a better speller so you can spell better from now on. You&rsquo;ll identify your own particular spelling demons and learn a strategy to cope with them once and for all.&nbsp; This lesson is filled with the kinds of resources and spelling practice you&rsquo;ve been looking for.

Here&rsquo;s your chance to get acquainted with common word usage difficulties and master them. You&rsquo;re about to learn to pick the right word at the right time and put it in the right place in your sentence.&nbsp; You&rsquo;ll practice choosing between similar sounding words that have different meanings.&nbsp; You&rsquo;ll get helpful explanations&mdash;at last!&mdash;about tricky usages that may trip you up daily.&nbsp; Feel free to delve into an information-packed lesson that will add to your knowledge of correct word usage.

Your writing ability is building after the first four lessons!&nbsp; In Lesson 5 you&rsquo;ll integrate all you&rsquo;ve learned so far&mdash;how how to capture your thoughts, choose effective words, spell correctly, and master word usage&mdash;by mastering techniques that will help you write effective sentences.&nbsp; Here you&rsquo;ll practice constructing sentences that have energy and precision by learning four simple tips, deciding which words to take out, and communicating your ideas logically.

Whisk through a handy review of the three main punctuation marks used to end sentences: the period, the question mark, and the exclamation point.&nbsp; But that&rsquo;s not all.&nbsp; You&rsquo;ll benefit from practicing how to identify and fix run-on sentences, sentence fragments, and the overuse of dashes and ellipses.&nbsp; Round out your exploration with the challenge of combining quotation marks with the ending marks.&nbsp; You&rsquo;ll get a fine update on what works and what doesn&rsquo;t with this first of three full lessons on punctuation.

Commas!&nbsp; Yes, you can master their use.&nbsp; Lesson 7 is designed to give you confidence in your comma placement.&nbsp; You&rsquo;ll learn how to use commas to create energy and precision in your writing.&nbsp; Instead of memorizing an intimidating list of rules, you&rsquo;ll learn by listening, clarifying, and practicing.&nbsp; You&rsquo;ll realize that you&rsquo;re in charge of your commas rather than being a passive victim.&nbsp; You&rsquo;ll get answers to all your lingering doubts about using commas here.&nbsp;

It&rsquo;s likely been a long time since your school days, and your knowledge of the correct use of all the punctuation marks may be a bit vague now.&nbsp; Lesson 8 to the rescue!&nbsp; The emphasis here will be on how to use punctuation marks like semicolons, colons, dashes, parentheses, ellipses, apostrophes, quotation marks, italics, and hyphens.&nbsp; You&rsquo;ll acquire a new understanding of the way these marks help you.&nbsp; You&rsquo;ll gain this understanding by discovering, through practice, how to punctuate for clarity and how to help your readers hear the way you want your words to sound.

You&rsquo;re building your knowledge brick by brick, and now it&rsquo;s time to tackle the most powerful organizing tool of all writing&mdash;the paragraph.&nbsp; Here you&rsquo;ll find tips on how to organize a paragraph, where to break one paragraph and start another, and how to sequence paragraphs for optimum understanding.&nbsp; As always, you&rsquo;ll get to practice these skills as you go, solidifying your knowledge and gaining new confidence.&nbsp; Dive in!

Now it&rsquo;s time to find out how to put all your good writing into the right format so you can communicate with power and precision.&nbsp; Formatting appeals to the eye of your readers and draws them into your content.&nbsp; It&rsquo;s a powerful tool and one that involves some creative choices on your part.&nbsp; Get ready to learn about your choices for overall form, as well as how to use basic and specific formatting tools to make your writing highly readable.

Learn how to write effectively in today&rsquo;s electronic world. Explore how the techniques of writing various types of electronic media such as e-mail, instant messages, and text messages, for example, differ from the techniques used to prepare messages that will be read on paper. It&rsquo;s a new world, and new rules are necessary to help you communicate well. This lesson will help you discover what works and what doesn&rsquo;t in these exciting and evolving media.&nbsp; You&rsquo;ll gain a new understanding of how to write powerful e-mail, since it&rsquo;s the most common of all electronic message systems.

Time to wrap up all you&rsquo;ve learned!&nbsp; Lesson 12 will help you practice using your new skills, working from freewriting to a finished document.&nbsp; You&rsquo;ll practice how to use both your creative and your critical skills while writing.&nbsp; You&rsquo;ll find out what kind of attitude will help you use your new skills and what good habits will help you continue to improve each time you write.&nbsp; You&rsquo;ll focus on revision, work with a revision checklist, and review good tips on proofreading.&nbsp; You&rsquo;ll put together all you&rsquo;ve learned so your writing continues to improve from this point forward.&nbsp;

Ann Linquist

Ann Linquist

Ann Linquist is a popular continuing education tutor, at corporations, and with non-profit organisations. She has helped thousands of adults learn to tackle their writing tasks with enthusiasm. Having written everything from novels to newsletters,... Read more

Read Ann Linquist'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 Essentials of Writing 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.

Microsoft Excel 2013 Advanced Online Course | Vibe Learning
 

Microsoft Excel 2013 Advanced

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

Master advanced features and functions of Microsoft Excel 2013, including analysis tools, data tables, PivotTables, and conditional formatting.

Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed course, you'll see how to maximise this program's functions and capabilities.

Most organisations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organisation.

You'll see how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's consolidation function to efficiently summarise data from multiple sources, become adept at importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.

Learn how Excel 2013 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!


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.

Over the next six weeks, we're going to explore Microsoft Excel 2013's sometimes-overlooked and advanced features. You'll learn how to use data analysis tools and techniques to improve your decision making, and you'll practice generating accurate data more quickly. By the end of this course, you'll be well prepared to contribute more value to your organization with your advanced understanding of Excel. To kick things off, we'll spend this first lesson exploring how you can modify Excel to streamline processes and make your work easier. You'll use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior, set up your Quick Access Toolbar, and take a look at the status bar and its customizable features. Mastering these processes will lay the foundation for our exploration of advanced topics throughout the course.

Today we'll explore some great table management features in Excel 2013, discuss how to use data forms with Excel databases, and look at a few alternative database techniques. You'll be glad to know that formatting and working with tables has gotten much easier in this latest version of Excel. Now, instead of applying filters, total rows, and formats separately, you can perform these actions through a single user interface. We'll delve into how it's done. You'll also learn how data forms provide a more user-friendly method for adding, deleting, and editing records in a table, and you'll practice using a data form to search for and view records that match specific criteria. We'll wrap things up with a brief look at some of the practical applications for data forms.

In this lesson, we'll tackle data validation techniques&mdash;your first line of defense against incorrect or missing data and the logical next step after data forms. You'll practice using whole number, decimal, date, time, list, and other forms of validation. After that, we'll explore the possibilities of custom validation, which allows you to apply validation on a cell or range of cells based on a formula you create. The possibilities for using it are limitless! You'll also learn how to create input messages and error alerts to guide the user's data entry, how to keep track of validation rules, and how to apply a custom validation rule to other cells so that you don't have to create it all over again.

In the first three lessons, we covered what you might call intro-level advanced Excel topics, and now it's time to head into more complex territory. So today, let's start working with custom controls&mdash;graphical objects that help facilitate data input and are sure to impress users. We'll start by getting your Ribbon set up to work with custom controls, and then we'll walk through some practice exercises. You'll learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes. You'll also master the process of creating a dynamic list box, which allows you to control the values in one list box based on the values chosen by your user in a separate custom control.

Today you'll discover how to use conditional formatting. And I'm not just talking about creating validation based on cell values. We'll do a quick review of that process, just as a refresher, but after that we're going to focus on formula conditional formatting. We'll work through nine different practice exercises that explore row conditional formatting, and we'll briefly discuss how the formula works after each exercise. You'll see how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row (my personal favorite), and more. I think you'll especially enjoy learning how to set up a scorecard, which will show you problem areas in red, possible problems in yellow, and everything running smoothly in green. (Your manager will love this.)

In this lesson, you'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. A lot of people do this the hard way, but with Excel's automatic consolidation feature, you'll no longer need to develop a web of formula links to multiple sources. Goodbye, potential for human error! We'll begin with an exercise on consolidating data within the same workbook, and after that, you'll practice consolidating using an advanced technique with category labels and wildcards. Next, we'll step things up with a practice exercise on consolidating from multiple workbooks. You'll also learn how to use automatic and manual outlining to view or hide different levels or sections of your information.

<P>Excel's functions (or predefined calculations) are too numerous to completely cover in one lesson, so today we'll just focus on a few important ones spanning four categories: <EM>Logical, Database, Math &amp; Trig</EM>, and <EM>Lookup &amp; Reference</EM>. We'll start today with an overview of functions, take a look at the Insert Function dialog box, and then practice working with the IF function, nesting functions, the DSUM function, and the VLOOKUP function&mdash;all of which will come in handy when you need to perform a quick, thorough analysis of your data. </P>

In this lesson, you'll find out all about importing external data. We'll begin with a practice exercise to get you comfortable with importing data from another Excel file, during which you'll see how to use the Microsoft Query Wizard. You'll test two methods for refreshing the target area for the imported data and find out how to edit an Excel query. After that, you'll do an import from an external database. Finally, you'll learn how to perform a Web query, which&mdash;you guessed it&mdash;allows you to import data from the Internet. The Web query feature is another fantastic feature in Excel 2013.

It's time to look at data tables, which let you compare the outcomes of different versions of the same formula without slogging through the process of calculating each of them. Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you'll learn how to use two types of data tables: a one-variable data table (which lets you substitute just one variable into the formula calculation) and the two-variable data table (which allows you to change multiple aspects of the formula).

Today we'll explore three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver. You'll find out how to use Goal Seek to solve formulas backward&mdash;for example, you might want to do this if you knew the result you wanted but needed to determine how to change a single input cell in order to get that desired result. After that, we'll practice using Scenario Manager to create and save different input values and their results as scenarios (great for working on budgets). And finally, you'll put Excel's Solver to work to discover the optimal solution to models that have multiple variables and constraints.

In this lesson, you'll discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you'll practice using both. You'll also learn how to edit a PivotTable, how to filter the table to create individual reports, how to format a PivotTable to make it reader-friendly, how to insert a Timeline, and how to create and use calculated fields and items. After this, you'll create a PivotChart based on the data fields in your PivotTable. We may not be quite done with the course, but after mastering PivotTables and PivotCharts, you'll certainly be able to count yourself an advanced Excel user.

We'll begin our final lesson with a look at the functions available in the Analysis ToolPak, including two of my favorites: the Moving Average and Sampling tools. You'll complete an exercise using advanced filters, and then I'll show you some of my favorite Excel tips and tricks. You'll find out how to work with the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook. We'll wrap things up with practice exercises using array formulas and the AutoSum Tool. When you're done with this lesson&mdash;and the course&mdash;you'll want to pass along the techniques you've learned to friends and colleagues who are still&nbsp;wrestling with Excel!

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 2013 Advanced 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.