Office 2010 hands-on lab

SEGMENT

STEPS

Microsoft Office 2010 Hands-on Labs 速

SEGMENT

STEPS

Welcome to the Office 2010 Hands-on Lab

1. Familiarize yourself with the new Office application icons. This screen shot provides a view of what your desktop might look

2

like. NOTE: The applications will likely be maximized initially.

2. Simply click the icon on the task bar at the bottom of your screen and it will bring up the application.

Welcome to the Office Hands-on Lab. In the next 30 minutes, you will get to test drive Office 2010 and get to experience the best productivity experience on the PC, Phone and Browser.

Excel 2010

OneNote 2010

Word 2010

IE Browser

The Best Productivity Experience on the PC, Phone and Browser

PowerPoint 2010

Outlook 2010 Office Communicator

SEGMENT

STEPS

Office 2010 – Ribbon

1. In Word 2010, review the Ribbon. Notice how the commands have been logically grouped together under tabs to make it more visible, making it easier to learn and accomplish your task using Office 2010. Look at the Clipboard, Font or Paragraph groups. Once you are familiar with this Ribbon, you will find it easier to learn all the Office 2010 Applications.

Discover more commands and accomplish your task faster.

The Ribbon, which was first introduced in Office 2007, is now available across all Office 2010 applications, making the commands and tools available more visible and easier to access, so you could focus on your content.

In this section, you will be exploring the Ribbon to familiarize yourself with the user interface.

Explore the Ribbon by clicking the other tabs like Insert or Review and you will see other groups of commands as shown below.

Click the Home tab on the Ribbon when you are done. Now that you are familiar with the Ribbon user interface in Word 2010, you will find it very easy to learn other Office applications.

The Best Productivity Experience on the PC, Phone and Browser

3

SEGMENT

STEPS

Office 2010 – Ribbon

OPTIONAL: In Excel 2010, review the Ribbon. Look at the grouping of the commands again. It has the same familiar Ribbon user interface.

OPTIONAL: In PowerPoint 2010, review the Ribbon. See the consistency of the Ribbon across all the Office 2010 applications.

The Best Productivity Experience on the PC, Phone and Browser

4

SEGMENT Office 2010 – Backstage The most common operations are collected in one easy-to-use place.

STEPS 1. In Word 2010, in the Ribbon, click the blue File tab to enter the Backstage view.

2. On this Backstage view, you will see all the relevant information pertaining to this document. You can perform several commands like Protect Document, Check for Issues or Manage Versions in this screen. Now, click Print to view print options for this document.

The new Microsoft Office Backstage™ view replaces the traditional file menu to let you save, print and share your Office documents with a few clicks.

Related but separate tasks are brought together also. For instance, printing tools — previously spread across several commands — are all together on one cozy clickable Print tab within the Backstage view.

The Best Productivity Experience on the PC, Phone and Browser

5

SEGMENT

STEPS

Office 2010 – Backstage

3. You will see the screen below. Try going to the next page or changing the Zoom. When you are done, click on Share to review

6

the multiple ways you can share documents.

4. To close the Backstage view, click on the blue File tab again in the top-left corner.

Go Next Page

The Best Productivity Experience on the PC, Phone and Browser

Zoom

SEGMENT

STEPS

Office 2010 Paste Preview

1. In Excel 2010, select the Product Sales table by clicking the cell with the text Product Sales by Year, holding down the left

7

mouse button and then dragging to the bottom right of the table.

2. In the Home tab of the Ribbon, click Copy.

Get the results you want with Paste Preview.

Paste is the most frequently used Microsoft Office command. To make those clicks count, we created Paste Preview so you can see what your additions will look like before you drop them in.

In this section, you will learn a common set of steps most executives perform in preparing a presentation.

You will copy a table from Excel 2010 and paste it into a PowerPoint slide.

The Best Productivity Experience on the PC, Phone and Browser

Select Product Sales Table

SEGMENT

STEPS

Office 2010 Paste Preview

3. In PowerPoint 2010, click Slide 7 in the Slides pane.

8

4. Click the rectangle just below the Product Data heading.

5. In the Home tab of the Ribbon, click the Paste dropdown button

Click the Paste dropdown button

Click below the Product Data heading

Click Slide 7

The Best Productivity Experience on the PC, Phone and Browser

SEGMENT

STEPS

Office 2010 Paste Preview

6. Hover over the different Paste Options using your mouse to see a live preview of the table 7. Finally, click this

9

paste option.

The Best Productivity Experience on the PC, Phone and Browser

SEGMENT

STEPS

Word 2010 Navigation Pane

1. In Word 2010, in the Navigation task pane, click several different section headings to navigate the document.

Get a handle on longer documents with the Navigation Pane.

10

2. Click the Thumbnail View to browse the pages in the document.

3. In the search box, type ribbon. Now, you will see only the pages that contain the word ribbon.

Thumbnail View

The Navigation Pane provides you with a visual outline of your document so you can browse, sort, and find what you need quickly. The improved find experience allows you to view a summary of search results in a single pane and just click to access any individual result.

In this section, you will learn how to use the navigation pane and use the new find experience.

Transform your ideas into professional-looking documents

Click section headings to navigate the document

SEGMENT

STEPS

Word 2010 Navigation Pane

4. Now, click the Outline View to go back to section header outline view.

11

5. Finally, click the Clear Search button.

Clear Search

Outline View

Transform your ideas into professional-looking documents

SEGMENT

STEPS

Word 2010 Picture Editing

1. In Word 2010, in the Navigation task pane, click Introduction heading.

12

2. In the document, place the cursor at the end of the Overview of the Microsoft Office 2010 Technical Preview heading and press ENTER.

Do more with images, without needing extra software.

The new Picture Editing tools let you add special picture effects without additional photo-editing software and easily adjust pictures with color saturation and temperature controls. You also get improved tools for easier and more precise cropping and image correction or background removal, to help you turn a simple document into a work of art.

Introduction heading

3. In the Ribbon, click the Insert tab and then click Picture.

4. In the Insert Picture dialog box, double-click Amy Alberts.

Transform your ideas into professional-looking documents

Click here and press ENTER

SEGMENT

STEPS

Word 2010 Picture Editing

5. In Picture Tools | Format, click Artistic Effects and then click any option.

13

6. In Picture Tools | Format, click Color and then click any option.

7. In Picture Tools | Format, click Remove Background.

8. Resize the image to ensure Amy’s head is not removed and then, in the Ribbon, click Keep Changes.

Transform your ideas into professional-looking documents

SEGMENT

STEPS

Word 2010 Text Effects

1. In Word 2010, in the Navigation task pane, click the Introduction heading.

14

2. In the document, select the Introduction heading.

3. In the Ribbon, in the Font group, click the Text Effects command.

Create print-shop quality documents right from your desk with modern text effects.

With Text Effects, you can apply formatting effects such as shadow, bevel, glow, and reflection to your document text as easily as applying bold or underline. Many of the same effects used for images are now also available to both text and shapes, enabling you to seamlessly coordinate all of your content.

4. Click the Reflection menu and then click any option.

Transform your ideas into professional-looking documents

Â

SEGMENT

STEPS

Excel 2010 Sparklines

1. In Excel 2010, select Cells F7 through Q7.

Sparklines summarize trends with compact and efficient graphics.

4. In the Create Sparklines dialog box, click OK.

15

2. In the Ribbon, click the Insert tab and then, in the Sparklines group, click Column. A Create Sparklines dialog box appears.

3. Click Cell R8 ( just below the text Canada).

Sparklines are small charts that fit

in a cell that provide a clear and compact visual representation of your data. You can use them to show trends in a series of values, and highlight minimum/maximum values to increase the visual impact of your data.

In this lab, you will learn how to create Sparklines and select various styles and options for the chart.

Select cells F7 through Q7 Cell R8 5. In the Ribbon, select the High Point and Low Point check boxes.

6. In the Style group, click the More Styles button and select any of the visual styles shown in the gallery.

More Sparklines Styles

Achieve valuable insights with powerful and intuitive analysis tools

SEGMENT

STEPS

Excel 2010 Slicers

1. In Excel 2010, in the SLICER – Year to the left, click 2006. You will see the PivotTable on the right change to reflect Sales by

Get just the view you want with Slicers.

3. To show all ALL years again, click the

16

Geography just for 2006. Notice also how the Trend Sparklines change. You can also click any other year.

2. To filter on multiple years, press the CTRL key and then click multiple years. Release the CTRL key. button to clear the filter.

Slicers are new in Excel 2010, and they provide you with a visual filter of your PivotTableÂŽ data, so you can dynamically segment and filter the data to display just what you need.

In this section, you will learn how to use Slicers to apply filters to your data and

Clear filter

to remove the filters on the slicer.

Click on any year

Achieve valuable insights with powerful and intuitive analysis tools

SEGMENT

STEPS

Excel 2010 Co-Authoring

1. In the IE browser, on your home page, click the Forecast link in the document library.

Work better together with Co-Authoring. (coordinate with other group members) Co-Authoring in Excel Web App allows multiple users to edit the same spreadsheet simultaneously from multiple locations. Changes are reflected in near-real time without you having to save changes.

2. Click the Edit button.

3. Have another member of your group perform the previous two steps.

Achieve valuable insights with powerful and intuitive analysis tools

17

SEGMENT

STEPS

Excel 2010 Co-Authoring (coordinate with other group members)

4. In the July Projections table, add an amount to Albert’s Accessories cell and then press TAB.

18

5. Have the other member of your group add an amount to Albert’s Bikes cell and then press TAB. 6. Note the number of other users editing the workbook in the bottom right of the browser session.

Co-Authoring in Excel Web App allows multiple users to edit the same spreadsheet simultaneously from multiple locations. Changes are reflected in near-real time

Edit Albert’s cells

without you having to save changes.

Other users editing the workbook

Achieve valuable insights with powerful and intuitive analysis tools

SEGMENT

STEPS

PowerPoint 2010 Broadcast

1. If you are the presenter, in PowerPoint 2010, click the Slide Show tab in the Ribbon.

19

Just-in-Time show and tell.

Slide Show Broadcast Slide Show

(coordinate with other group members) With PowerPoint Broadcast, you can instantly broadcast your PowerPoint 2010 presentations by sending a link to where people can view your presentation on the Web. Your audience sees your slides in high fidelity using the browser or phone.

2. In the Start Slide Show group, click Broadcast Slide Show.

3. In the Broadcast Slide Show dialog box, click Start Broadcast.

4. Click Send in Email.

Turn your ideas into powerful presentations

SEGMENT

STEPS

PowerPoint 2010 Broadcast (coordinate with other group members)

5. In the Outlook message, in the To box, type the name of your group (for example, Group4) and then click Check Names in

20

the Ribbon. NOTE: The shortcut key is CTRL+K.

Check Names

Type the name of your group

6. Click Send.

7. In the Broadcast Slide Show dialog box, click Start Slide Show.

8. Ask a group member to start viewing the slide show by clicking the new message in Outlook 2010 and then clicking the broadcast link. NOTE: If you have a mobile device next to your laptop, you need to select Menu and send/receive in the Outlook application in order to receive the e-mail invite. Select the message and then select the link in the message to follow along with the broadcast.

9. When you are done, press ESC and then, in the Broadcast group in the ribbon, click End Broadcast.

Turn your ideas into powerful presentations

SEGMENT

STEPS

PowerPoint 2010 Cinematic Effects

1. In PowerPoint 2010, go to Slide 2.

Add Cinematic effects to make them unforgettable.

21

2. In the Ribbon, click the Transitions tab.

3. In the Transition to This Slide group, open the transition gallery and then click Gallery. Explore other exciting transitions such as Ripple and Honeycomb.

The new Cinematic Effects offers new, dynamic slide transitions and animation effects that look similar to graphics you have seen on television. Easily access, preview, apply, customize, and replace animations.

Turn your ideas into powerful presentations

Transitions

Ripple

Honeycomb

Gallery

SEGMENT

STEPS

PowerPoint 2010 Video Editing

1. In PowerPoint 2010, go to Slide 5.

22

2. In the Ribbon, click the Insert tab and then, in the Media group, click Video button, and select Video from File.

Video is now a first class citizen in your presentation.

Video Editing comes to PowerPoint. You can now embed and edit video files directly, trim your video to show only relevant sections or even bookmark key points in a video for quick access.

Apply a variety of video styles and effects—such as reflections, bevels, and 3-D rotation—to help you quickly capture your audience’s attention.

Insert Video from File

3. In the Insert Video dialog box, double-click Old Race.

4. In the Ribbon, in the Format tab, click Video Effects button and select Reflection and then click any reflection option.

Video Tools | Format

Reflection

Turn your ideas into powerful presentations

SEGMENT

STEPS

PowerPoint 2010 Video Editing

5. In the Ribbon, in Playback tab, click Trim Video.

6. In the Trim Video dialog box, drag the red slider to the left until the video is only about five seconds long and then click OK.

7. Press the Play icon to preview the video.

Turn your ideas into powerful presentations

23

SEGMENT

STEPS

Outlook 2010 Group Scheduling View

1. In Outlook 2010, in the Navigation pane, click Calendar.

24

Schedule meetings easily with your co-workers.

The Group Scheduling View makes it easier for you to schedule a meeting and quickly find a suitable time for the appointment. You can use the new Group Scheduling View to see multiple calendars side by side or save frequently used groups of calendars together for easy access.

Schedule View

Calendar Group

Calendar 2. In the Navigation pane, click the check box for your group (for example, Group4).

3. In the Ribbon, in the Arrange group, click Schedule View.

4. In the Navigation pane, click Mail.

Collect your thoughts, information, notesup-to-date in one easy-to-find place Stay connected to your world with and our most e-mail and calendar

SEGMENT

STEPS

Outlook 2010 Conversation View

1. In Outlook 2010, click the message with the subject Review Proposal for Tailspin Toys.

25

2. Click the arrow, located to the left of the Review Proposal for Tailspin Toys subject line, to view all messages in the conversation.

Reduce Information Overload with Conversation View.

Ignore

Conversation View turns dozens

Clean Up Conversation

of e-mail messages into just a few conversations to reduce information overload. It improves the tracking and managing of e-mail conversations while saving valuable inbox space. Entire conversations can be condensed and categorized, or even ignored, with a single click.

View Conversation Messages

3. In the Home tab of the Ribbon, click Clean Up button and select Clean Up Conversation.

4. If the Clean Up Conversation dialog box appears, select the Do not show this message again check box and then click Clean Up. 5. Click the message with the subject Dinner this week.

6. In the Home tab of the Ribbon, click Ignore.

7. If the Ignore Conversation dialog box appears, select the Don’t show this message again check box and then click Ignore Conversation.

Stay connected to your world with our most up-to-date e-mail and calendar

SEGMENT

STEPS

Outlook 2010 Quick Steps

1. In Outlook 2010, click the message with the subject Fourth Coffee.

Compress multiple-step tasks into one-click with Quick Steps.

With Quick Steps, you can save time by creating and defining multi-step tasks into a single click. Tasks can include reply with a meeting request, move to a specific folder, create a new e-mail to assigned groups and more.

26

2. In the Ribbon, in the Respond group of the Home tab, click Meeting.

Meeting

Fourth Coffee Message

Stay connected to your world with our most up-to-date e-mail and calendar

SEGMENT

STEPS

27

Outlook 2010 Quick Steps

Close Message Window Location

Monday

Message Body

Suggested Times

3. In the Location box, type My Office.

4. On the calendar, click on the Monday of next week area to the right, select any of the options that show no conflicts.

5. In the message body, type Let’s meet today at 2 pm 6. Click the X in the top right of the meeting request window to close it and then click OK.

Stay connected to your world with our most up-to-date e-mail and calendar

SEGMENT

STEPS

OneNote 2010 Annotate

1. In OneNote 2010, click the LA Jewelry District page.

Link the source to the notes with OneNote.

You can now place OneNote to the side of your screen to have it constantly available for note-taking or references while researching on the Web through Windows® Internet Explorer®, reviewing a document in Microsoft® Word 2010 or creating a Microsoft® PowerPoint® 2010 slide. When you need to remember where your ideas came from, the Linked Notes feature enables you to jump right to the source of your information with

28

2. Click below the LA Jewelry District heading and then type SharePoint Site.

3. Click the Dock icon in the Quick Access Toolbar to dock OneNote 2010 to the right side of the desktop. NOTE: The shortcut key is CTRL+ALT+D.

Dock to Deskstop

4. Maximize the browser page so that it is side-by-side with OneNote 2010.

5. In OneNote 2010, place the cursor directly to the right of the text SharePoint Site, within the existing content box, and type some notes.

6. While typing, if a Microsoft OneNote dialog box appears, select the Don’t show this again check box and then click OK. 7. Hover over the Internet Explorer icon, next to the text SharePoint Site.

just a click.

8. Click the Dock icon in the Quick Access Toolbar (or press CTRL+ALT+D) to un-dock OneNote 2010 and then return to the Brainstorming page.

Collect your thoughts, information, and notes in one easy-to-find place

SEGMENT

STEPS

OneNote 2010 Search

1. In OneNote 2010, in the search box, type LA.

29

Search and browse your information without getting lost. Â Improved Search in OneNote 2010 shows you search results as you type. In addition, a new ranking system learns from past choices, prioritizing notes, pages, page titles and recent picks so you can get to your information faster and easier.

2. Double-click the LA Expansion result, in the Title contains area, which will then take you directly to the page.

3. In the search box, type LA again. Note that there are results in the Recent Picks, Title contains, and Body contains areas.

4. To search within a different scope, click the Finished: All Notebooks (change) link and then click This Notebook.

5. Click anywhere on the Brainstorming page to close the search window.

Collect your thoughts, information, and notes in one easy-to-find place

SEGMENT

STEPS

OneNote 2010 Share Notebook

1. In OneNote 2010, click the Share tab.

30

2. Click Hide Authors to show authors on the Brainstorming page.

Share your notebook without the anxiety of managing it.

When you work with multiple users on a shared notebook, automatic highlighting in OneNote 2010 provides you with a distinct view of changes since you last opened the notebook.

Additionally, the new page versions feature provides a version history by date and author.

If someone changes content inadvertently, just click to restore a previous version of the page. As with all of your shared notebook edits, changes sync automatically when you are online.

 3. Hover the differentinformation, initials to see the and authornotes display name and easy-to-find modification date place and then click Hide Authors again.

Collect yourover thoughts, in one

4. Click Recent Edits | Last 30 Days.

5. Click the Presentation to Management page to see recent edits on that page.

6. Close the Search Results task pane and then return to the Brainstorming page.

Thank you for participating in the Office 2010 Hands-on Lab. Collect your thoughts, information, and notes in one easy-to-find place