Overview/Description Excel 2010 provides powerful data-analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. And you can use additional what-if analysis components, data tables and scenarios, to forecast worksheet outcome models and to see how changing values in formulas affect the formula results. Target Audience End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level...

Overview/Description To automate repetitive tasks, Excel 2010 provides a time saving feature known as a macro. These small programs, created using either a simple macro recorder or by using the more complex VBA language, allow you to record the numerous steps involved in accomplishing a task so that they can be played back automatically when the macro is run. This results in time savings and increased efficiency in day-to-day tasks. This course will introduce you to macros in Excel and show you how to leverage their power to make you work with Excel easier. Target Audience End users seeking...

Overview/Description Today people can collaborate on the development of PowerPoint presentations in new and exciting ways. With the proper technological infrastructure in place, PowerPoint has the capability of allowing multiple people to work on the single presentation at the same time. An alternative to co-authoring a presentation with other team members is to send the presentation as an e-mail attachment, save it to a web site, burn it on a CD, or broadcast it live over the Internet. To simplify the process of reviewing and accepting or rejecting changes, you can now merge the reviewed...

Overview/Description It's been said that communication is the single most important factor in the success or failure of a project. And it's not only what you communicate, but how you format your communications to ensure they are clear, concise, and targeted to your audience. This course introduces the different reporting options you have within Project 2010, including how to create and print standard reports and how to report project information using the Timeline view. This course also introduces techniques for adding graphics to reports. Target Audience Individuals involved in managing...