Microsoft Excel 2007

In the business environment today, strong communication skills paired with the ability to utilize applications to their full functionality is invaluable to the information worker. A firm understanding of the applications you use everyday is essential towards efficiency and success in a dynamic environment. Obtain the skills necessary to optimize the benefits of Microsoft Word. Learn to easily create professional documents that reflect the quality of your work and enhance your value to your company.

Overview/Description
With the introduction of Office Excel 2007, Microsoft has made substantial changes to the user interface of its spreadsheet application. This course will help get you up-to-speed on the new features, and will introduce you to the basic features and functionality of Excel 2007. This will be accomplished through the demonstration of workbook creation and navigation, and worksheet data entry at a user-friendly beginner level.

Overview/Description
Excel 2007 provides a number of improved tools and new features that allow you to visually enhance the appearance of sheets and workbooks. Cells, rows, columns, sheets, and workbooks can be manipulated and customized using various positioning and formatting features. This course explores the processing of copying and moving cells, columns, rows, and sheets, as well as inserting or removing sheets and modifying workbooks. Formatting tables, textual data, and numerical data, as well as conditional formatting, is also covered.

Overview/Description
Excel 2007 simplifies the reviewing and printing processes by centralizing all related features within the various tabs of the Ribbon. The Review tab enables you to quickly access tools for proofing content and adding comments. Using the Page Layout view, you can preview how your worksheets will look when they are printed, and adjust them as needed to achieve professional results. This course explores Excel 2007 reviewing features, such as spellchecking, translating, and using comments. Configuring entire workbooks, spreadsheets, and spreadsheet selections for printing, using the Page Layout view, and printing using the Office button are also covered.

Overview/Description
Excel 2007 provides numerous functions and formulas for performing simple and complex calculations on workbook data. The Ribbon's Formulas tab provides convenient access to groups of data analysis and calculation tools, such as the Function Library, Named Cells, Formula Auditing, and Calculation groups. This course demonstrates how to create and edit formulas, use references and names, and work with tables in Excel 2007. Basic, logical, financial, and date functions are also covered.

Overview/Description
Enhancements to charting, themes, and styles in Excel 2007 enable you to create attractive and well-organized representations of spreadsheet and workbook data. Charts, themes, styles, and pictures can all be easily inserted and customized from the Ribbon bar. This course demonstrates how to effectively use and customize charts in Excel 2007, and explores available chart types and styles. Using themes and styles to improve presentation, and adding visual elements to workbooks, are also covered.

Overview/Description
Charts and pictures enable you to present data visually, demonstrating data more effectively than rows and columns of data. In Excel 2007, you can customize charts and their individual elements, as well as pictures and clip art, to create professional and appealing documents. Formatting, both custom and condition-based, enables you to display data in formats that best suit your needs. This course explores modifying charts and pictures and creating and editing custom number formats.

Overview/Description
Excel 2007 provides multiple features for organizing and managing data, so you can ensure data is entered correctly and that calculations and formulas are valid. Data organization features enable you to sort, filter, and group and outline data so that you can focus on the key parts of your data. Validation features ensure that data is correct, that it is entered in the proper format, and that formulas are working correctly, all of which are incredibly important for maintaining accurate records. This course explores organizing and subtotaling data in Excel 2007 using the available features. It also covers data validation, including error messages, invalid data prevention, formula auditing, error checking, and the Watch window.

Overview/Description
Numerous features and tools in Excel 2007 enable you to customize the look and feel of spreadsheets and workbooks, and also the functionality and efficiency of the program itself. Existing templates, themes, and styles can be altered to meet business needs, or you can create custom templates, themes, and styles to further enhance data presentation. Using macros, you can automate common or repetitive tasks, resulting in time savings and increased efficiency in day-to-day tasks. This course covers creating templates in Excel 2007, as well as customizing workbook properties, themes, and styles. Working with macros, including recording, editing, and running, is also explored.

Analyzing Data in Excel 2007

Overview/Description
Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. You can also use additional what-if analysis components, data tables and scenarios, to view how value changes in formulas affect the formula results and to forecast worksheet outcome models respectively. This course covers advanced data analysis features, such as PivotTable and PivotChart reports, Goal Seek, Solver, scenarios, data tables, and OLAP.

Protecting and Sharing Excel 2007 Workbooks

Overview/Description
In many organizations, teams and individuals require frequent and possibly simultaneous access to common spreadsheets and workbooks. To meet these demands without affecting efficiency, a number of review, security, and collaboration features are available in Excel 2007. Workbooks, worksheets, and specific data within worksheets, can be protected, enabling only those with access to view or make changes to them. Workbooks can be shared so that multiple people can access required data, and changes made to workbooks can be tracked, accepted or rejected, and merged. The use of Excel Services and Microsoft Windows SharePoint Services adds an additional level of collaboration and security features. This courses covers range, worksheet, and workbook protection, as well as tracking changes and merging workbooks in Excel 2007. Sharing workbooks, using Excel Services for collaboration, and publishing workbooks to SharePoint are also covered.

Exchanging Data with Excel 2007

Overview/Description
In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing Excel 2007 data into other applications and using XML in Excel 2007 are also covered.

TestPrep Using Excel 2007

Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

The core Microsoft Office Specialist Certification Program credential has been upgraded to validate skills with the 2007 Microsoft Office system as well as the new Windows Vista operating system. The Application Specialist certification targets Information Workers and covers the most popular Microsoft Office applications such as Word 2007, PowerPoint 2007, Excel 2007, and Outlook 2007. To earn MCAS certification you need to pass one of the five exams available. After passing an individual exam, a person becomes an MCAS in the particular software application they took the exam in.