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

2. Quick Analysis

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

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

• hovering over options gives a preview

3. Recommended Charts

Recommends different Charts based on the data selected

• click Insert | Recommended Charts

4. Recommended PivotTables

Recommends different PivotTables based on the data selected

• click Insert | Recommended PivotTables

5. One window per Workbook

Allows viewing two or more Workbooks side-by side

• click View | Arrange All

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

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 () 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

• More information

7. Reply to comments

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

8. Edit PDFs

Please note: this feature works best with typed documents

• More information

9. Alignment guides

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

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.