Microsoft Office 2013

This documentation includes Word, Excel, Outlook, and PowerPoint

Microsoft Office 2013 New Features

Dr. Sherri E. Ritter

Word 2013 1. Resume Reading

When you save a document, the next time you open that document you will receive a message on the right side of the screen asking if you want to pick up where you left off. If you do click the message and you will return to the last place you were before exiting the document.

2. Read View At the bottom right side of the screen you can zoom in on the page by clicking the + or – sign.

The first sign is the read mode. This mode will allow you to read the document horizontally instead of the traditional scroll down method.

The second icon is the standard edit mode. The third icon give you a webpage view.

In the Read mode you can double tap on any image to enlarge.

This will not mess up the original placement of the image in the document.

3. Add additional services Your version of Office is associated with your account. You can add additional accounts to your office. In this case you can go to the user account information (Top Right Hand corner of your window, click the drop down beside your name and choose account settings).

On the account User Information page click Add a Service At the pop-up window put your service email and hit next.

Insert your password and you will default back to your Account page.

Created April 2013 by Dr. Sherri E Ritter

1 http://learningcenteredtechnology.wordpress.com /

On your account page you will notice additional services listed in your services. Click on Manage by your Facebook account. You will receive a permission screen to allow Microsoft to access Facebook.

Once you hit save you can access your Facebook pictures from Office 2013.

Now when you go to Insert> Online Pictures you will see Facebook listed.

Insert> Illustrations> Online Pictures

Created April 2013 by Dr. Sherri E Ritter

2 http://learningcenteredtechnology.wordpress.com /

4. PDF to Word You can open a pdf document File> Open> Select Location and file

You will receive a pop-up asking to convert from PDF to Word. Select OK

You can now modify the PDF document and save it as a word file.

5. Compare documents View> Window> View Side by Side

Created April 2013 by Dr. Sherri E Ritter

3 http://learningcenteredtechnology.wordpress.com /

With this view you can see two documents at the same time. Synchronous Scrolling will automatically be enabled so both screens will scroll together.

6. Video Insert> Illustrations> Online Video When the video pop-up window appears put your search terms in the appropriate source window (In this case I was looking for a video of the president). I then hit search.

A list of videos appeared. Select the appropriate video and click Insert

The video will appear where the cursor was located on the document page.

Created April 2013 by Dr. Sherri E Ritter

4 http://learningcenteredtechnology.wordpress.com /

7. Apps Insert> Apps> Apps for Office> See All> featured Apps The first time you use this app you will need to make sure you have logged onto Microsoft. There will be a log on option on the pop-up screen. If you are unable to log in on the popup you will need to go back to your account settings (File> Account).

To get started you should check out the Featured Apps. Some will be free but other have a small fee associated.

Select a free app and click add.

The app will appear on the right side of your word screen.

In this case I have chosen the Word Cloud App.

I have a series of words written on the word document. (The more often a word appears in the list the larger the word will appear in the art work.)

Select the words Choose the cloud options like font, layout, etc. and click Create Word Cloud.

You can now copy and paste the word cloud into your document or save it as an image to insert at a later time.

Created April 2013 by Dr. Sherri E Ritter

5 http://learningcenteredtechnology.wordpress.com /

Excel 2013 1. Easy Charting Select the data you want in the chart> Insert> Charts> Recommended Charts

2. Sparklines Select the data you want Sparklines> Insert > Sparklines> choose type> choose location of the Sparkline

Created April 2013 by Dr. Sherri E Ritter

6 http://learningcenteredtechnology.wordpress.com /

3. Pivotal Tables Select the data including column/row labels> Insert> Pivot Chart> New Worksheet> OK At first the charts will be blank, but when you select the fields the charts will appear.

4. Data Controls

5. Data Quick Analysis Selecting a series of data will create a pop-up on the bottom right of the data. Clicking this will give you a series of tools to analyze your data.

Created April 2013 by Dr. Sherri E Ritter

7 http://learningcenteredtechnology.wordpress.com /

6. Flash Fill (Case Sensitive) Data> Data> Flash Fill In this demo, first and last name appears in one column. In the jointing column I type the first name of the person in the first cell, move one cell down and click Flash Fill. The first name appears for the remaining fields. Moving to the next column repeat the steps for the last name.

7. Remove Duplicates Select the data fields and click Data Tab> Remove duplicates> Select the columns> OK 8. Sort a List Click on the column you want to sort> Home Tab> Sort & Filter> Sort A to Z (Or do Custom Sort) 9. Filter a list Select the first item in list of data> Data Tab> Filter

10. Navigation Auto Sum Press Alt = (This works for a single colum/rown or multiple columns/rows)

Created April 2013 by Dr. Sherri E Ritter

8 http://learningcenteredtechnology.wordpress.com /

View Calculation in the Status Bar (This works for single or multiple columns/rows)

Right clicking on the status bar will allow you to change the fields that appear in status.

11. Transpose Copy section> Move to new location> Paste> Paste Special> Transpose> OK

Created April 2013 by Dr. Sherri E Ritter

9 http://learningcenteredtechnology.wordpress.com /

Outlook 2013 1. Email 1

Switching from email, to Calendar, People, is now listed at the bottom of the screen.

2

Unread messages appear in blue while read message appear in gray. Selected messages appear in blue.

3

Moving your mouse over an item put an X at the end of the item allowing you to delete the item.

4

When you are reading an item at the top of the message you have the option to Reply, Reply All, or Forward

4

2

3

1 Having the word attachment in the subject line or anywhere within the message will result in a reminder to attach a file.

Created April 2013 by Dr. Sherri E Ritter

10 http://learningcenteredtechnology.wordpress.com /

When you are reading a message at the bottom of the message window a panel will appear to allow you to see all messages from the person.

Clicking on the button to the right of the people icons will show you all the people the message was copied.

Message Sensitivity Options> More Options> Sensitivity

The recipients will see the following text in the InfoBar (InfoBar: Banner near the top of an open email message, appointment, contact, or task.) of the message: This will not restrict others from forwarding the message!

   

For Normal, no sensitivity level is assigned to the message. Therefore, no text is displayed in the InfoBar. For Private, the recipient will see Please treat this as Private in the InfoBar. For Personal, the recipient will see Please treat this as Personal in the InfoBar. For Confidential, the recipient will see Please treat this as Confidential in the InfoBar.

Created April 2013 by Dr. Sherri E Ritter

11 http://learningcenteredtechnology.wordpress.com /

2. Calendar One new feature of the calendar is the weather. At the top of the calendar you will see the current temperature and weather conditions and forecast.

The calendar looks very similar. You can choose between weeks, days, and month view.

When you mouse over an appointment a pop-up will give you additional information.

Group Calendar Home> Manage Calendars> Calendar Group This function allows you to create a group calendar so you can see all members’ calendar events with the click on one button.

Created April 2013 by Dr. Sherri E Ritter

12 http://learningcenteredtechnology.wordpress.com /

3. People Contacts is now People.

When a contact is selected, their information pops up. In this case you can see name, phone, email, and additional information.

If you right click on the person’s name you can add them to your favorites list. The favorites list gives you quick access to select people. To view the favorites list click View> Layout> To-Do Bar and select People.

Another feature of the MS Office suite is the social aspect. In the case of People you can add different sources in which to draw contacts, like Facebook, and LinkedIn.

To include other social accounts click File> Info> Add an Account.

A pop-up window will appear. Select the social site you want and hit next and answer the questions.

Created April 2013 by Dr. Sherri E Ritter

13 http://learningcenteredtechnology.wordpress.com /

PowerPoint 2013 1. Templates PowerPoint 2013 has a wider variety of design templates and colors.

New Size to accommodate HD screens Design> Customize> Slide Size

2. Slide Guide Guides have been added to make it easier to line up screen content. These guides appear automatically as you organize content on the screen. There are both vertical and horizonal guides.

Created April 2013 by Dr. Sherri E Ritter

14 http://learningcenteredtechnology.wordpress.com /

3. Transitions You now have a wider array of slide transitions and they are easier to apply. Simply select the slide and apply the transition.

Transitions> Transitions to This Slide

4. Animation More control over animation.

Animations> Animation> Add Animation

Created April 2013 by Dr. Sherri E Ritter

15 http://learningcenteredtechnology.wordpress.com /

If you use a path animation, you can clearly see the path, starting point, and ending point.

Start Point

End Point

Path

5. Share It is easy to share or present online!

Created April 2013 by Dr. Sherri E Ritter

16 http://learningcenteredtechnology.wordpress.com /

6. Video You can now easily convert your PPT to video.

File> Export> Create a Video

7. Extended Viewing It is easier to present your PPT to a live audience now with extended screen. You can see speaker notes and have access to a variety of tools, while your audience enjoys the presentation.

In order to use Extended Viewing you must change your display settings to Extended Viewing.

Right click on your desktop> Screen Resolution> Change Multiple Displays to Extended Viewing

Created April 2013 by Dr. Sherri E Ritter

17 http://learningcenteredtechnology.wordpress.com /

The Display settings allow you to switch between Presenter View and Slide show.

Using the zoom tool you can zoom into portions of a slide.

The Pen tools allows you to write on the screen, or turns your mouse into a laser pointer.

While the slide tools allows you to navigate slides.

Created April 2013 by Dr. Sherri E Ritter

18 http://learningcenteredtechnology.wordpress.com /

http://learningcenteredtechnology.wordpress.com/