Exam 77-881: MOS: Using Microsoft Office Word 2010 Curriculum Outline
Getting Started with Word 2010
Overview/Description
Word 2010 is the newest version of Microsofts dynamic word processing tool and it offers features that allow you to create attractive and engaging documents. The Ribbon menu, which is unique to Microsoft Office, organizes Word’s many features into related tabs and makes it easier to quickly access those you need. The new Backstage view provides a single streamlined stage for all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of using Word 2010, including opening the application, creating new documents, and an introduction to the many tools that will help you create and edit your documents.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Getting Started with Word 2010
mo_bwrd_a01_dt_enus
Back to List
Formatting and Working with Text in Word 2010
Overview/Description
Word 2010 makes it easy to apply formatting to documents by providing a live visual preview of various formatting options. This allows you to view a variety of formatting changes before actually committing to them. This course explains the Font formatting options, as well as the Mini toolbar and Live Preview features. In addition, the creation and formatting of bulleted, numbered, and multilevel lists are demonstrated.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Formatting and Working with Text in Word 2010
mo_bwrd_a02_dt_enus
Back to List
Organizing and Arranging Text in Word 2010
Overview/Description
To create an attractive, coherent Word 2010 document, its important to understand the applications basic paragraph-formatting features. This course explores formatting paragraphs in Word 2010, along with a variety of other useful formatting tools such as margins and indents. The course demonstrates how to set margins, paragraph indenting and alignment, tab stops, and how to show or hide formatting marks than can help guide your formatting decisions.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Organizing and Arranging Text in Word 2010
mo_bwrd_a03_dt_enus
Back to List
Moving Around in Word 2010
Overview/Description
Word 2010 offers a variety of intuitive navigation features that help you move around and find your way through documents, whether theyre a few pages or hundreds of pages long! This course explores basic navigation features such as scrollbars and keyboard keys, along with built-in tools such as the new Navigation Pane. This pane combines features of the Document Map, thumbnails, and Search features found in earlier versions of Word into one, easy-to-use interface. The course also demonstrates how to use Words Full Screen Reading view to page through a file as if it were a printed document, and how to use Words Outline view to organize your document.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Moving Around in Word 2010
mo_bwrd_a04_dt_enus
Back to List
Structuring Word 2010 Documents
Overview/Description
Word 2010 provides many options for structuring your documents quickly and easily. This course demonstrates how to use headings to restructure the outline of a document using the Navigation Pane. If youre creating large documents with many pages, you might want to add page numbers to make your information easy to locate. The course explores how to add page numbers along with other structural components, such as page and sections breaks, headers, and footers.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Structuring Word 2010 Documents
mo_bwrd_a05_dt_enus
Back to List
Reviewing Documents in Word 2010
Overview/Description
No one wants to be embarrassed by glaring grammatical mistakes and misspellings in a document. To help you catch these errors, Word 2010 includes editing tools that enable you to spot and fix your typos as you work. It also enables you to use other proofing features such as a thesaurus, research options, and word count statistics to help you proof your work. In addition, you can make changes while reviewing your work using a feature that tracks all of your edits, and you can also leave comments during your review. This course explores all of these proofing features, from spelling and grammar correction to tracking changes. The course also demonstrates how to use the Help feature in Word 2010.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Reviewing Documents in Word 2010
mo_bwrd_a06_dt_enus
Back to List
Saving, Sharing, and Printing in Word 2010
Overview/Description
Once youve created an attractive, well-structured document, how do you save it for future use? Word 2010 enables you to save your documents in many formats, including the standard .docx file extension, along with the well-recognized .doc extension. You can also save your documents as PDF or XPS files to make them uneditable and give them standardized appearances for sharing. In addition, you can choose to save and send your document using e-mail, Microsoft SkyDrive, upload your document as a blog post, or save it on SharePoint. If you want to print your document, you can use Word 2010s new streamlined Print interface which presents print options, such as orientation and duplex printing, on the same page as a preview of your document. This course explores Word 2010s features for saving and printing your documents.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Saving, Sharing, and Printing in Word 2010
mo_bwrd_a07_dt_enus
Back to List
Customizing the Behavior and Appearance of Word 2010
Overview/Description
Word 2010 enables you to efficiently create attractive and organized documents using a variety of automated and pre-built features. You can quickly and easily use any of the Word 2010 styles to give your document a polished appearance, or you can create your own styles so you can use a custom appearance over and over. In addition, Word 2010 enables you to create documents using pre-built templates that are bundled with Word, saving you time and effort in choosing a layout and color scheme for your files. This course introduces Quick Styles and templates, and also explores an editing feature – AutoCorrect – that automatically corrects common errors such as not capitalizing the first letter of a sentence, or accidental usage of the Caps Lock key. The course also demonstrates how you can customize the Ribbon.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Customizing the Behavior and Appearance of Word 2010
mo_bwrd_a08_dt_enus
Back to List
Drawing and Inserting Graphics in Word 2010
Overview/Description
We all know that to create an effective Word document, your text must be clear and organized, but we sometimes neglect the overall attractiveness of our documents. This course demonstrates powerful drawing and graphic features of Word 2010 - features that can boost the appeal of virtually any document! The course focuses on the processes and tools that allow you to add pictures, Clip Art, screenshots, and SmartArt to your documents. It also explores drawing components such as shapes, WordArt, and text boxes.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Drawing and Inserting Graphics in Word 2010
mo_bwrd_a09_dt_enus
Back to List
Using Themes, Backgrounds, Watermarks, and Quick Parts in Word 2010
Overview/Description
Office Word 2010 offers a variety of layout tools and features that allow you to enhance the visual appearance of your documents. This course shows you how to apply themes, including theme colors, fonts and effects, to create polished, professional-looking documents. It also guides you through using the Quick Parts Gallery to save commonly-used text and images as reusable items, and also apply AutoText, Document Properties and other building blocks to a page quickly and easily. In addition, the course explores tools that help protect your intellectual property by enabling you to add watermarks and backgrounds.
Target Audience
Individuals and business users with basic computer literacy and some experience using Microsoft Word
Expected Duration (hours)
1.0
Lesson Objectives
Using Themes, Backgrounds, Watermarks, and Quick Parts in Word 2010
mo_awrd_a01_dt_enus
Back to List
Adding Tables of Contents, Footnotes, Hyperlinks, and Bookmarks in Word 2010
Overview/Description
Word 2010 offers you a variety of tools that allow you to insert navigation and reference materials into a document. With heading styles applied to your document, you can easily construct a table of contents; you can also insert footnotes and endnotes, and you can quickly link to web pages, shared files, or other sections of a document using bookmarks. This course explores all of these topics, and discusses how to use each feature to improve the readability of your documents.
Target Audience
Individuals and business users with basic computer literacy and some experience using Microsoft Word
Expected Duration (hours)
1.0
Lesson Objectives
Adding Tables of Contents, Footnotes, Hyperlinks, and Bookmarks in Word 2010
mo_awrd_a02_dt_enus
Back to List
Forms, Fields, and Mail Merge in Word 2010
Overview/Description
Word 2010 enables you to create forms quickly and easily, so that they can be used by other users of Word 2010. Forms contain editable form controls that you can link to external data sources, and Word 2010 contains security features to protect forms from tampering by other users. Another method of capturing document information is by using fields. You can use fields to add information about a file into the document. For example, you can insert an Author field to insert the authors name, or use a LastSavedBy field to enter the name of the person who last saved the document. Word 2010s mail merge feature enables users to merge content such as address blocks into letters, e-mail messages, envelopes, and labels very easily. This course demonstrates how to add, modify, and update forms and fields, and also illustrates the various mail merge capabilities of Word 2010.
Target Audience
Individuals and business users with basic computer literacy and some experience using Microsoft Word
Expected Duration (hours)
1.0
Lesson Objectives
Forms, Fields, and Mail Merge in Word 2010
mo_awrd_a03_dt_enus
Back to List
Managing, Inspecting, and Recovering Word 2010 Documents
Overview/Description
Microsoft Word 2010 offers several options for securing and protecting Word documents as well as providing various features you can use to recover and repair documents. This course demonstrates how to use Word 2010 document security, which includes viewing document properties such as presence information on author contact cards, locking document formatting, password protecting documents, using the Document Inspector, and working with digital signatures. The course also explores recovering unsaved drafts and damaged Word 2010 documents.
Target Audience
Individuals and business users with basic computer literacy and some experience using Microsoft Word
Expected Duration (hours)
1.0
Lesson Objectives
Managing, Inspecting, and Recovering Word 2010 Documents
mo_awrd_a04_dt_enus
Back to List
Creating and Formatting Tables in Word 2010
Overview/Description
Word 2010 has a robust set of tools that allow you to create, style, and format tables in your documents. This course explores the various methods of inserting tables in Word documents, including selecting a layout from a list of preformatted tables, choosing a table size by selecting a layout from a dynamic grid, and by configuring table settings to match the number of columns and rows that you require. It also discusses using table styles to enhance the appearance of tables and changing the layout of tables.
Target Audience
Individuals and business users with basic computer literacy and some experience using Microsoft Word
Expected Duration (hours)
1.0
Lesson Objectives
Creating and Formatting Tables in Word 2010
mo_awrd_a05_dt_enus
Back to List
Manipulating Tables in Word 2010
Overview/Description
You can use Word 2010s features for both designing tables and manipulating your table data. A variety of layout tools allow you to merge and split cells, split tables, autofit cell sizes to match the size of contents, and insert and delete cells. You can also easily insert columns and rows, and then adjust their layouts and distribution. This course explores these methods of altering a tables layout and also walks you through using data tools that allow you to easily sort your data, making critical information easier to locate. The course also covers using formulas in Word 2010 tables, so you can quickly perform calculations or insert other pre-built mathematical functions.
Target Audience
Individuals and business users with basic computer literacy and some experience using Microsoft Word
Expected Duration (hours)
1.0
Lesson Objectives
Manipulating Tables in Word 2010
mo_awrd_a06_dt_enus
Back to List
Embedding Charts and Tables into Word 2010
Overview/Description
Word 2010 offers a wide variety of table and charting tools that let you manipulate and display your data in an attractive, understandable manner. This course shows you that by following a few simple steps you can easily paste Excel data into Word 2010 and either embed the values directly in the Word document or link back to the original Excel workbook. The course also discusses the role of Excel 2010 in Word 2010 table creation and manipulation. And it explores methods of inserting and then designing and altering the layout of many types of charts, including bar charts, pie charts, bubble charts and more.
Target Audience
Individuals and business users with basic computer literacy and some experience using Microsoft Word
Expected Duration (hours)
1.0
Lesson Objectives
Embedding Charts and Tables into Word 2010
mo_awrd_a07_dt_enus
Back to List
Exam 77-882: MOS: Using Microsoft Office Excel 2010 Curriculum Outline
Getting Started with Excel 2010
Overview/Description
Excel 2010 is the newest version of Microsofts comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Getting Started with Excel 2010
mo_bexl_a01_dt_enus
Back to List
Applying Basic Data Formatting in Excel 2010
Overview/Description
Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in Excel 2010.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Applying Basic Data Formatting in Excel 2010
mo_bexl_a02_dt_enus
Back to List
Moving and Getting Around in Excel 2010
Overview/Description
While it can look complicated and daunting, navigating the Excel interface isnt as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excels many Help features.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Moving and Getting Around in Excel 2010
mo_bexl_a03_dt_enus
Back to List
Moving Data and Modifying Worksheets in Excel 2010
Overview/Description
The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if its copied between Office applications, and the Paste Special option allows you to further define how your data is copied or moved. This course is designed to show you many of the ways that Excel 2010 allows you to manipulate data and the worksheets that contain them and describes features that let you do this quickly and efficiently.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Moving Data and Modifying Worksheets in Excel 2010
mo_bexl_a04_dt_enus
Back to List
Saving, Sending, and Printing Excel 2010 Workbooks
Overview/Description
Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options – saving, printing, and sharing – are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and productivity.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Saving, Sending, and Printing Excel 2010 Workbooks
mo_bexl_a05_dt_enus
Back to List
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
Overview/Description
Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features – tables, styles, conditional formatting, and sparklines – how to access them and how to use them, are covered in this course.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Using Conditional Formatting, Tables, and Sparklines in Excel 2010
mo_bexl_a06_dt_enus
Back to List
Reviewing and Protecting Content in Excel 2010
Overview/Description
Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Reviewing and Protecting Content in Excel 2010
mo_bexl_a07_dt_enus
Back to List
Using Basic Formulas in Excel 2010
Overview/Description
Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Using Basic Formulas in Excel 2010
mo_bexl_a08_dt_enus
Back to List
Using Basic Functions with Excel 2010
Overview/Description
One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to chose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excels status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Using Basic Functions with Excel 2010
mo_bexl_a09_dt_enus
Back to List
Inserting Basic Charts in Excel 2010
Overview/Description
Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualization of your data.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Inserting Basic Charts in Excel 2010
mo_bexl_a10_dt_enus
Back to List
Adding Visuals, Themes, and Styles to Excel Workbooks
Overview/Description
Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Adding Visuals, Themes, and Styles to Excel Workbooks
mo_bexl_a11_dt_enus
Back to List
Customizing Visual Elements in Excel 2010
Overview/Description
Adding visual elements to Excel worksheets can help to enhance what can sometimes be dry facts and figures, making it easier to hold the attention of the intended audience. A balance needs to be struck, however, between enhancing and overwhelming when it comes to adding graphics and colors to your Excel workbooks. Excel 2010 provides you with a number of basic and advanced techniques for customizing common elements such as charts, themes, cell styles, and graphics. This course describes many of these techniques and shows you how to implement them to their best effect.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
Customizing Visual Elements in Excel 2010
mo_aexl_a01_dt_enus
Back to List
Customizing Workbook Settings, Conditional Formatting, and Number Formats
Overview/Description
You can customize the look and feel of workbooks and the programs functionality and efficiency using Excel 2010s numerous features and tools. You can modify existing themes and styles to meet business needs, or you can create custom themes and styles to further enhance data presentation. Custom number formats allow you even more control over the presentation and usefulness of your workbooks and conditional formatting gives you the power to apply individual formatting based on custom rules that meet your specific needs. This course explores some of the more advanced ways that you can enhance your workbooks and data using Excel 2010s powerful customization features.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
Customizing Workbook Settings, Conditional Formatting, and Number Formats
mo_aexl_a02_dt_enus
Back to List
Organizing Data and Objects in Excel 2010
Overview/Description
Excel 2010 provides multiple features for organizing and managing data, including sorting and filtering tools that are integral to data analysis. Using data organization features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Arrange group allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2010 using the built-in features. It also covers arranging objects for better viewing as well as the use of hyperlinks to organize data.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
Organizing Data and Objects in Excel 2010
mo_aexl_a03_dt_enus
Back to List
Ensuring Excel 2010 Data and Formulas are Right
Overview/Description
Formulas are an integral and important feature of Excel 2010. So ensuring they are correct can save you time and a lot of headaches. Excel 2010 provides you with the tools you need to audit formulas and correct errors that may be found. In addition, using Excels data validation tools you can restrict the types of data that can be input to your workbooks – preventing data entry errors that could otherwise occur. This course describes Excel 2010s auditing and formula correction features and shows you how to use data validation to avoid worksheet errors.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
Ensuring Excel 2010 Data and Formulas are Right
mo_aexl_a04_dt_enus
Back to List
Automating Excel Tasks using Macros
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 proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
Automating Excel Tasks using Macros
mo_aexl_a05_dt_enus
Back to List
Analyzing Data with What-if Analysis
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
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
Analyzing Data with What-if Analysis
mo_aexl_a06_dt_enus
Back to List
PivotTables and PivotCharts in Excel 2010
Overview/Description
One of the most powerful tools that Excel 2010 provides is a PivotTable that allows you to dynamically reorganize and display your data. PivotTables can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. PivotTables also allow you to choose and change what you want to summarize, quickly and easily. This course will introduce you to PivotTables and show you the many benefits they provide.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
PivotTables and PivotCharts in Excel 2010
mo_aexl_a07_dt_enus
Back to List
PivotTable Filters, Calculations, and PowerPivot
Overview/Description
PivotTables are a handy tool for summarizing large amounts of data efficiently and making it more manageable. Sometimes, though, its useful to be able to filter the data in a PivotTable, and Excel 2010 provides filtering functionality for this specific purpose. For those people who require a more visual representation of data, Excel 2010 provides a new feature called a Slicer, which is basically a graphical representation of a PivotTable filter. Excel also provides a number of ways in which you can apply calculations to the data in PivotTables in the form of summary functions and custom calculations. All of these useful features of Excel 2010 are introduced and described in this course.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
PivotTable Filters, Calculations, and PowerPivot
mo_aexl_a08_dt_enus
Back to List
Sharing Excel 2010 Workbooks Online and on a Network
Overview/Description
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in a shared workbook. This course covers sharing Excel 2010 workbooks on a network with advanced sharing options, the limitations of shared workbooks, and the uses and limitations of IRM. It also covers how to limit users editing to specific cell ranges in a worksheet, and how to apply the AutoRepublish feature when saving workbooks for use on the Web.
Target Audience
End users who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Sharing Excel 2010 Workbooks Online and on a Network
mo_pexl_a01_dt_enus
Back to List
Using Excel 2010 to Collaborate Online and with Other Office Applications
Overview/Description
Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in todays business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including information on the Web App interface, its limitations, and how to access the full version of Excel 2010 from within it. In addition, this course covers exporting data from a SharePoint list to Excel, and exporting data from Excel into a SharePoint list. Linking Office 2010 content to and embedding Office 2010 content in Excel workbooks is also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Using Excel 2010 to Collaborate Online and with Other Office Applications
mo_pexl_a02_dt_enus
Back to List
Using Lookup, Reference, Math, and Text Functions in Excel 2010
Overview/Description
The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Using Lookup, Reference, Math, and Text Functions in Excel 2010
mo_pexl_a03_dt_enus
Back to List
Manipulating Formulas and Using Forms in Excel 2010
Overview/Description
Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course explores the available cube functions, such as CUBEMEMBER, CUBESET, and CUBEVALUE. Summarizing data using conditional functions such as SUMIF and COUNTIFS are also covered. This course also examines the methods Excel 2010 provides for working with arrays, including one-dimensional and two-dimensional arrays. Adding form and ActiveX Controls to Excel worksheets is also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Manipulating Formulas and Using Forms in Excel 2010
mo_pexl_a04_dt_enus
Back to List
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
Overview/Description
There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online data and use it within Excel. Importing XML data is covered, and the course also describes the process of using the Query Wizard to create and edit queries.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
mo_pexl_a05_dt_enus
Back to List
Exam 77-883: MOS: Using Microsoft Office PowerPoint 2010 Curriculum Outline
Getting Started with PowerPoint 2010
Overview/Description
PowerPoint 2010 is a presentation program that allows you to create professional-looking slide-show presentations. This course provides an introduction to the main components of the PowerPoint 2010 interface. It covers opening and saving a presentation, working with slides, formatting text and text boxes, and using templates and themes to create professional looking presentations.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Getting Started with PowerPoint 2010
mo_bppt_a01_dt_enus
Back to List
Visually Enhancing PowerPoint 2010 Presentations
Overview/Description
PowerPoint 2010 enables you to create visually appealing presentations through the use of graphics. Adding simple enhancements through the use of themes, tables, charts, and SmartArt allows you to create more engaging and interesting presentations. This course introduces the various themes and SmartArt features that allow you to add flair to your presentations by using colors and shapes to emphasize text and data. Also covered are the various ways of incorporating diagrams, tables, and charts to create a professional and effective presentation.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Visually Enhancing PowerPoint 2010 Presentations
mo_bppt_a02_dt_enus
Back to List
Adding Images to Presentations in PowerPoint 2010
Overview/Description
Inserting images, such as photographs, clip art, and shapes, into your PowerPoint 2010 presentation can help to capture and keep the attention of your audience. This course will show you how to insert, format, and apply special effects to your images so that they provide the maximum impact for your presentation. You will learn how to create a photo album and create a presentation that effectively displays your favorite photos. In addition, you will be shown how to use the new built-in screen capture tool that enables you to capture and embed screenshots of other programs into your slides.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Adding Images to Presentations in PowerPoint 2010
mo_bppt_a03_dt_enus
Back to List
Using Multimedia and Animations in PowerPoint 2010
Overview/Description
PowerPoint 2010 can help you make presentations more dynamic by adding audio and video clips to any slide. You can directly insert, edit, and play video in your presentation, as well as add audio clips to create attention-grabbing sound effects. PowerPoint 2010 also has new animation tools and slide transitions which make slide shows more fluid and interesting. All of these features are discussed in this course.
Target Audience
Individuals and business users with basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Using Multimedia and Animations in PowerPoint 2010
mo_bppt_a04_dt_enus
Back to List
Using Advanced Slide Show Tools in PowerPoint 2010
Overview/Description
PowerPoint 2010 provides you with all the tools necessary to create and present engaging and effective presentations. As an advanced user, you can take advantage of features that allow you to customize your animations to create just the right effect. PowerPoint has tools for getting your animations to move at the right speed and in the right order. There are also built-in tools, such as the animation painter, that allow you to easily apply an animation scheme to the entire presentation in one easy step. Once you have perfected your presentation, you can set and rehearse timings, create mouse-over actions for elements on a slide, and record your presentation for automatic delivery. There are also many tools that make the presentation of your slide show easy and effective, such as highlighters and laser pointers. These tools and features are all covered in this course.
Target Audience
End users seeking proficiency in the use of Microsoft PowerPoint 2010 at an advanced level
Expected Duration (hours)
1.0
Lesson Objectives
Using Advanced Slide Show Tools in PowerPoint 2010
mo_appt_a01_dt_enus
Back to List
Collaborating and Sharing Presentations in PowerPoint 2010
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 version with your original version into one presentation. This course explores these topics and many other collaboration features available in PowerPoint 2010. Also covered are proofing, language, and research tools, along with options for printing and protecting a presentation.
Target Audience
End users seeking proficiency in the use of Microsoft PowerPoint 2010 at an advanced level
Expected Duration (hours)
1.0
Lesson Objectives
Collaborating and Sharing Presentations in PowerPoint 2010
mo_appt_a02_dt_enus
Back to List
Exam 77-884: MOS: Using Microsoft Office Outlook 2010 Curriculum Outline
Getting Started with Outlook 2010
Overview/Description
Outlook 2010 is the latest release of Microsoft’s primary messaging client. Outlook provides all of the tools necessary to manage e-mail, scheduling , tasks, and communication. The Outlook 2010 interface has been updated and now uses the ribbon instead of menus, which makes it easier to locate the commands you need. This course addresses the basic features and functionality of Outlook 2010, including an introduction to the redesigned interface, how to create e-mail messages, and view and reply to incoming e-mails.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Getting Started with Outlook 2010
mo_bout_a01_dt_enus
Back to List
Managing Conversations and Organizing E-mail in Outlook 2010
Overview/Description
Microsoft Outlook 2010 provides you with the tools you need to efficiently manage and organize your e-mail messages. Included in Outlook 2010 is a new Conversation view that automatically groups all of your messages by subject, greatly reducing the number of items in your Inbox. This feature along with options that allow you to categorize and flag messages are discussed in the course. Also, covered are the ways you can organize messages in the Inbox.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Managing Conversations and Organizing E-mail in Outlook 2010
mo_bout_a02_dt_enus
Back to List
Managing Attachments, Graphics, Signatures, and Autoreplies in Outlook 2010
Overview/Description
Using Outlook 2010 you can now create e-mail messages that include compelling visuals and graphics that capture the reader’s attention. You can also attach and format screenshots from your computer to better convey ideas in your message. This course discusses working with attachments in Outlook 2010 as well as including graphics, tables, symbols, and links in your messages. How to add signatures to e-mail and auto replying to messages that you receive are also covered.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Managing Attachments, Graphics, Signatures, and Autoreplies in Outlook 2010
mo_bout_a03_dt_enus
Back to List
Using the Calendar for Appointments, Events, and Meetings in Outlook 2010
Overview/Description
The Outlook 2010 Calendar allows you to create appointments and events, as well as schedule meetings. The Calendar is fully integrated with the other components of Microsoft Outlook 2010 allowing you to easily incorporate your contacts and e-mail functionality with the Calendar. This course introduces the major components of the Calendar as well as providing a tour of the interface. Also discussed are how to create appointments and events, and how to schedule meetings with other Outlook users.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Using the Calendar for Appointments, Events, and Meetings in Outlook 2010
mo_bout_a04_dt_enus
Back to List
Managing Meetings and Customizing the Calendar in Outlook 2010
Overview/Description
The main functions of the Calendar in Outlook 2010 have remain largely unchanged from previous versions of Outlook. However, many tasks have been streamlined. It is now easier to create and view additional calendars in Outlook 2010 and viewing group calendars has been integrated into the Calendar view. This course demonstrates the available options when replying to meeting requests and managing meeting requests. It covers how to create and view additional calendars, view another persons calendar, and create a calendar group. Also covered are ways to customize the Outlook 2010 calendar.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Managing Meetings and Customizing the Calendar in Outlook 2010
mo_bout_a05_dt_enus
Back to List
Outlook 2010 Social Connector and Messaging
Overview/Description
With Outlook 2010 it is now easier than ever to keep track of your friends and colleagues as well as communicate with them using a variety of methods. With the rise in popularity of social networking sites, Outlook 2010 now includes the ability to track updates of your friends from within Outlook. This course discusses the Outlook Social Connector and how to configure Outlook to connect to social networking sites. How to configure and use both instant and text messaging from within Outlook is also discussed.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Outlook 2010 Social Connector and Messaging
mo_bout_a06_dt_enus
Back to List
Working with Contacts in Outlook 2010
Overview/Description
By taking the time to create contacts in Outlook 2010, you can save yourself from having to type out full e-mail addresses every time you send a message, assign a task or send out meeting requests. You can further arrange contacts by creating contact groups that allow you to e-mail multiple contacts at once by only typing the group name. This course covers the multiple ways that contacts can be created, as well as how to modify existing contacts, and import and export contacts between Microsoft Outlook 2010 and Google Gmail.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Working with Contacts in Outlook 2010
mo_bout_a07_dt_enus
Back to List
Using the Tasks, Notes, and Journal Features in Outlook 2010
Overview/Description
To assist you with the various tasks and information that you need to process on a daily basis, Microsoft Outlook 2010 provides the Tasks, Notes, and Journal features to help keep you organized. You can create tasks for yourself or assign tasks to other users. You can create notes for yourself as small reminders, and manage your activities and information using the Journal. This course discusses how the Tasks, Notes, and Journal features can help you to manage your time and stay organized, and it demonstrates how to use them.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Using the Tasks, Notes, and Journal Features in Outlook 2010
mo_bout_a08_dt_enus
Back to List
Formatting E-mail and Configuring Message Options in Outlook 2010
Overview/Description
The default installation of Outlook 2010 allows you to easily send and receive messages among colleagues and friends. There are, however, many options that help you make creative, more visually appealing messages, as well as options that change how messages are sent. This course discusses sending e-mail in different message formats as well as formatting options that can be applied to the text and background of an e-mail. Also covered are how to check your messages spelling and grammar, how to track outgoing messages, how to add voting buttons, and how to set importance and sensitivity options.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Formatting E-mail and Configuring Message Options in Outlook 2010
mo_aout_a01_dt_enus
Back to List
Customizing Outlook 2010 and Managing Accounts
Overview/Description
Outlook 2010 has now adopted a Ribbon, similar to the other products in the Office suite, which provides an intuitive interface with most commands readily available. The Outlook interface is highly customizable as well. This course discusses how to modify the Ribbon to suit your preferences, as well as ways that views and panes can be customized. Configuring Exchange e-mail accounts are also discussed.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Customizing Outlook 2010 and Managing Accounts
mo_aout_a02_dt_enus
Back to List
Managing E-mail with Rules, Automatic Replies, and Alerts in Outlook 2010
Overview/Description
Outlook 2010 contains numerous features to help manage the large volume of e-mail that many users receive on a daily basis. Options can be configured to automatically move incoming e-mail into specified folders and Desktop Alerts can be set to notify you of incoming e-mail. This course discusses managing e-mail messages with rules as well as configuring automatic replies and Desktop Alerts for incoming messages.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Managing E-mail with Rules, Automatic Replies, and Alerts in Outlook 2010
mo_aout_a03_dt_enus
Back to List
Working with File Transfer and Folders, Searching, and RSS Feeds Outlook 2010
Overview/Description
Outlook 2010 provides default folders such as the Inbox, Deleted Items, and Sent Items to assist users in managing and organizing their e-mail messages. Sometimes these folders do not meet all of a user’s needs and additional folders need to be created. This course discusses the creation and management of additional folders in Outlook, as well as the creation of Search folders, which is a type of virtual folder used to automatically organize messages. The course covers how to use the Instant Search feature, which allows you to instantly find e-mail messages, and how to refine your searches. Importing and exporting files are demonstrated. RSS feeds and how they can be used in Outlook 2010 are also discussed.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Working with File Transfer and Folders, Searching, and RSS Feeds Outlook 2010
mo_aout_a04_dt_enus
Back to List
Implementing Security with Outlook 2010
Overview/Description
Outlook 2010 provides a number of security options that should be enabled to protect you from viruses, unwanted junk mail, and other malicious attacks directed at computer users. This course explains how to protect yourself from spam, junk mail, and phishing attacks as well as how to safely open suspicious messages and attachments. To ensure that no unwanted users can read messages that are not directed towards them, digital signatures can be used. This course discusses how to obtain and apply digital signatures to messages.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Implementing Security with Outlook 2010
mo_aout_a06_dt_enus
Back to List
Exam 77-885: MOS: Using Microsoft Office Access 2010 Curriculum Outline
Getting Started with Access 2010
Overview/Description
Access 2010 is the newest version of Microsofts dynamic database management tool and it offers features that allow you to create and modify a variety of database types. The ribbon is unique to Microsoft Office and stacks the many features of Access into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all database file-level tools, such as those used for saving, creating databases and tables, and working with external data. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2010.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Getting Started with Access 2010
mo_bacc_a01_dt_enus
Back to List
Creating Basic Tables in Access 2010
Overview/Description
Microsoft Office Access 2010 makes it easy for you to create and modify database tables. This course discusses how basic tables are built, including creating fields and defining data types and properties, and how to modify them. It also demonstrates the use of primary keys, masked input fields, and indexing, as well as creating validation rules for the data.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Creating Basic Tables in Access 2010
mo_bacc_a02_dt_enus
Back to List
Data Manipulation and Simple Relationships in Access 2010
Overview/Description
The ability to manipulate data, records, and relationships in Access 2010 is a valuable asset to any database administrator. Access 2010 provides you with the data manipulation and table relationship techniques necessary for reliable databases. This course demonstrates how to perform basic data manipulation tasks, how to import and export data, and how to implement and edit table relationships.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Data Manipulation and Simple Relationships in Access 2010
mo_bacc_a03_dt_enus
Back to List
Introduction to Forms in Access 2010
Overview/Description
Microsoft Office Access 2010 offers several options for creating and managing forms and controls. This course describes how to create forms in Access 2010 and also explores controls - the available types, how they are added to a form, how their properties are set, and how they are resized, moved, grouped, and positioned on a form. It also demonstrates how to configure the Web Browser Control, which is a new feature of Access 2010.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Introduction to Forms in Access 2010
mo_bacc_a04_dt_enus
Back to List
Modifying Basic Forms in Access 2010
Overview/Description
Access 2010 allows you to make a variety of changes to the look and feel of a form. These changes range from resizing columns and controls to applying Office 2010 themes and managing records in a form. Access 2010 also introduces a new form type, the navigation form, which you can use as a switchboard to navigate the various objects in a database. This course covers how to use these methods to customize and format forms in Access 2010 as well as how to create and modify navigation forms.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Modifying Basic Forms in Access 2010
mo_bacc_a05_dt_enus
Back to List
Introduction to Queries in Access 2010
Overview/Description
Queries are used in Access 2010 to convert data into useful information and are an essential part of any database application. This course demonstrates how to create and modify a query in order to achieve specific results. It covers creating basic select queries, using Expression Builder, calculated fields, and grouping options for displaying query results. This course also demonstrates how to create crosstab, unmatched, and find duplicates queries.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Introduction to Queries in Access 2010
mo_bacc_a06_dt_enus
Back to List
Introduction to Reports in Access 2010
Overview/Description
Reports are used in Access 2010 to convert data into useful information and are an essential part of any database application. Access 2010 provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, Report Design, and Labels. Also covered is how to add and bind controls, group and sort data, and perform calculations.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Introduction to Reports in Access 2010
mo_bacc_a07_dt_enus
Back to List
Advanced Importing and Exporting with Access 2010
Overview/Description
Microsoft Office Access 2010 offers several advanced options for importing and exporting data. With Access 2010 you can link to, or import data and objects from external sources, such as other Access databases, SQL Server databases, Excel spreadsheets, Microsoft Word files, and XML files. You can also export data and objects from an Access 2010 database to a variety of external sources. This course explains and demonstrates the various methods of importing, exporting, and linking to external data sources in Access 2010.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Advanced Importing and Exporting with Access 2010
mo_aacc_a01_dt_enus
Back to List
PivotTables and PivotCharts in Access 2010
Overview/Description
This course demonstrates how to create and manipulate PivotTables and PivotCharts as an effective way to organize and display Access 2010 database data, such as showing and hiding data, sorting and filtering data, performing basic and complex calculations, and exporting to an Excel spreadsheet.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
PivotTables and PivotCharts in Access 2010
mo_aacc_a02_dt_enus
Back to List
Retrieving, Validating, and Attaching Data in Access 2010
Overview/Description
You can use Microsoft Access 2010 to manage your data efficiently using advanced techniques. There are many methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates advanced techniques for retrieving and validating data in Access 2010. These include such features as lookup fields and using the Expression Builder to aid in the validation of controls. How to attach files to tables and forms, and edit them, is also demonstrated.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Retrieving, Validating, and Attaching Data in Access 2010
mo_aacc_a03_dt_enus
Back to List
Subforms, Subreports, and Conditional Formatting in Access 2010
Overview/Description
Subforms and subreports allow you to display related data from separate sources in a single interface in Access 2010. This course will demonstrate how to use Access 2010 to create and use subforms and subreports. It also explores how to apply conditional formatting to tables, forms, and reports using the streamlined conditional Formatting Rules Manager.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Subforms, Subreports, and Conditional Formatting in Access 2010
mo_aacc_a04_dt_enus
Back to List
Joins, SQL, and Action Queries in Access 2010
Overview/Description
Advanced query methods in Access 2010 make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a way that the data is easy to interpret and analyze. This course describes the various types of join and parameter queries that can be used in Access 2010 and provides demonstrations on the use of action queries, including update, append, delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Joins, SQL, and Action Queries in Access 2010
mo_aacc_a05_dt_enus
Back to List
Using Access 2010 with SharePoint and Access Services
Overview/Description
Access 2010 and Windows SharePoint Services provide a tightly integrated solution for making Access databases web capable. This course details the primary features that allow for the seamless integration of Access and SharePoint so that data can be shared across corporate networks or the Internet. It demonstrates how to share Access and SharePoint data, and how Access and SharePoint work together with a new feature called Access Services to make entire applications available through SharePoint.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Using Access 2010 with SharePoint and Access Services
mo_aacc_a06_dt_enus
Back to List
Access 2010 Macros and VBA
Overview/Description
Using Access macros and Visual Basic for Applications (VBA) code, you can easily add functionality to a database to suit your business needs. This course provides an introduction to programming in Access 2010 and explores when to use macros or VBA code to automate processes. It demonstrates how to create and modify different types of macros as well as how to specify actions, conditions, and event handlers.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Access 2010 Macros and VBA
mo_aacc_a07_dt_enus
Back to List
Optimizing, Securing, and Sharing Access 2010 Databases
Overview/Description
Access 2010 provides a variety of tools to assist you in optimizing, securing, and sharing a database application. This course demonstrates how to assess a databases performance and improve its efficiency. Also covered are the ways that you can secure a database for users and the common methods employed to share a completed database application.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Optimizing, Securing, and Sharing Access 2010 Databases
mo_aacc_a08_dt_enus
Back to List
Exam 77-888: MOS: Microsoft Office Excel 2010 Expert Curriculum Outline
Sharing Excel 2010 Workbooks Online and on a Network
Overview/Description
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in a shared workbook. This course covers sharing Excel 2010 workbooks on a network with advanced sharing options, the limitations of shared workbooks, and the uses and limitations of IRM. It also covers how to limit users editing to specific cell ranges in a worksheet, and how to apply the AutoRepublish feature when saving workbooks for use on the Web.
Target Audience
End users who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Sharing Excel 2010 Workbooks Online and on a Network
mo_pexl_a01_dt_enus
Back to List
Using Excel 2010 to Collaborate Online and with Other Office Applications
Overview/Description
Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in todays business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including information on the Web App interface, its limitations, and how to access the full version of Excel 2010 from within it. In addition, this course covers exporting data from a SharePoint list to Excel, and exporting data from Excel into a SharePoint list. Linking Office 2010 content to and embedding Office 2010 content in Excel workbooks is also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Using Excel 2010 to Collaborate Online and with Other Office Applications
mo_pexl_a02_dt_enus
Back to List
Using Lookup, Reference, Math, and Text Functions in Excel 2010
Overview/Description
The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Using Lookup, Reference, Math, and Text Functions in Excel 2010
mo_pexl_a03_dt_enus
Back to List
Manipulating Formulas and Using Forms in Excel 2010
Overview/Description
Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course explores the available cube functions, such as CUBEMEMBER, CUBESET, and CUBEVALUE. Summarizing data using conditional functions such as SUMIF and COUNTIFS are also covered. This course also examines the methods Excel 2010 provides for working with arrays, including one-dimensional and two-dimensional arrays. Adding form and ActiveX Controls to Excel worksheets is also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Manipulating Formulas and Using Forms in Excel 2010
mo_pexl_a04_dt_enus
Back to List
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
Overview/Description
There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online data and use it within Excel. Importing XML data is covered, and the course also describes the process of using the Query Wizard to create and edit queries.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Expected Duration (hours)
1.0
Lesson Objectives
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
mo_pexl_a05_dt_enus
Back to List
Bonus Modules
Automating Excel 2010 Tasks Using Macros
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 proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
Automating Excel 2010 Tasks Using Macros
mo_aexl_a05_dt_enus
Back to List
Analyzing Data with What-if Analysis in Excel 2010
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
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
Analyzing Data with What-if Analysis in Excel 2010
mo_aexl_a06_dt_enus
Back to List
PivotTables and PivotCharts in Excel 2010
Overview/Description
One of the most powerful tools that Excel 2010 provides is a PivotTable that allows you to dynamically reorganize and display your data. PivotTables can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. PivotTables also allow you to choose and change what you want to summarize, quickly and easily. This course will introduce you to PivotTables and show you the many benefits they provide.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
PivotTables and PivotCharts in Excel 2010
mo_aexl_a07_dt_enus
Back to List
PivotTable Filters, Calculations, and PowerPivot
Overview/Description
PivotTables are a handy tool for summarizing large amounts of data efficiently and making it more manageable. Sometimes, though, its useful to be able to filter the data in a PivotTable, and Excel 2010 provides filtering functionality for this specific purpose. For those people who require a more visual representation of data, Excel 2010 provides a new feature called a Slicer, which is basically a graphical representation of a PivotTable filter. Excel also provides a number of ways in which you can apply calculations to the data in PivotTables in the form of summary functions and custom calculations. All of these useful features of Excel 2010 are introduced and described in this course.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Expected Duration (hours)
1.0
Lesson Objectives
PivotTable Filters, Calculations, and PowerPivot
mo_aexl_a08_dt_enus
Back to List
Microsoft Office Specialist: 2010 Certification
The Microsoft Office Specialist (MOS) certification identifies specific skills covering the Microsoft Office 2010
products — Microsoft Word 2010, Excel 2010, PowerPoint 2010, Access 2010, and Outlook 2010 You must pass one certification
exam to earn the MOS certification.
Benefits of CBT Direct’s Online Microsoft MOS Certification Training
CBT Direct boasts the most beneficial online certification training on the market. With online training, you have the flexibility
to study on your schedule, and with the speed and reliability of the internet, CBT Direct’s Microsoft MOS training course is
accessible anywhere you have an internet connection. Convenience finally costs less with CBT Direct – the most affordable
online training solution today. CBT Direct is also a Microsoft Certified Partner.
The unique design of CBT Direct’s Microsoft MOS certification course incorporates a proven four-step learning process: presentation, demonstration, guidance and independent practice. This four-step proven learning model for CBT Direct’s Microsoft MOS training course ensures the greatest level of retention to prepare you for your Microsoft MOS certification exam.
CBT Direct also offers online mentoring for over 100 current major certification exams, including Microsoft MOS, for IT
professionals and end-users alike. CBT Direct’s mentors have a minimum of 20 certifications each and are available 24/7*.
* Available for most courses.
Who Benefits from CBT Direct’s Microsoft MOS Training?
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Office 2010; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Office 2010; end-users seeking a basic IT certification.
What Professionals Will Learn from CBT Direct’s Microsoft MOS Training
To earn a Microsoft Office 2010 Specialist (MOS) certification you must pass one of the following certification exams.
Exam 77-881: MOS: Using Microsoft Office Word 2010
This course will cover getting started with Word 2010, working with text, paragraphs, structuring, editing, saving, and opening
documents. You will also learn how to use the printing, help, automated formatting, advanced formatting and advanced document
navigation in Word 2010. The training introduces student to tables, charts, graphics, advanced data manipulation and advanced document
features.
Click here to see a detailed curriculum outline.
Exam 77-882: MOS: Using Microsoft Office Excel 2010
This course will cover getting started with Excel 2010, manipulating, formatting data and Worksheets, reviewing and printing. The
training also teaches you Excel 2010 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data
management, advanced customization and how to analyzing data and how to protect and share Excel 2010 workbooks.
Click here to see a detailed curriculum outline.
Exam 77-883: MOS: Using Microsoft Office PowerPoint 2010
This course will cover getting started with PowerPoint 2010, how to add graphics to presentations, how to add multimedia and
animations to presentations, how to create custom slide shows and how to distribute presentations using PowerPoint 2010.
Click here to see a detailed curriculum outline.
Exam 77-884: MOS: Using Microsoft Office Outlook 2010
This course will cover getting started with Outlook 2010, formatting and managing E-mail, how to use the calendar in Outlook 2010.
The training will also teach you how to use contacts, tasks, notes, customize the interface and to complete searches, print items
and work with RSS Feeds in Outlook 2010. Students will be introduced to customizing Outlook 2010, using the Journal, configuring
rules, alerts, junk mail, working with SharePoint, calendars and Forms. Lastly, you will learn data security, archiving, working
offline, how to use instant and unified messaging, as well as, the business contact manager
in Outlook 2010.
Click here to see a detailed curriculum outline.
Exam 77-885: MOS: Using Microsoft Office Access 2010
This course covers getting started with Access 2010, basic tables, basic forms, queries, reports, importing and exporting data and
data presentation in Access 2010. The training will also teach you how to use advanced data management, programmability and
administration as well as database administration in Access 2010.
Click here to see a detailed curriculum outline.
To earn a Microsoft Office 2010 Expert (MOS) certification you must pass the following certification exam.
Exam 77-888: MOS: Using Microsoft Office Excel 2010 Expert
This course will cover advanced features of Excel 2010, manipulating, formatting data and Worksheets, reviewing and printing. The
training also teaches you Excel 2010 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data
management, advanced customization and how to analyzing data and how to protect and share Excel 2010 workbooks.
Click here to see a detailed curriculum outline.
Also includes bonus modules - not required for Excel 2010 Exam 77-882 certification.
- Automating Excel 2010 Tasks Using Macros
- Analyzing Data with What-if Analysis in Excel 2010
- PivotTables and PivotCharts in Excel 2010
- PivotTable Filters, Calculations, and PowerPivot
Exam#
Certification
Certified Mentoring
Hours
Hours
24x7
Mon-Fri
(9-5 EST)
(9-5 EST)
Tier 3
TestPrep
| 77-881 | Using Microsoft Word 2010 | ü | ü | |
| 77-882 | Using Microsoft Excel 2010 | ü | ü | |
| 77-883 | Using Microsoft PowerPoint 2010 | ü | ü | |
| 77-884 | Using Microsoft Outlook 2010 | ü | ü | |
| 77-885 | Using Microsoft Access 2010 | ü | ü |
Click to find a Certiport Test Center Near You
Click to view Microsoft MOS Certification details
Exam 77-888: MOS: Microsoft Office Excel 2010 Expert
Exam 77-881: MOS: Using Microsoft Office Word 2010
Exam 77-882: MOS: Using Microsoft Office Excel 2010
Exam 77-883: MOS: Using Microsoft Office PowerPoint 2010
Exam 77-884: MOS: Using Microsoft Office Outlook 2010
Exam 77-885: MOS: Using Microsoft Office Access 2010
Bonus Modules
