Microsoft Office for Mac Home and Student Edition 2011

Word

Publishing Layout View

Create visually rich newsletters, brochures, and documents easily. A powerful user interface gives users the ability to easily manipulate the layering of text, shapes, pictures, SmartArt, and charts in a document. Word also features new ligatures for more professional-looking documents, and new typography features for more creative document options

Visual Styles

Instantly see the Styles applied in your document, enabling great-looking documents with consistent, recurring formatting. And with the introduction of Styles Visual Aids in Word 2011, there are now color-coded visual aids that reinforce the relationship between Styles and in‐document content, while also providing one‐click checking for potential formatting errors. Styles are easier to use and more reliable than ever

Full Screen View

Maximize the space for reading and writing documents. The Full Screen View feature enables a Word user to block out all other windows, menus, palettes, and other superfluous content on the screen, to be able to completely focus on the task at hand: either reading or editing a Word document

Reorder Objects

Reorder Objects enables you to easily rearrange layers of text, photos, and graphics throughout your documents. This new functionality allows users to intuitively and directly manipulate the layers to achieve more predictable results, without cumbersome clicking and dragging

Word Web App

Post, access, edit, and share your files from virtually anywhere. Word is now integrated with Windows Live SkyDrive, so that your documents can be stored, viewed, edited, and shared in the cloud from any computer with Internet access. Supported browsers include Internet Explorer on Windows, Safari on Mac or Windows, and Firefox on Mac or Windows

Coauthoring

Word for Mac 2011 enables several collaborators to simultaneously edit the same document from different computers in different locations. During a coauthoring session, users can see when updates occur, be informed of presence of the other collaborators, block other authors from making changes to sections they are working on, and work around conflicting changes

PowerPoint

Photo Editing

Create visually rich presentations by touching up your photos right in PowerPoint. Remove backgrounds or add color filters, all with just one click

Broadcast Slide Show

Move beyond the conference room and use the cloud to broadcast your presentations online, with minimal setup time and no special software required. Now, anyone can be "present" for your presentation

Reorder Objects

Reorder Objects enables you to easily reorder layers of text, photos, and graphics throughout your presentation. This new functionality allows users to intuitively and directly manipulate the layers to achieve more predictable results, without cumbersome clicking and dragging

Presenter View

Rehearse, check your timing, or take notes while you present in Presenter View. Use visual cues to keep presenters on time, and integrate enhanced recorded narration and rehearse features

PowerPoint Web App

Post, access, edit, and share your presentation decks from virtually anywhere. PowerPoint is now integrated with Windows Live SkyDrive, so that your documents can be stored, viewed, edited, and shared in the cloud from any computer with Internet access. Supported browsers include Internet Explorer on Windows, Safari on Mac or Windows, and Firefox on Mac or Windows

Coauthoring

PowerPoint for Mac 2011 enables several collaborators to simultaneously write and edit the same document from different computers in different locations. During a coauthoring session, users can see when updates occur, be informed of presence of the other collaborators, block other authors from making changes to sections they are working on, and work around conflicting changes

Excel

Conditional Formatting

Create rich, visually compelling datasheets and tables with icons, data bars, and color scales. See enhancements like borders, solid colors, and negative values, as well as pre-packaged choices for formatting and filtering, including "Top 10," "Bottom 10%," "Text That Contains," and more

Sparklines

Sparklines are thumbnail‐sized charts that permit users to view large volumes of data at a glance, enabling the easy spotting of trends in time‐series data, or trendlines. Data can be expressed in bar, line, or column form. Sparklines are based on the OfficeArt engine, so they are rendered with very high quality and fidelity. They may also be "themed" to adopt specific color sets

Tables

Organize, filter, and format related data with Excel tables. Make managing and analyzing a group of related data easier: you can turn a range of cells into an easily viewed and manipulated Excel table. You can even insert more than one table into a single worksheet

PivotTables

Spend less time sifting through data, and more time analyzing with automatic PivotTables. The popular PivotTable feature distills large sets of data into crisp summaries, and easily shows the cross‐tabular relationships between variables in the data. And in Excel 2011, PivotTables are more compatible with Windows Excel and have been redesigned for ease of use

Visual Basic

In enterprise situations where there is a mix of PCs and Macs, the Visual Basic feature works easily across all platforms. Visual Basic offers new features including IntelliSense and watch windows, as well as the Visual Basic debugging toolbar and new debugging tools

Excel Web App

Post, access, edit, and share your files from virtually anywhere. Excel is now integrated with Windows Live SkyDrive so that your documents can be stored, viewed, edited, and shared in the cloud from any computer with Internet access. Supported browsers include Internet Explorer on Windows, Safari on Windows or Mac, Firefox on Windows or Mac