Microsoft Office 2010: New Features Curriculum Outline
Office 2010 New Core Features
Overview/Description
With the release of Microsoft Office 2010, Microsoft has focused its suite of products to meet the ever-changing needs of its end users – both corporate and individual. Using Office 2010, you can share information seamlessly with an individual in the office next door or around the world, and access information anywhere, anytime using mobile devices. Office 2010 includes new graphic and video editing and creation tools to enable you to create visually stunning presentations and documents. Office 2010 provides increased flexibility for analyzing and storing data, managing e-mail messages and contacts, and customizing the interface the way you want it. This course explores key new features and enhancements in the Office 2010 suite of products. It also introduces product-specific new features and enhancements in the 2010 releases of Word, Excel, PowerPoint, and Access. These new and enhanced features include Office Backstage, Live Preview Paste, Sparklines, Slicers, graphic and video creation and editing tools, PowerPoint Broadcast Service, screenshot capture and clipping tools, Web Apps and Office Mobile.
Target Audience
Individual and corporate end-users with a working knowledge of Office 2007s standard functionality and general computing skills
Prerequisites
None applicable
Expected Duration (hours)
1.0
Lesson Objectives
Office 2010 New Core Features
mo_otnf_a01_dt_enus
Back to List
New Messaging and Collaboration Features in Office 2010
Overview/Description
The new and enhanced collaboration features of Office 2010 enable users to work in unison to create content, regardless of their location. Enhancements to many of the Office products enable users to work more efficiently, using a combination of their local computer, a browser, a mobile phone or other Web-enabled device, and a phone integrated with Microsoft Office Communications Server. Users can also collaborate in real-time and authors can easily identify content changes by other contributors. This course explores the new features of Outlook 2010, including changes to the interface, the introduction of the People Pane and the Schedule Pane, and enhancements to Unified Messaging. The new features and enhancements of OneNote 2010, including linked notes, improved integration with other Office products, and language features are also covered. The new features and enhancements of SharePoint Workspace 2010, formerly known as Groove, are also discussed. In addition, this course examines new Office 2010 collaboration features, including co-authoring, real-time communication, and unified messaging.
Target Audience
Individual and corporate end-users with a working knowledge of Office 2007s standard functionality and general computing skills
Prerequisites
None applicable
Expected Duration (hours)
1.0
Lesson Objectives
New Messaging and Collaboration Features in Office 2010
mo_otnf_a02_dt_enus
Back to List
Office 2010 Web Apps and New Features in Publisher and Mobile
Overview/Description
Office 2010 enables you to access your files from anywhere using a phone, or a Web-enabled computer or device. Office Web Apps and Office Mobile are two of the features that help to provide this access. Office Web Apps are online extensions of Word, PowerPoint, Excel, and OneNote that allow you to view and edit files stored in Windows Live SkyDrive, on your organizations SharePoint implementation, or on SharePoint Online. The Office Web Apps can also be used to create documents, presentations, workbooks, and notebooks within a browser. Office Mobile allows you to use your phone to access several of the Office applications, and allows you to access and edit documents, presentations, and workbooks. Office Mobile also provides additional support for common mobile phone features, such as touching and flicking. Publisher 2010 allows you to create high-quality publication materials, such as brochures and newsletters. This course introduces the new Web Apps for Word, PowerPoint, Excel, and OneNote. It also explores the new features and enhancements to the Office Mobile products, such as enhanced editing, increased font support, PowerPoint’s new Presentation Companion, and Outlook conversations, as well as the introduction of SharePoint Mobile. In addition, this course covers the new features and enhancements in the interface and workspace, image editing, text formatting, printing, and sharing in Publisher 2010.
Target Audience
Individual and corporate end-users with a working knowledge of Office 2007s standard functionality and general computing skills
Prerequisites
None applicable
Expected Duration (hours)
1.0
Lesson Objectives
Office 2010 Web Apps and New Features in Publisher and Mobile
mo_otnf_a03_dt_enus
Back to List
Microsoft Office 2010 New Features for Users Migrating from Office 2003 Curriculum Outline
The New Office 2010 Interface, Word 2010, and Excel 2010
Overview/Description
Within the two Microsoft Office Suite releases available since Office 2003, Microsoft has implemented a number of functionality and interface changes and introduced several new features. The overall Office interface has been changed substantially with the introduction of the Ribbon in Microsoft Office 2007, and collaboration and anywhere access to Office files is a major theme in the Microsoft Office 2010 release. This course examines the new features and enhancements of Microsoft Office 2010, focusing on the perspective of Microsoft Office 2003 users who are migrating to Microsoft Office 2010. It outlines the significant interface changes that apply to all Office applications, including the Ribbon and the Office Backstage view, and it covers significant new features and enhancements in Word and Excel 2010. These features include Live Preview Paste, Open file format, and the Protected view available for Office 2010 documents, and features such as enhanced graphics support, Quick Styles and document comparison tools in Word, Sparklines, Slicers, and Pivot Table enhancements in Excel. The course also introduces the new web versions of Word and Excel - Word Web App and Excel Web App.
Target Audience
Individual and corporate end-users with a working knowledge of Office 2003s standard functionality and general computing skills
Prerequisites
None applicable
Expected Duration (hours)
1.0
Lesson Objectives
The New Office 2010 Interface, Word 2010, and Excel 2010
mo_nfum_a01_dt_enus
Back to List
Outlook 2010 and Collaboration in Office 2010
Overview/Description
The new and enhanced collaboration features of Office 2010 enable users to work in unison to create content, regardless of their location. Enhancements to many of the Office products enable users to work more efficiently, using a combination of their local computer, a browser, a mobile phone or other Web-enabled device, and a phone integrated with Microsoft Office Communications Server. This course explores the new features of Outlook 2010, including changes to the interface, the introduction of the Conversation view and QuickSteps, as well as Outlook Social Connector. It also explores new features and enhancements to OneNote 2010, including linked notes, improved integration with other Office products, and enhanced collaboration features. The new features and enhancements of SharePoint Workspace 2010, formerly known as Groove, are also discussed. The course also introduces Office Web Apps, which are online extensions of Word, PowerPoint, Excel, and OneNote that allow you to view and edit files stored in Windows Live SkyDrive, on your organization’s SharePoint implementation, or on SharePoint Online. The Office Web Apps can also be used to create documents, presentations, workbooks, and notebooks within a browser. Finally the course introduces Office Mobile, which allows you to use your phone to access several of the Office applications, and to access and edit documents, presentations, and workbooks.
Target Audience
Individual and corporate end-users with a working knowledge of Office 2003s standard functionality and general computing skills
Prerequisites
None applicable
Expected Duration (hours)
1.0
Lesson Objectives
Outlook 2010 and Collaboration in Office 2010
mo_nfum_a02_dt_enus
Back to List
New Features for PowerPoint, Publisher, and Access in Office 2010
Overview/Description
Since the release of the Microsoft Office 2003 suite of products, PowerPoint, Publisher, and Access have all undergone significant changes – both to the interface and the range of available features. The Fluent User Interface (UI), now available in all products in Office 2010, gives a consistent look and feel across applications. PowerPoint 2010 aims to make presentation creation more efficient and presentations themselves more visually impressive. Publisher has undergone similar changes, enhancing the creation of high-quality publications. Access 2010 simplifies database creation, makes data accessible from any location, and provides enhanced navigation controls for accessing data. This course covers the new features of PowerPoint 2010, Publisher 2010, and Access 2010 including changes to the interface and key functional improvements and enhancements.
Target Audience
Individual and corporate end-users with a working knowledge of Office 2003s standard functionality and general computing skills
Prerequisites
None applicable
Expected Duration (hours)
1.0
Lesson Objectives
New Features for PowerPoint, Publisher, and Access in Office 2010
mo_nfum_a03_dt_enus
Back to List
Microsoft Office 2010: Beginning Word 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
Microsoft SharePoint 2010: New Features for End Users Curriculum Outline
SharePoint 2010 New Features for End Users
Overview/Description
Microsoft SharePoint Server 2010 contains a number of new features and enhancements specifically geared at improving the end user experience. These include enhanced remote file-editing capabilities using Web Apps and mobile devices, improvements to team sites, and enhancements in social computing. This course explores the SharePoint Server 2010 interface, including the introduction of the Ribbon, already available in Office, as well as changes to team sites and common interface elements. In addition, this course examines enhancements in social computing via My Sites, expertise sharing, tagging, and notes. Collaboration using the Office Web Apps, mobile devices, SharePoint Workspace, and enterprise wikis, as well as improvements to the calendar, are also covered.
Target Audience
End users with SharePoint 2007 experience
Expected Duration (hours)
1.0
Lesson Objectives
SharePoint 2010 New Features for End Users
mo_nspe_a01_dt_enus
Back to List
Microsoft SharePoint 2010 for End Users Curriculum Outline
Getting Started with SharePoint 2010
Overview/Description
SharePoint 2010 makes it easier for people to collaborate. You can use SharePoints intuitive design to share, check in/check out, and manage your files in structural components known as lists and document libraries. You can also use SharePoints dynamic search feature to locate files. This course explores the SharePoint interface, how to navigate and search on a SharePoint site, and how to work with lists and document libraries.
Target Audience
End users with basic computer literacy, familiarity with the Office suite, and experience using SharePoint
Expected Duration (hours)
1.0
Lesson Objectives
Getting Started with SharePoint 2010
mo_ospe_a01_dt_enus
Back to List
Using SharePoint 2010 with Office 2010
Overview/Description
SharePoint 2010 offers a wide variety of exciting Office integration, file synchronization, collaboration, and social computing features. This course explores the ways in which Office 2010 and SharePoint are integrated with one another. It also explores working with Office Web Apps so you can view and edit Office files in a browser window. In addition, SharePoint Workspace 2010, part of the Office 2010 suite, enables you to create workspaces that allow you to store offline copies of entire SharePoint sites and sync them with the main SharePoint site. This course explores all of these features, and also discusses collaboration and social computing aspects of SharePoint 2010 including My Site and wikis.
Target Audience
End users with basic computer literacy, familiarity with the Office suite, and SharePoint experience
Expected Duration (hours)
1.0
Lesson Objectives
Using SharePoint 2010 with Office 2010
mo_ospe_a02_dt_enus
Back to List
Microsoft SharePoint 2010: New Features for Power User Curriculum Outline
Microsoft SharePoint 2010: New Features for Power Users
Overview/Description
SharePoint Server 2010 offers a number of new features and enhancements that help to ease the day-to-day tasks of power users. There are a number of changes to the SharePoint 2010 interface, as well as changes and enhancements in the method and location of accessing specific options. This course explores the enhanced SharePoint 2010 UI, the Getting Started area of home pages, and the changed Site Actions menu. It also discusses the new site creation templates, changes to workflows, enhancements to record and content management, web content management, and the new document sets. Managing site settings is also covered.
Target Audience
Users with proficiency in SharePoint and basic computing skills
Expected Duration (hours)
1.0
Lesson Objectives
Microsoft SharePoint 2010: New Features for Power Users
mo_nspp_a01_dt_enus
Back to List
Microsoft SharePoint 2010 for Power Users Curriculum Outline
Managing SharePoint 2010 Sites, Lists, and Libraries
Overview/Description
Microsoft SharePoint 2010 offers a complete platform for collaboration, data management, and online information publishing. SharePoint sites provide the basis for these tasks, and are broken down further into objects like lists and libraries. Creating, managing, and customizing these sites, lists, and libraries are common tasks and responsibilities for SharePoint power users. This course examines the various types of SharePoint sites, as well as creating sites and subsites, changing site details, and using the recycle bin. In addition, this course explores the various types of SharePoint lists, and covers creating custom lists, customizing existing lists, and managing list properties. SharePoint library types, creating document libraries, and managing and customizing library settings are also covered.
Target Audience
Users with proficiency in SharePoint and basic computing skills
Expected Duration (hours)
1.0
Lesson Objectives
Managing SharePoint 2010 Sites, Lists, and Libraries
mo_ospp_a01_dt_enus
Back to List
Managing SharePoint 2010 Pages and Components
Overview/Description
To enhance your SharePoint implementation beyond the default home page, you can use the available publishing pages and web part pages. SharePoint 2010 also offers a new page type, referred to simply as a page. Organizations store and organize documents on SharePoint in a number of ways, and the management of this document storage is a common power user task. Workflows enable you to streamline the execution of existing business processes using SharePoint, and Web Parts provide additional functionality in how to display SharePoint information. This course examines the creation and customization of publishing pages, web part pages, and pages. In addition, this course explores the challenges of document management, and the role that SharePoint plays in this process. It also covers managing documents using document IDs, ratings, notes, tagging, document sets, and document retention, and provides document management tips. Managing and customizing workflows and accessing site usage reports are also covered.
Target Audience
Users with proficiency in SharePoint and basic computing skills
Expected Duration (hours)
1.0
Lesson Objectives
Managing SharePoint 2010 Pages and Components
mo_ospp_a02_dt_enus
Back to List
SharePoint 2010 Security and Business Intelligence
Overview/Description
Microsoft SharePoint 2010 provides several security options for ensuring that only users or groups who should be able to access specific contents can do so. Security can be configured at the item level, and can be managed for individual users or groups. This course examines SharePoint securing, and describes managing SharePoint groups, changing the inheritance for a site, managing permission levels, and configuring item-level security. It also discusses the concept of sandbox solutions. SharePoint Business Intelligence solutions allow you to collect, store, and analyze business data to help in making business decisions and streamlining business processes. SharePoint dashboard and reporting features give users on-demand access to important business data. This course also covers the use of SharePoint dashboard and reporting features. Additional business intelligence features, such as Excel Services, Access Services, Visio Services, PerformancePoint Services, and the PowerPivot for Excel add-in are also discussed.
Target Audience
Users with proficiency in SharePoint and basic computing skills
Expected Duration (hours)
1.0
Lesson Objectives
SharePoint 2010 Security and Business Intelligence
mo_ospp_a03_dt_enus
Back to List
Microsoft Office 2010: Beginning Excel 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 2010 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 2010 Workbooks
mo_bexl_a11_dt_enus
Back to List
Microsoft Office 2010: Beginning Outlook 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
Prerequisites
ll
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
Microsoft Office 2010: Advanced Word Curriculum Outline
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
Microsoft Office 2010: Advanced Excel Curriculum Outline
Microsoft Office 2010: Advanced Outlook Curriculum Outline
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 Files and Folders and Using Search and RSS Feeds in 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 Files and Folders and Using Search and RSS Feeds in Outlook 2010
mo_aout_a04_dt_enus
Back to List
Data Files, Archiving, and Send/Receive Groups in Outlook 2010
Overview/Description
Items created in Outlook 2010 are stored in data files on your computer. Proper management of these files is important in organizing Outlook items and managing space on your hard drive. This course discusses PST and OST files and how they can help you while working with Outlook 2010. Archiving data also plays an important role in Outlook 2010, and this courses covers how to manage AutoArchive settings and how to manually archive items. Also discussed in this course is the creation and management of Send/Receive groups, which enable you to control how often Outlook folders are updated.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Data Files, Archiving, and Send/Receive Groups in Outlook 2010
mo_aout_a05_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
Accessing Exchange Remotely and Using Forms in Outlook 2010
Overview/Description
Whether it is to stay in touch with friends and family or to message colleagues from the office, people depend on e-mail communication more than ever before. When away from the office, Outlook 2010 offers two options for people to access their Exchange e-mail accounts – Outlook Web App and Outlook Anywhere. This course discusses how to access and sign on to Outlook Web App using a web browser and how to configure Outlook 2010 with Outlook Anywhere so that users can send and receive messages. This course also covers the role that forms play in Outlook 2010 and how forms can be customized to meet your needs.
Target Audience
A broad range of business users
Expected Duration (hours)
1.0
Lesson Objectives
Accessing Exchange Remotely and Using Forms in Outlook 2010
mo_aout_a07_dt_enus
Back to List
Microsoft Office 2010: Beginning PowerPoint 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
Microsoft Office 2010: Advanced PowerPoint Curriculum Outline
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
Microsoft Office 2010: Beginning Access 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
Microsoft Office 2010: Beginning Project Curriculum Outline
Introduction to Project Management using Project 2010
Overview/Description
The role of Project Manager is an important position in virtually any organization. The move from traditional project management to using project management software can help any project manager become more efficient and successful. This course provides an overview of project management fundamentals, including the stages of a project lifecycle, the basic project management processes, and how Microsoft Project 2010 project management software benefits both the manager and the project itself.
Target Audience
Individuals involved in managing projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Introduction to Project Management using Project 2010
mo_bprj_a01_dt_enus
Back to List
Introduction to Project 2010
Overview/Description
Microsoft Project 2010 includes a variety of straightforward and easily accessible features to simplify the process of managing projects, all located and organized within the Project 2010 layout. This course provides an overview of the Project 2010 interface, including the Ribbon feature, Project 2010 Backstage, and how to navigate within the Microsoft Project 2010 application.
Target Audience
Individuals involved in managing projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Introduction to Project 2010
mo_bprj_a02_dt_enus
Back to List
Initializing a Project with Project 2010
Overview/Description
Before your project can get going, you need to have tools in place that will allow you to control tasks and organize the resources youll use to complete your project. This course covers the steps for setting up a new project from a template, from an existing project, or from SharePoint Task Lists. The course also covers project calendars, including how to edit working days and create exceptions.
Target Audience
Individuals involved in managing projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Initializing a Project with Project 2010
mo_bprj_a03_dt_enus
Back to List
Defining Project Properties in Project 2010
Overview/Description
Your project file is probably the most important tool you will use to manage your project throughout its entire project lifecycle. In order to be effective though, its important you understand how the file works, and how vital project information is for keeping the file relevant to your specific project. This course covers the six steps for defining a new projects properties, including setting your project start date, the project working schedule, and options unique to your particular project.
Target Audience
Individuals involved in managing projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Defining Project Properties in Project 2010
mo_bprj_a04_dt_enus
Back to List
Building a Schedule with Project 2010
Overview/Description
A project is made up of tasks, and the job of a project manager essentially boils down to one thing: making sure tasks are properly defined, organized, planned, and carried out. Good scheduling leads to timely completion of the project, and that relies on the ability to order and link tasks, and set appropriate durations and constraints. This course covers the steps for entering and editing tasks within Microsoft Project 2010, setting milestones, organizing tasks into phases, and identifying task dependencies. The course also introduces methods for applying constraints and deadlines to your project tasks to keep them on schedule.
Target Audience
Individuals involved in managing projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Building a Schedule with Project 2010
mo_bprj_a05_dt_enus
Back to List
Creating Resources in Project 2010
Overview/Description
The people who do the work, the materials and equipment you require to perform the work, and the money you need to fund the work are all vital project resources. As a project manager, you should understand how to work with resource information in Project 2010 so you can efficiently plan and manage your resources. This course covers entering and configuring resource information, including people, generic resources, materials, and cost resources. This course also covers how to sort and organize items in a resource sheet.
Target Audience
Individuals involved in managing projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Creating Resources in Project 2010
mo_bprj_a06_dt_enus
Back to List
Managing Resource Assignments with Project 2010
Overview/Description
Good project management requires the ability to organize resources based on their availability, cost and consumption rates, and how many are required to complete each task. This course lays a foundation for understanding effort-driven scheduling and how Project 2010 uses resource assignment information to perform scheduling calculations. It also covers how to assign various types of resources to tasks in your project, and how to modify cost rate tables for your resources in order to accurately capture and report project costs.
Target Audience
Individuals involved in managing projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Managing Resource Assignments with Project 2010
mo_bprj_a07_dt_enus
Back to List
Monitoring Schedule Performance with Project 2010
Overview/Description
Once project planning is complete, the actual project work begins. Your job as a project manager is to diligently track the progress of this work so that if schedule slippage occurs, you can make adjustments and manage the remaining work effectively. This course covers setting and maintaining project baselines, which are used to compare the planned work with actual work. This course also covers the procedure for updating project progress at the task level in order to track variance, as well as rescheduling incomplete work when an unanticipated work interruption occurs.
Target Audience
Individuals involved in managing projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Monitoring Schedule Performance with Project 2010
mo_bprj_a08_dt_enus
Back to List
Communicating Project Information with Project 2010
Overview/Description
Its been said that communication is the single most important factor in the success or failure of a project. And its 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 projects who have basic computer literacy
Expected Duration (hours)
1.0
Lesson Objectives
Communicating Project Information with Project 2010
mo_bprj_a09_dt_enus
Back to List
Microsoft Office 2010: Advanced Access Curriculum Outline
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
Microsoft Office 2010: Power User Excel 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
Microsoft Office 2010: Advanced Project Curriculum Outline
Advanced Customizing with Project 2010
Overview/Description
A well set up project file is essential to the success of a project. The advanced project file customizations available in Project 2010 can simplify many project management tasks, saving you time, and increasing the effectiveness of project analysis and reporting tools throughout the life of your project. This course covers how to customize default options, add new tabs and groups to the Ribbon, and add new buttons to the Quick Access Toolbar. You will also learn how to import or export a customized Ribbon and Quick Access Toolbar so that project team members can share and enjoy consistent user interface customizations. This course also covers how to create custom fields that contain specially formatted task and resource data, such as formulas, graphical indicators, and outline codes that meet the unique needs of your project.
Target Audience
Individuals familiar with basic project concepts who wish to use Microsoft Project 2010 at an advanced level
Expected Duration (hours)
1.0
Lesson Objectives
Advanced Customizing with Project 2010
mo_aprj_a01_dt_enus
Back to List
Advanced Tools for Managing Multiple Projects with Project 2010
Overview/Description
Most project managers in todays workplace are required to juggle many projects at the same time. The ability to efficiently monitor and adjust resources and task assignments is critical for the successful management of multiple projects. This course covers tools for managing multiple, related project files so that you can see the big picture relationships between your projects. Consolidating resources and task assignments allows you to prevent over-allocation or under-allocation, view cumulative resource costs across multiple projects, and integrate schedules so that dependent tasks across projects flow smoothly. This course covers the process for creating a master project that consolidates related projects into single project file, how to create and update a resource pool, and how to create a cross-project dependencies between tasks.
Target Audience
Individuals familiar with basic project concepts who wish to use Microsoft Project 2010 at an advanced level
Expected Duration (hours)
1.0
Lesson Objectives
Advanced Tools for Managing Multiple Projects with Project 2010
mo_aprj_a02_dt_enus
Back to List
Advanced Resource Management with Project 2010
Overview/Description
An important ingredient in managing projects is the ability to easily identify potential resource issues and the impact they could have on the overall project schedule. This course covers advanced resource and scheduling adjustments, such as how to delay task start dates and apply predetermined work contours to manage assignments. You will also become familiar with Team Planner, a graphical view that allows you to view and adjust work assignments with drag-and-drop action. This course also includes several methods for leveling resources and correcting overallocation issues, including Projects built-in resource leveling tool.
Target Audience
Individuals familiar with basic project concepts who wish to use Microsoft Project 2010 at an advanced level
Expected Duration (hours)
1.0
Lesson Objectives
Advanced Resource Management with Project 2010
mo_aprj_a03_dt_enus
Back to List
Advanced Scheduling Management with Project 2010
Overview/Description
Ongoing inspection and adjustment of the project plan is vital to address impacts to the project schedule and address scope and budget changes. This course covers how to easily identify warnings, solutions, and drivers for tasks using Task Inspector, how to address repetitive tasks by creating a recurring task, and how to inactivate tasks that are no longer necessary to the project. This course also covers ways to inspect a project plan by grouping, filtering, and displaying the critical path.
Target Audience
Individuals familiar with basic project concepts who wish to use Microsoft Project 2010 at an advanced level
Expected Duration (hours)
1.0
Lesson Objectives
Advanced Scheduling Management with Project 2010
mo_aprj_a04_dt_enus
Back to List
Advanced Reporting and Management Tools in Project 2010
Overview/Description
Project 2010 comes with many enhanced features and tools that help project managers report on project status and carry out project management tasks with ease and efficiency. This course covers several of the advanced tools you will use to communicate project status and streamline your tasks, such as the visual reports, enhanced copy and paste, and the Compare Projects feature, which allows you to compare project files and produce an informative comparison report. This course also covers the procedure for recording macros, which will allow you to save time on repetitive tasks.
Target Audience
Individuals familiar with basic project concepts who wish to use Microsoft Project 2010 at an advanced level
Expected Duration (hours)
1.0
Lesson Objectives
Advanced Reporting and Management Tools in Project 2010
mo_aprj_a05_dt_enus
Back to List
Microsoft Office 2010: Beginning Visio Curriculum Outline
Getting Started with Visio 2010
Overview/Description
Microsoft Visio 2010 is a powerful diagramming program that provides users with a diverse set of pre-drawn stencils, shapes, sample drawings and templates for illustrating complex ideas visually. In this course the various features of the Visio interface will be explored. You will also be shown how to access and use templates, shapes and stencils for creating contemporary looking diagrams. Once the diagrams have been created, this course will also demonstrate how to manipulate, align and connect shapes to achieve professional looking results.
Target Audience
Individuals and business users with basic computer literacy seeking proficiency in the use of Microsoft Visio 2010
Expected Duration (hours)
1.0
Lesson Objectives
Getting Started with Visio 2010
mo_bvis_a01_dt_enus
Back to List
Working with Diagrams in Visio 2010
Overview/Description
Visio 2010 provides a wide range of formatting and design options for creating vibrant diagrams using pre-drawn shapes and themes. Whether it’s an organizational chart, a floor plan or a network diagram Visio 2010 comes equipped with such tools. This course explores these features and demonstrates how to add apply and manipulate text, work with themes and backgrounds and how to design and format decorative elements of a diagram page.
Target Audience
Individuals and business users with basic computer literacy seeking proficiency in the use of Microsoft Visio 2010
Expected Duration (hours)
1.0
Lesson Objectives
Working with Diagrams in Visio 2010
mo_bvis_a02_dt_enus
Back to List
Collaboration, Evaluation and Printing in Visio 2010
Overview/Description
Visio 2010 is a powerful collaboration tool that allows the user to review and share Visio diagrams, link content from other Microsoft applications, and save and send directly from inside Visio 2010. This course will show how to review, markup and make comments on a diagram. Also covered are how to embed shapes and graphics from Microsoft applications and finally how to preview, print and save Visio in different file formats.
Target Audience
Individuals and business users with basic computer literacy seeking proficiency in the use of Microsoft Visio 2010
Expected Duration (hours)
1.0
Lesson Objectives
Collaboration, Evaluation and Printing in Visio 2010
mo_bvis_a03_dt_enus
Back to List
Microsoft OneNote 2010 for End Users Curriculum Outline
Microsoft Office 2010: Managing Information with OneNote
Overview/Description
Microsoft OneNote 2010 is a digital notebook application that lets you manage information quickly and efficiently much like a paper notebook you would use to take meeting or class notes. This application lets you type, paste, print, add web clips, audio, video, add handwritten notes to a notebook and to send content from other applications. You have a number of options for expanding notebooks. You can move things around on every page and a notebook can store an infinite amount of data, dependent only on the limitations of the storage location. This course explores the basics of OneNote 2010 including an introduction to the interface, ways of formatting your notebooks text, methods of adding links, images, and tags to a note, and organizing content into sections and pages.
Target Audience
A broad range of business users with basic computer proficiency including the fundamentals of word processing, e-mail, and presentation systems.
Expected Duration (hours)
1.0
Lesson Objectives
Microsoft Office 2010: Managing Information with OneNote
mo_onel_a01_dt_enus
Back to List
Microsoft Office 2010: Sharing Information with OneNote
Overview/Description
OneNote 2010 allows you to share your notes, by e-mail, SharePoint, SkyDrive, or by blogging them. You can collaborate on a shared notebook in a live session in which co-workers can edit and add to notes at the same time. This course explores OneNotes integration with other Office applications such as Outlook, Word and PowerPoint, and covers remote access, sharing, and privacy settings.
Target Audience
A broad range of business users with basic computer proficiency including the fundamentals of word processing, e-mail, and presentation systems.
Expected Duration (hours)
1.0
Lesson Objectives
Microsoft Office 2010: Sharing Information with OneNote
mo_onel_a02_dt_enus
Back to List
Microsoft Office 2010: Lync for End Users Curriculum Outline
Microsoft Office 2010: Getting Started with Lync
Overview/Description
Lync 2010 offers a full unified communications platform ideal for use in a business environment. Using Lync 2010 features such as instant messaging, audio and video-enabled meetings, Group Chat, Skill Search, activity feeds, enterprise voice, and Lync Attendant allows seamless and efficient communication among local and remote users. This course introduces Lync 2010 and the host of available features. It describes how to sign in to and out of Lync 2010 and customize your personal preferences. In addition, this course explains the concept of presence, and the various presence options that are available. Adding and organizing contacts, and viewing contact information, as well as instant messaging single or multiple users, and other IM-related options are also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Lync 2010
Expected Duration (hours)
1.0
Lesson Objectives
Microsoft Office 2010: Getting Started with Lync
mo_lync_a01_dt_enus
Back to List
Microsoft Office 2010: Managing Information with OneNote
Overview/Description
Microsoft OneNote 2010 is a digital notebook application that lets you manage information quickly and efficiently much like a paper notebook you would use to take meeting or class notes. This application lets you type, paste, print, add web clips, audio, video, add handwritten notes to a notebook and to send content from other applications. You have a number of options for expanding notebooks. You can move things around on every page and a notebook can store an infinite amount of data, dependent only on the limitations of the storage location. This course explores the basics of OneNote 2010 including an introduction to the interface, ways of formatting your notebooks text, methods of adding links, images, and tags to a note, and organizing content into sections and pages.
Target Audience
A broad range of business users with basic computer proficiency including the fundamentals of word processing, e-mail, and presentation systems.
Expected Duration (hours)
1.0
Lesson Objectives
Microsoft Office 2010: Managing Information with OneNote
mo_onel_a01_dt_enus
Back to List
Microsoft Office 2010
Microsoft Office 2010 training will help you learn desktop skills in Microsoft Office 2010 productivity programs such as;
Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint, Microsoft Access, Microsoft Publisher, Microsoft
Visio and Microsoft Project.
CBT Direct's Microsoft Office 2010 training provides computer literacy, measures your proficiency, and identifies any opportunity to enhancement your skills. Being able to use Microsoft Office 2010 efficiently will help set you apart from your peers in a very competitive job market.
Benefits of CBT Direct’s Online Microsoft Office Training
CBT Direct boasts the most beneficial online training on the market. With CBT Direct’s online training, you have the
flexibility to study on your schedule, and with the speed and reliability of the internet, CBT Direct’s Microsoft Office
training course is accessible anywhere you have an internet connection. Convenience finally costs less with CBT Direct -
the most affordable online training solution today.
The unique design of CBT Direct’s Microsoft Office training 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 Office training course ensures the greatest level of comprehension and retention. CBT Direct is also a Microsoft Certified Partner.
Who Benefits from CBT Direct’s Microsoft Office Training?
Anyone interested in the knowledge of basic word processing and computing and wants familiarity with the Microsoft Office programs.
What Professionals Will Learn from CBT Direct’s Microsoft Office Training
Microsoft Office 2010: New Features
This course covers key new features and enhancements in the Office 2010 suite of products. This course explores
product-specific new features and enhancements in the 2010 releases of Word, Excel, PowerPoint, Outlook, and Access.
Click here to see a detailed curriculum outline.
Microsoft Office 2010: New Features for Users Migrating from Office 2003
This course examines the new features and enhancements of Microsoft Office 2010, focusing on the perspective of Microsoft
Office 2003 users who are migrating to Microsoft Office 2010.
Click here to see a detailed curriculum outline.
Microsoft 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.
Microsoft 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.
Microsoft OneNote 2010
This course will cover getting started with OneNote 2010 including an introduction to the interface, ways of
formatting your notebook's text, methods of adding links, images, and tags to a note, and organizing content
into sections and pages.
Click here to see a detailed curriculum outline.
Microsoft 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.
Microsoft 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.
Microsoft Project 2010
This course covers creating, designing, specifying and assigning resources in Project 2010. You will also learn how to
use tracking, reporting, advanced customization, project data management and performance for Project 2010.
Click here to see a detailed curriculum outline.
Microsoft SharePoint Server 2010
This course covers SharePoint 2010 essentials, creating, and managing personal sites and searches in SharePoint 2010.
Click here to see a detailed curriculum outline.
Microsoft Visio 2010
This course covers creating Visio diagrams, enhancing and customizing diagrams in Visio 2010. You will also learn how
collaborate and use Visio 2010 with other programs.
Click here to see a detailed curriculum outline.
Microsoft 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.
Microsoft Office 2010: New Features
Microsoft Office 2010 New Features for Users Migrating from Office 2003
Microsoft Office 2010: Beginning Word
Microsoft SharePoint 2010: New Features for End Users
Microsoft SharePoint 2010 for End Users
Microsoft SharePoint 2010: New Features for Power User
Microsoft SharePoint 2010 for Power Users
Microsoft Office 2010: Beginning Excel
Microsoft Office 2010: Beginning Outlook
Microsoft Office 2010: Advanced Word
Microsoft Office 2010: Advanced Excel
Microsoft Office 2010: Advanced Outlook
Microsoft Office 2010: Beginning PowerPoint
Microsoft Office 2010: Advanced PowerPoint
Microsoft Office 2010: Beginning Access
Microsoft Office 2010: Beginning Project
Microsoft Office 2010: Advanced Access
Microsoft Office 2010: Power User Excel
Microsoft Office 2010: Advanced Project
Microsoft Office 2010: Beginning Visio
Microsoft OneNote 2010 for End Users
Microsoft Office 2010: Lync for End Users
