Guide to New Features in Office 2013

This guide describes the new features in Office 2013.

To become familiar with Office 2013, you can browse through Microsoft’s Office 2013 Quick Start Guides.

For more information on specific new features, please click on the relevant tab below.

What's New in Office 2013

Office Start Screen

You will see this screen every time you open Excel, Word, or PowerPoint. The following options are available to you:

a. Recent

  • Displays a list of recently opened Office files with the option to pin (office2013_pin)

b. Search for online templates

c. create either a Blank document or use one of the templates presented to you

d. Take a tour

  • Opens a brief introduction to the Office program you are in


To disable the Office Start Screen, click File | Options and untick Show the Start screen when this application starts.

Learn more about the new features in Office 2013 at Microsoft’s website.

New Features in Excel 2013

1. Flash Fill

Automatically fills the column where the active cell is, based on patterns around it

  • click Data | Flash Fill or press Ctrl+E

Flash Fill
Flash Fill

2. Quick Analysis

Gives you immediate access to FORMATTING, CHARTS, TOTALS, TABLES and SPARKLINES

  • right-click within a table or press Ctrl+Q

quick analysis

  • hovering over options gives a preview

Quick analysis

3. Recommended Charts

Recommends different Charts based on the data selected

  • click Insert | Recommended Charts

Recommended charts

4. Recommended PivotTables

Recommends different PivotTables based on the data selected

  • click Insert | Recommended PivotTables

Recommended Pivot Tables

5. One window per Workbook

Allows viewing two or more Workbooks side-by side

  • click View | Arrange All

Arrange windows

6. Chart settings

The three buttons on the upper–right corner of a selected chart can be used to quickly change its settings

  • hovering over options gives a preview

Chart settings

Learn more about the new features in Excel 2013 at Microsoft’s website.

New Features in Word 2013

1. Read Mode

Displays the document in an easy-to-read mode with more options in the View tab

  • click Read Mode (word2013_readicon) in the Status Bar

 

2. Object zoom

When in Read Mode,double-click a table, chart or image to make it bigger

Please note: this feature works on widescreen resolutions only

3. Resume reading

Allows you to pick up from the page you left off when you reopen a document

4. Online Pictures

Searches the web for pictures licensed under Creative Commons

  • click Insert | Online Pictures

5. Online Videos

Searches the web for videos, which can be inserted into and played from within Word 2013

  • click Insert | Online Video

Please note: the feature to play videos from within Word 2013 requires Internet Explorer 11 or above

6.  Expand and collapse

Text which has a Heading Style applied to it can be collapsed to hide all text underneath

7. Reply to comments

Allows replies to existing comments, and marking them or individual replies as done

Reply Comments

8. Edit PDFs

Please note: this feature works best with typed documents

9. Alignment guides

Dragging charts, diagrams and photos shows a live preview of their lining up with margins and text

Object alignment

Learn more about the new features in Word 2013 at Microsoft’s website.

New Features in Outlook 2013

1. Inline Replies

Allows you to reply from within the Reading Pane, without opening a new window

  • click Reply or press Ctrl+R

 

2. Commands in message list

Allows you to mark your messages read or unread

  • click on the left of the message(s) you want marked

3. Quick glance

You can view Calendar, People, or Tasks without having to switch from email to calendar or other modes.

  • hover with the mouse over the relevant menu

Learn more about the new features in Outlook 2013 at Microsoft’s website.

New Features in PowerPoint 2013

1. Presenter View with a single display

Presenter View no longer requires multiple displays, which allows you to rehearse on any device

  • press Alt+F5

2. Laser Pointer

Changes the mouse cursor into a laser dot

  • while in Presenter View, click on Pen and laser pointer tools

3. Zoom into a section of the slide

Allows you to zoom into a slide to emphasize a section of it

  • while in Presenter View, click on Zoom into the slide

4. Touch devices support

Allows you to interact with PowerPoint 2013 on almost any device

  • use touch gestures to tap, swipe, scroll, zoom, and pan through slides

5. Improved video and audio support

PowerPoint 2013 supports multimedia formats, such as .mp4 and .mov with H.264 video, and Advanced Audio Coding (AAC) audio.

6. Comments

Allows you to give feedback in PowerPoint, show or hide comments and revisions

  • click Review | Show Comments

Learn more about the new features in PowerPoint 2013 at Microsoft’s website.

Share:Facebook|Twitter|LinkedIn|