Quotes

Welcome to Microsoft® Project 2013: Part 2. This course is designed to familiarize you with the advanced features and functions of Microsoft Project Professional 2013 so that you can use it effectively and efficiently in a real-world environment.*In Microsoft® Project 2013: Part 1, you learned the basic features of Microsoft® Project Professional 2013 during the planning phase of a project. You gained the knowledge and skills to:*Create a new project plan. This includes starting a blank project file or starting a project file from a template.*Manage time in a project plan. This includes changing the project time frame and calendar.*Manage tasks in a project plan. This includes adding tasks and linking them together into paths.*Manage resources in a project plan. This includes adding people, equipment, and materials to a project and assigning them to tasks.*Share a project plan. This includes saving, printing, emailing, and exporting project files.*Microsoft® Project 2013: Part 2 covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2013 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.*Each lesson in this course is built around the executing, monitoring, and controlling tasks that can be accomplished using the advanced commands found on one of these Project 2013 tabs: PROJECT, TASK, VIEW, or REPORT. This will enable you to become a “power user” and leverage the full potential of the application.*You can also use this course to prepare for the Microsoft Certified Technology Specialist (MCTS) in Microsoft Office Project 2013 certification.

You’ve used Office 2007 or Office 2010 to create various types of business materials from documents in Microsoft® Word to spreadsheets in Excel® to presentations in PowerPoint®. Perhaps you use Outlook® to manage your calendar, contacts, and email or Access to manage inventory and trouble tickets.*However you use Office, the fact is the Office suite of applications is the de-facto standard for business productivity software. Each new release of Office builds upon the successes of the previous generations.*This course builds upon the foundational Microsoft® Office 2007/2010 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.*You’ll explore a variety of enhancements, from Word’s ability to edit PDF files to the new Flash Fill functionality in Excel that dramatically increases the speed at which you can add data to a spreadsheet. You’ll discover how the cloud has been deeply integrated into your Office experience and how collaborating with colleagues has never been easier.*This Microsoft Office 2013: Transition from Office 2007/2010 course will help you bridge the gap from the version you already know and love to the latest release of Microsoft’s flagship productivity suite.

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. And that’s exactly what this course aims to help you do.*This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2013: Part 1 (Second Edition) course and will help start you down the road to creating advanced workbooks and worksheets that you can use to create dashboards. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level.

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.