Office 2010 - Online Course

Microsoft Office 2010 improves on Office 2007 to make your working day even more efficient and effective. New image-editing tools help you design documents that stand out from the crowd. New social networking tools help you connect with colleagues. You can post documents to the Internet, and then view or edit those documents through a Web browser or mobile phone. You can embed and edit videos within slide presentations, and turn slide presentations into videos themselves. You can track trends in spreadsheet data with new filtering and visualization tools.

This online course contains 7 lessons and should take approximately 21 hours to complete.

Lesson 1: Common Features (3.0) hours

Common Features teaches you how to modify and minimize the Ribbon, use Backstage view, capture windows and clippings, add artistic and color effects to images, save documents to the Web, and work with Office Web Apps. This course explores the new features that the major Office 2010 applications have in common. Topics include Modifying the Ribbon, Working with Backstage View, Capturing Windows and Clippings, Removing Image Backgrounds, Adding Artistic and Color Effects, Checking Document Accessibility, Saving Documents to the Web, Working with SkyDrive, and Using Office Web Apps.

Lesson 2: Word (3.0) hours

Word teaches you how to describe new Ribbon features, use the Navigation Pane, take advantage of enhanced Find features, translate foreign text, implement OpenType features, and create Text Effects. This course explores the features of Microsoft Word 2010. Topics include Reviewing the Ribbon Tabs in Word, Using the Navigation Pane, Finding and Replacing Text, Translating Text, Implementing OpenType Typography, and Creating Text Effects.

Lesson 3: Excel (2.0) hours

Excel teaches you how to describe the new Ribbon features, show data trends with sparklines, use the slicer with PivotTables, and build equations. This course explores the features of Microsoft Excel 2010. Topics include Reviewing the Ribbon Tabs in Excel, Showing Data Trends with Sparklines, Using the Slicer, and Building Equations.

Lesson 4: PowerPoint (4.0) hours

PowerPoint teaches you how to describe the new Ribbon features, embed and edit audio and video, divide slide shows into sections, add animations and transitions, record a presentation as a video, and broadcast a slide show. This course explores the features of Microsoft PowerPoint 2010. Topics include Reviewing the Ribbon Tabs in PowerPoint, Dividing Slide Shows into Sections, Adding Slide Transitions, Adding Slide Animations, Using Advanced Animation Features, Embedding and Editing Audio, Embedding and Editing Video, Saving a Presentation as a Video, and Broadcasting a Slide Show.

Lesson 5: Outlook (2.0) hours

Outlook teaches you how to describe the new Ribbon features, work with conversations, implement Quick Steps, use the People pane, and schedule meetings. This course explores the features of Microsoft Outlook 2010. Topics include Reviewing the Ribbon Tabs in Outlook, Working with Conversations, Implementing Quick Steps, Using the People Pane, and Scheduling Meetings.

Lesson 6: Access (3.0) hours

Access teaches you how to describe the new Ribbon features, visualize trends with data bars, create application parts and data type parts, use calculated fields, build data macros, and insert Web content and create Web databases. This course explores the features of Microsoft Access 2010. Topics include Reviewing the Ribbon Tabs in Access, Visualizing Trends with Data Bars, Building Application Parts, Creating Data Type Parts, Using Calculated Fields, Building Data Macros, Inserting Dynamic Web Content, and Creating Web Databases.

Lesson 7: SharePoint (4.0) hours

SharePoint teaches you how to create SharePoint sites, create SharePoint pages that contain text, images, and Web Parts, create document and picture libraries, create lists and modify views, change site settings, and define a user profile for social networking. This course explores the features of Microsoft SharePoint 2010. Topics include Creating SharePoint Sites, Creating Pages, Changing Page Layouts and Text Styles, Inserting Images and Web Parts, Creating Document Libraries, Creating Picture Libraries, Creating Lists and Modifying Views, Changing Site Settings, and Creating User Profiles.