Microsoft Office 2010: New Features

Microsoft Office 2010: New Features

What you'll learn

Get an overview of the latest Microsoft Office 2010

Learn about the interface of Microsoft Office 2010

Learn the new features and work with Microsoft Word 2010

Transition to Microsoft Excel 2010

Learn to use the Microsoft PowerPoint 2010

Get the tasks done more efficiently in Microsoft Outlook 2010

Develop familiarity with Microsoft Access 2010

Requirements

The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or any older version.

The students are assumed to have operational knowledge of MS Word, Excel, PowerPoint and Outlook.

In addition to that, a good knowledge of getting around with Microsoft Windows 7/Windows 10 is required as well.

Description

The Microsoft Office 2010: New Features course builds upon the candidates’ existing Microsoft Office 2007 knowledge and skills by focusing on the new and enhanced features in Microsoft Office 2010. The course enables the candidates to manage, organize, present, and distribute their organization’s data and information in a much more organized and secure way. The course explores a variety of enhancements in Microsoft Word 2010, Microsoft Excel 2010, Microsoft PowerPoint 2010 and Microsoft Outlook 2010. This course helps bridge the gap from the previous versions to this latest release of Microsoft’s flagship office productivity suite.Microsoft Office is a suite of applications, critical to the day to day operations of any organization. This course is specifically focused on the common applications from the Microsoft Office suite that are used by almost every organization. The course is essential to allow smooth transition from the older Microsoft Office versions to the latest Microsoft Office 2010.

The Microsoft Office 2010: New Features course builds upon the candidates’ existing Microsoft Office 2007 knowledge and skills by focusing on the new and enhanced features in Microsoft Office 2010. The course enables the candidates to manage, organize, present, and distribute their organization’s data and information in a much more organized and secure way. The course explores a variety of enhancements in Microsoft Word 2010, Microsoft Excel 2010, Microsoft PowerPoint 2010 and Microsoft Outlook 2010. This course helps bridge the gap from the previous versions to this latest release of Microsoft’s flagship office productivity suite.Microsoft Office is a suite of applications, critical to the day to day operations of any organization. This course is specifically focused on the common applications from the Microsoft Office suite that are used by almost every organization. The course is essential to allow smooth transition from the older Microsoft Office versions to the latest Microsoft Office 2010.

Overview

Section 1: Course Introduction

Lecture 1 Course Introduction

Lecture 2 Instructor Intruduction

Section 2: Module 01 - The Office 2010 Interface

Lecture 3 The Office 2010 Interface

Lecture 4 Topic A: Office Interface Elements

Lecture 5 The Excel Ribbon (Home Tab)

Lecture 6 The Cell Styles Gallery in Excel

Lecture 7 Demo - A-1: Using the Ribbon

Lecture 8 Live Preview

Lecture 9 Demo - A-2: Using Live Preview

Lecture 10 Dialog Box Launcher

Lecture 11 Demo - A-3: Using the Dialog Box Launcher

Lecture 12 Quick Access Toolbar

Lecture 13 Quick Access Toolbar (Cont.)

Lecture 14 Demo - A-4: Adding a Command to the Quick Access Toolbar

Lecture 15 Status-bar View Buttons in Excel

Lecture 16 Zoom Buttons and Slider Bar

Lecture 17 Demo - A-5: Using the Status Bar

Lecture 18 Topic B: New Ribbon Features

Lecture 19 Minimize the Ribbon

Lecture 20 Demo - B-1: Hiding and Showing the Ribbon

Lecture 21 Customize the Ribbon

Lecture 22 Demo - B-2: Rearranging Ribbon Tabs

Lecture 23 Hide and Remove Tab Elements

Lecture 24 Demo - B-3: Hiding and Removing Tabs and Groups

Lecture 25 Create Custom Tabs and Groups

Lecture 26 Demo - B-4: Creating a Tab

Lecture 27 Reset the Ribbon

Lecture 28 Demo - B-5: Resetting the Ribbon

Lecture 29 Topic C: Microsoft Office Backstage View

Lecture 30 Backstage View in Word

Lecture 31 The Document Panel

Lecture 32 File Type Options

Lecture 33 Demo - C -1: Viewing and Editing Document Properties

Lecture 34 Print Settings

Lecture 35 Demo - C -2: Specifying Print Settings

Lecture 36 Options for Saving Documents

Lecture 37 Recovering a Draft

Lecture 38 Demo - C -3: Recovering a Draft of a Previously Saved File

Lecture 39 Demo - C -4: Finishing a Document

Lecture 40 PDF Document Created in Word

Lecture 41 Demo - C -5: Saving a File as a Static Document

Lecture 42 Unit 01 Review

Section 3: Unit 02 - New Word Features

Lecture 43 New Word Features

Lecture 44 Topic A: Formatting Options

Lecture 45 Format Text Effects Dialog Box

Lecture 46 Demo - A -1: Applying Text Effects

Lecture 47 Demo - A -2: Adjusting a Picture's Color

Lecture 48 Topic B: The Navigation Pane

Lecture 49 Use the Navigation Pane to Find Text

Lecture 50 Demo - B -1: Using the Navigation Pane to Search for Text

Lecture 51 Outline Levels

Lecture 52 Browse Headings and Pages

Lecture 53 Demo - B -2: Organizing an Outline

Lecture 54 Unit 02 Review

Section 4: Unit 03 - New Excel Features

Lecture 55 New Excel Features

Lecture 56 Topic A: Sparklines

Lecture 57 Sparklines

Lecture 58 Create Sparklines Dialog Box

Lecture 59 Demo - A -1: Inserting a Sparkline

Lecture 60 Topic B: PivotTables and Slicers

Lecture 61 A PivotTable

Lecture 62 Create a PivotTable

Lecture 63 Demo - B -1: Creating a PivotTable

Lecture 64 Add Fields to a PivotTable

Lecture 65 Demo - B -2: Adding Fields to a PivotTable

Lecture 66 Insert a Slicer

Lecture 67 PivotTable with Slicers

Lecture 68 Demo - B -3: Using Slicers to Filter PivotTable Data

Lecture 69 Topic C: PivotCharts

Lecture 70 Create a PivotChart

Lecture 71 A PivotChart

Lecture 72 Demo - C -1: Creating a PivotChart

Lecture 73 Unit 03 Review

Section 5: Unit 04 - New PowerPoint Features

Lecture 74 New PowerPoint Features

Lecture 75 Topic A: Reading View

Lecture 76 Reading View

Lecture 77 Demo - A -1: Previewing and Running a Presentation

Lecture 78 Topic B: Sections

Lecture 79 Add Sections

Lecture 80 Demo - B -1: Adding Sections

Lecture 81 Demo - B -2: Renaming Sections

Lecture 82 Demo - B -3: Moving Sections

Lecture 83 Printing Sections

Lecture 84 Demo - B -4: Printing a Section

Lecture 85 Topic C: Media Clips

Lecture 86 Video Playback Controls

Lecture 87 Demo - C -1: Adding a Video Clip

Lecture 88 Video Tools | Format Tab

Lecture 89 Demo - C -2: Formatting a Video

Lecture 90 Trim Video Dialog Box

Lecture 91 Demo - C -3: Specify Video Playback Options

Lecture 92 Topic D: Animations

Lecture 93 Animation Tags

Lecture 94 Demo - D -1: Animating Text and Objects

Lecture 95 Demo - D -2: Using the Animation Printer

Lecture 96 Topic E: Broadcasting a Slide Show Online

Lecture 97 Broadcasting a Slide Show

Lecture 98 Broadcast Slide Show Dialog Box

Lecture 99 Questions and Answers

Lecture 100 Unit 04 Review

Section 6: Unit 05 - New Outlook Features

Lecture 101 New Outlook Features

Lecture 102 The Outlook Interface

Lecture 103 The Outlook 2010 Window

Lecture 104 Outlook -Specific UI Elements

Lecture 105 Demo - A -1: Exploring the Outlook Window

Lecture 106 Context -Sensitive Tabs

Lecture 107 Demo - A -2: Examining Tabs

Lecture 108 Conversation Management

Lecture 109 Message Composition Window

Lecture 110 Demo - B -1: Creating and Sending a Message

Lecture 111 Reply to a Message

Lecture 112 Demo - B -2: Replying to a Message

Lecture 113 Conversations

Lecture 114 Demo - B -3: Exploring Conversations

Lecture 115 Conversation Management

Lecture 116 Demo - B -4: Managing Conversations

Lecture 117 Quick Steps

Lecture 118 Quick Steps

Lecture 119 Demo - C -1: Using Quick Steps

Lecture 120 Configure Quick Steps

Lecture 121 Demo - C -2: Configuring a Quick Step

Lecture 122 Creating a Quick Step

Lecture 123 Demo - C -3: Creating a Quick Step

Lecture 124 The People Pane

Lecture 125 Outlook Social Connector

Lecture 126 People Pane

Lecture 127 Demo - D -1: Examining the People Pane

Lecture 128 Expanded People Pane

Lecture 129 Demo - D -2: Viewing Custom Photos in the People Pane

Lecture 130 Contact Card

Lecture 131 Pinning a Contact Card

Lecture 132 Demo - D-3: Viewing Contact details

Lecture 133 Unit 5 Review

Section 7: Unit 06 - New Access Features

Lecture 134 New Access Features

Lecture 135 The Access 2010 Environment

Lecture 136 Tabbed Documents

Lecture 137 Demo - A-1: Using the Document Window

Lecture 138 Data Features

Lecture 139 Lookup Fields

Lecture 140 A Lookup List

Lecture 141 Demo - B-1: Preparing to use the Lookup Wizard

Lecture 142 Demo - B-2: Creating a Lookup List

Lecture 143 Attachment Data Type

Lecture 144 Demo - B-3: Using the Attachment Data Type

Lecture 145 Demo - B-4: Using the Data Type Gallery

Lecture 146 Unit 06 Review

Lecture 147 Course Closure

Individuals looking to update their skill-set to Microsoft Office 2010,Data entry operators,Writers and publishers,Accountants and financial analysts,Presenters and business/sales executives,Candidates seeking to move to the latest version of Microsoft Office