Microsoft Office 2013 and the Metro UI Prof

Microsoft Office 2013 and the Metro UI Prof. Abdul Hameed Staff and Teachers Training Institute http: //informationtechnology. pk 1

*Integration with Sky. Drive • Office 2013, like the new Windows 8, have close integration with Microsoft’s free cloud file storage service Sky. Drive. There are two ways to sign into Office 2013, via a Microsoft account (such as Hotmail, Windows Live or even Xbox Live) • *THE SIGN-IN FEATURE DOESN’T WORK ON COMPUTERS ON CAMPUS 2

Office 2013 uses the “Metro” User Interface (Much more compatible with tablets/touch screens) Even the ribbon menu has been restyled – the richlooking, rounded tabs replaced with something that aims to be far more functional. 3

The Metro restyle is the Biggest Change! • Not much else has changed from the 2010 version in terms of the arrangement and organization of features. • There are, however, some new features that aim to increase productivity… 4

• • • • New Features in Word Metro User Interface New and Improved Templates! Backstage View – Metadata *Sharing Options – Easily Integrates with Sky. Drive (cloud-based storage) Ability to edit and review PDFs has Improved Embedding You. Tube Videos finally it works…just kidding You can now search for more than just text. You can search for pictures, comments, or even tables! Clear Formatting Tool New Design Tab Read Mode Integrated Screen Clipping Tool Word talks “Speak selected text” Change Color of Office Theme 5 Compatibility with Earlier Versions

Metro User Interface 6

New and Improved Templates! 7

Backstage View – Metadata • The Office Backstage view is where you manage your files and the data about them — creating, saving, inspecting for hidden metadata or personal information, and setting options. • Here you’ll find a good selection of new and improved templates, covering everything from blog posts and Thanksgiving invitations to annual reports and live music flyers. 8

*Sharing Options – Easily Integrates with Sky. Drive (cloud-based storage) *You need to be signed in to use this feature, but the IT team has disabled this feature for security purposes. If you have Office 2013 installed on your personal computer, you can use this feature. 9

Ability to edit and review PDFs has Improved • Note that editing PDFs can be hit and miss – the process requires that the existing PDF document is converted into DOCX format, something that can result in an inaccurate layout. Simple layouts should convert without too much trouble, however. • Note that editing takes place once the file is converted to DOCX format, and as such you will need to select the PDF file option in the Save as dialogue box to keep your changes. 10

You can now search for more than just text. You can search for pictures, comments, or even tables! 11

Clear Formatting Tool - Remove all formatting from the selection, leaving only the normal, unformatted text. 12

New Design Tab • Consolidates all theme and styling tools • Lets you select different themes – useful for dynamically changing the color scheme of your headings and tables 13

Read Mode - The best way to read a document, including some tools designed for reading instead of writing. • Click View > in the Views group > click Read Mode. • Goes Full Screen • Double-click an image to enlarge • Free of distractions as most buttons are hidden 14

Word talks “Speak selected text” 15

Change Color of Office Theme 16

Compatibility with Earlier Versions • You can save the file as a Word 97 -2003 document. This changes the file extension from. DOCX to . DOC. This means users who have not upgraded to version 2007 or higher will be able to open it with downloading a viewer. 17

New Features in Power. Point • • Metro User Interface New Default Slide Size Integrated Screen Clipping Tool Cropping Made Easy! Just click on a Photo, then click the Pictures Tool Tab, then Click Crop. New Look Presenter View Navigation grid in Presenter View - Enables you to easily navigate between slides! Power. Point on Touch Devices Embedding You. Tube videos still has compatibility issues and typically does not work 18

Metro User Interface 19

New Default Slide Size • Much of the world’s TVs and video have gone to widescreen and HD formats, and so has Power. Point. In previous versions, the slide ratio was 4: 3. In Power. Point 2013, 16: 9 is the new default, but you can change this on the Design tab. • If you work with slides in older versions of Power. Point, or are presenting on older • monitors or projectors, you’ll want to change the slide ratio back to 4: 3. To do so, Click Design > Slide Size and then choose 4: 3. 20

Integrated Screen Clipping Tool 21

Cropping Made Easy! Just click on a Photo, then click the Pictures Tool Tab, then Click Crop. 22

New Look Presenter View • Note that Presenter View no longer requires multiple monitors. Now you can rehearse and use all the tools in Presenter View from a single monitor without hooking up anything else. • The Presenter View enables the user to plan ahead by displaying notes about the slide and providing a preview of the next, and offers various other controls, including a pen tool for drawing the audience’s attention to a particular slide or detail. 23

New Navigation grid in Presenter View - Enables you to easily navigate between slides! 24

Power. Point on Touch Devices • You can now interact with Power. Point 2013 on touch devices running Windows 8. Using typical touch gestures, you can swipe, tap, scroll, zoom, and pan your way through your presentations 25

Embedding You. Tube videos still has compatibility issues and typically does not work • Online videos can finally be embedded into a Word document in Office 2013, via the Insert tab – but you need to be signed in. This doesn’t work on campus computers because of security settings. 26

New Features in Excel New Features Metro User Interface Recommended Charts Tool Apply Features Without the Ribbon Flash Fill Option Old Features, but often forgotten Instantly reveal formulas and general number format of all cells Comparing 2 or more Excel spreadsheets simultaneously Tables Freeze Headers Set print area Shrink to fit 27

Metro User Interface 28

Recommended Charts Tool • A more complicated table will result in the suggestion of a more detailed chart, but you can easily choose a different chart if you don’t like the results. 29

How to use the Recommended Charts Tool • To use the tool, select the data that you want to chart, click the Insert tab and select Recommended Charts. A dialog appears with a range of charts to choose from—click each in turn to see how your data will look plotted on that chart. Select the desired option and click OK, and the chart is created automatically. 30

Apply Features Without the Ribbon • Frequently used, but hard to find commands and buttons are easier to find. When you select data on your worksheet, the Quick Analysis • button appears. It gives you quick access to many useful features you may not have been aware of, and lets you preview them on your data before you make them stick. 31

Flash Fill Option • When entering data, you might notice that Excel fills values automatically as it detects a pattern. You’ll get the Flash Fill Options button to make further decisions. 32

Instantly reveal formulas and general number format of all cells • Show all formulas and the general number format of cells • Saves you time because you don’t have to move the cell pointer to check each formula one-by-one. 33

Comparing 2 or more Excel spreadsheets simultaneously • You can open two instances of Excel INSTEAD of multiple files on top of each other in the same Excel application. • To do this, simply open Excel by double clicking the icon on your desktop and open the first Excel file you want to use. Minimize this window and move it to the right screen. Then go back to the desktop, double click the Excel icon once more, another separate Excel window will open. 34

Tables • To make managing and analyzing a group of related data easier, you can turn a range of cells into a Microsoft Office Excel table (previously known as an Excel list). A table typically contains related data in a series of worksheet rows and columns that have been formatted as a table. By using the table features, you can then manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet. 35

Elements of an excel table • Header row By default, a table has a header row. Every table column has filtering enabled in the header row so that you can filter or sort your table data quickly. 36

Elements of an excel table • Banded rows By default, alternate shading or banding has been applied to the rows in a table to better distinguish the data. 37

Elements of an excel table • Total row You can add a total row to your table that provides access to summary functions (such as the AVERAGE, COUNT, or SUM function). A drop-down list appears in each total row cell so that you can quickly calculate the totals that you want. 38

Freeze Headers • To freeze a row in your worksheet, highlight the row where you wish all rows before the highlighted row to be frozen or locked, go to Window>Freeze Panes and you will see a line appear across your worksheet. Everything above the line is frozen and will remain in view when you scroll down your worksheet. 39

Set print area 40

Shrink to fit 41

Questions/Additional Resources One-on-One Training Lynda. com - Online Training • Email Ed. Tech@wilmu. edu to set • Lynda. com has online training tutorials up a one-on-one training session for over 150 software applications. Once you have an account, you can access with an instructional these high-quality training tutorials that technologist. are taught by industry experts and available 24/7 for convenient, self-paced learning. Request an account at: www. wilmu. edu/edtech/training/lynda. aspx 42

Sources • Excel 2013 Quick Start Guide • Make. Use. Of. com's Microsoft Office 2013: Unofficial Guide • Microsoft Office 2013 Quick Start Guides • Power. Point 2013 Quick Start Guide • Word 2013 Quick Start Guide 43