Transcript Word
Microsoft Office 2013 and the Metro UI
Wilmington University Educational Technology 1
*
Integration with SkyDrive
• Office 2013, like the new Windows 8, have close integration with Microsoft’s free cloud file storage service SkyDrive. 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 Wilmington University Educational Technology 2
Office 2013 uses the “Metro” User Interface (Much more compatible with tablets/touch screens)
Even the ribbon menu has been restyled – the rich looking, rounded tabs replaced with something that aims to be far more functional.
Wilmington University Educational Technology 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… Wilmington University Educational Technology 4
• • • • • • • • • • • • • •
New Features in Word
Metro User Interface New and Improved Templates!
Backstage View – Metadata *Sharing Options – Easily Integrates with SkyDrive (cloud-based storage) Ability to edit and review PDFs has Improved Embedding YouTube 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
Metro User Interface
Wilmington University Educational Technology 6
New and Improved Templates!
Wilmington University Educational Technology 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. Wilmington University Educational Technology 8
*
Sharing Options – Easily Integrates with SkyDrive (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. Wilmington University Educational Technology 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.
Wilmington University Educational Technology 10
You can now search for more than just text. You can search for pictures, comments, or even tables! Wilmington University Educational Technology 11
Clear Formatting Tool - Remove all formatting from the selection, leaving only the normal, unformatted text.
Wilmington University Educational Technology 12
New Design Tab
• Consolidates all the theme and styling tools • Lets you select different themes – useful for dynamically changing the color scheme of your headings and tables Wilmington University Educational Technology 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 Wilmington University Educational Technology 14
Word talks “Speak selected text” Wilmington University Educational Technology 15
Change Color of Office Theme
Wilmington University Educational Technology 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.
Wilmington University Educational Technology 17
New Features in PowerPoint
• • • • • • • • 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 New Navigation grid in Presenter View - Enables you to easily navigate between slides!
PowerPoint on Touch Devices Embedding YouTube videos still has compatibility issues and typically does not work Wilmington University Educational Technology 18
Metro User Interface
Wilmington University Educational Technology 19
New Default Slide Size
• Much of the world’s TVs and video have gone to widescreen and HD formats, and so has PowerPoint. In previous versions, the slide ratio was 4:3. In PowerPoint 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 PowerPoint, 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.
Wilmington University Educational Technology 20
Integrated Screen Clipping Tool
Wilmington University Educational Technology 21
Cropping Made Easy! Just click on a Photo, then click the Pictures Tool Tab, then Click Crop. Wilmington University Educational Technology 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.
Wilmington University Educational Technology 23
New Navigation grid in Presenter View - Enables you to easily navigate between slides!
Wilmington University Educational Technology 24
PowerPoint on Touch Devices
• You can now interact with PowerPoint 2013 on touch devices running Windows 8. Using typical touch gestures, you can swipe, tap, scroll, zoom, and pan your way through your presentations Wilmington University Educational Technology 25
Embedding YouTube 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. Wilmington University Educational Technology 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 Wilmington University Educational Technology 27
Metro User Interface
Wilmington University Educational Technology 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.
Wilmington University Educational Technology 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. Wilmington University Educational Technology 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.
Wilmington University Educational Technology 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. Wilmington University Educational Technology 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.
Wilmington University Educational Technology 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.
Wilmington University Educational Technology 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.
Wilmington University Educational Technology 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.
Wilmington University Educational Technology 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.
Wilmington University Educational Technology 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.
Wilmington University Educational Technology 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.
Wilmington University Educational Technology 39
Set print area
Wilmington University Educational Technology 40
Shrink to fit
Wilmington University Educational Technology 41
Questions/Additional Resources
•
One-on-One Training
to set up a one-on-one training session with an instructional technologist.
•
Lynda.com - Online Training
Lynda.com has online training tutorials for over 150 software applications. Once you have an account, you can access these high-quality training tutorials that 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
Wilmington University Educational Technology 42
Sources
• Excel 2013 Quick Start Guide • MakeUseOf.com's Microsoft Office 2013: Unofficial Guide • • Microsoft Office 2013 Quick Start Guides PowerPoint 2013 Quick Start Guide • Word 2013 Quick Start Guide Wilmington University Educational Technology 43