No longer are you restricted to three conditional formatting rules per cell; the limit now depends only on your available RAM. The archaic editor in prior versions of Excel has been replaced with a larger and more intuitive interface. You can now pick from four predefined conditional formats including data bars, color scales, and special icons , or set the format based on a formula as before. You can also easily rearrange existing rules—a most welcome improvement. You can even include formulas based on data on other worksheets.
To help you format your data for presentation, Excel offers both themes which apply rules to your entire spreadsheet and cell styles which apply styles to cell ranges.
Microsoft's leading spreadsheet and data analysis tool
You can customize these as you wish, and save customized versions for easy reuse. Themes and cell styles are available from the Ribbon via resizable drop-down windows. Improved filters: Excel 's filters are more in line with their Windows counterparts. People who rely on pivot tables will appreciate Excel 's automatic pivot table creation, a new PivotTable Builder to ease building and modification of pivot tables, and pivot table report designs, layouts, and styles. I found both building and manipulating pivot tables to be much simpler in Excel than in the version.
Tables previously known as lists have similarly gotten a full makeover in Excel Creating tables is as simple as selecting your data and choosing a layout from the Ribbon or from the menus. Sorting and filtering in general is better in Excel than in Excel and for Windows. You can create multi-select filter conditions without using custom filters; sort or filter on a font color or cell color; see matches immediately as you create your filter; and utilize built-in filters such as Above Average or Below Average to speed your work.
Excel addresses one of my major complaints about its predecessor: no support for macros. Excel supports some new macro features, such as the ability to set watch points, and it handled all of my existing macro spreadsheets including a complex model containing custom menus and input forms just fine. In addition, Microsoft says that cross-platform macro compatibility with the Windows version of Excel has been improved, although I was unable to test this. While many Mac users may never use macros, their return is good news for power users and those who work in cross-platform environments.
If you share your Excel projects with others, Excel has more to offer than previous versions. Better protection: Excel offers greater flexibility in sheet protection. You can also allow or prevent insertion and deletion of rows and columns, use of filters and sorting, and more. These features match the protection options available in Windows versions of Excel, making for better cross-platform compatibility.
Beyond enhanced worksheet protection, Excel offers full information rights management, which allows users in a corporate environment to specify users and groups of users with rights to a workbook, including restricting who can read, print, forward, edit, or copy its contents. Once you've saved your documents to SkyDrive, you can access and edit them online, from any browser, using the Excel Web App. With the Web application, you can edit your worksheet, and open the modified copy in Excel on your Mac. Multiple people can even edit the spreadsheet at the same time, similar to the way you can collaboratively edit a Google Docs spreadsheet.
In my test of this feature, it worked well enough. The Web version's features are nowhere near as extensive as the desktop version's, but most of the basics are there. Excel uses its own dictionary and thesaurus instead of the OS X-provided tools; Command-A won't select all the text in the formula bar; and, very annoyingly, OS X's Services are still not available. The fact that these features don't work in Excel will be disappointing for those hoping for a fully "Mac like" application.
When you're scrolling large spreadsheets either by clicking and holding on a thumb scroller or by drag-scrolling , the sheet feels like it's moving quite slowly, even on current hardware. In back-to-back comparisons between Excel , , and , the release was easily the slowest of the three—it took over six times as long to scroll through my test document as did Excel Microsoft has told us they slowed the scrolling down due to user complaints about it being too fast.
While it may have been too fast in Excel , it's currently twice as slow as Excel , which seems like an excessive slowdown to me. When you add in the lag-on-window-resize, the Excel interface can feel slow at times. When put to a number-crunching test, however, Excel showed great results.
- rosetta stone version 3.4.5 mac os x dmg.
- show mac keyboard on desktop.
- Software Review;
- Download Microsoft Office for Mac Update from Official Microsoft Download Center;
- Microsoft Excel for Mac 2011;
Using a 15,row by column worksheet containing a mix of slow-to-calculate formulas, Office and each took more than five seconds to recalculate. To me, this is the stronger measure of performance, as it's the one that will most affect the ability to get things done with Excel—not waiting on calculations in large worksheets will be a huge timesaver.
I saw similar results with all the workbooks I tested; they scrolled better in prior versions of Excel, but Excel easily trounced its predecessors in speed of calculation. In addition to my tests, Macworld Lab ran a series of benchmark tests. Those who are switching from Windows to Mac in a work environment will appreciate the new ability to seamlessly transfer your Outlook data from a Windows machine. You'll now be able to import your data files.
Download Microsoft Office for Mac Free
But be aware that you'll only be able to import. PST files from Outlook or later. Some of the strengths of using Outlook in the workplace are the scheduling tools that let you map out your workday. In Outlook for Mac, some helpful new features include the ability to preview your calendar directly from a meeting invitation to see if you're available to attend. A small preview window shows up in the lower right of an invite showing what you have scheduled around that time. You'll also be able to stay on top of your busy schedule with the My Day window that lets you view upcoming appointments.
Both of these features are great time-savers because you won't need to open your full calendar each time you need to check your schedule. PowerPoint Microsoft's PowerPoint is a mainstay for business meetings and now has added features to make it easy to create engaging visual presentations rather than the usual boring bullet points. An improved Presenter view in PowerPoint gives you all the tools you need to pull off a flawless performance.
As your audience watches, you'll be able to view the current slide, see what slide is coming up next, view personal notes for each slide, see the elapsed time for your presentation, and stay on target with a progress bar to show where you are in your presentation. To make your visual projects more portable, you'll now be able to embed movies. In previous versions, you would have needed to include the extra video files when sharing a presentation, but with this new feature, it's easy to deliver your presentation as one complete package.
You'll also be able to apply movie styles and effects by clicking on the video and using the appropriate dynamic tools in the Ribbon, all of which will be retained in your embedded movie when you share your presentation. Better slide transitions and animations in Office for Mac make it easy to create a pro-level presentation with new 3D effects, and a new tab in the Ribbon dedicated to Transitions keep them close at hand for on-the-spot changes.
Microsoft Excel better than ever for Mac
Possibly the best-looking feature of all in PowerPoint is exclusive to the Mac version of Office and very useful for managing complex slides. Now when you create a slide that includes several graphical elements, you'll be able to use Dynamic Reordering to move objects between layers. By choosing Dynamic Reordering in the Arrange menu, you're able to look at graphical elements of your slide in a 3D layered view, allowing you to move elements toward the front or back by clicking and dragging them to your preferred location. These features are available in Word as well, and will be very useful for managing graphically complex newsletters or brochures with several graphical elements.
Finally, to share your presentation with co-workers or clients remotely, PowerPoint includes a new feature called Broadcast Slideshow, which is also exclusive to Office for Mac. Now, as long as you and your target audience have an account with Windows Live, you'll be able to quickly send a URL to up to 50 attendees and run through your presentation all without leaving your desk. Like many of the new features in Office , Broadcast Slideshow makes it easy to get your work in front of clients and colleagues without a lot of extra steps. Excel The venerable software for spreadsheet creation and management received a few major improvements in Office Just like its Windows counterpart, you'll now be able to add Sparklines to your spreadsheet to make your data more visual.
Sparklines are tiny charts that sit in a single spreadsheet cell, making it possible to give a visual representation of your data without needing to refer to a separate chart. With only a few clicks, you'll be able to add a Sparkline, and then browse through several different visual styles to give your spreadsheet the exact look you want.
It's important to note that Sparklines will only be available to those who have the latest versions of Office for both Windows and Mac, so you'll need to know in advance what version of Office your clients have available. In keeping with making your projects more visual in Office for Mac, Excel now offers conditional formatting tools to make your spreadsheets easier to understand, and not just a wall of data. Now, you'll be able to browse through icon sets to show trends over time and display data bars that make percentage increases or decreases more visual and easy to understand right in the spreadsheet.
There are more than 40 built-in formats to choose from, but even if you can't find what you need, you can create your own. You also will spend less time creating rules for cells with new built-in quick-select rules. A new Manage Rules dialog box makes it easy to quickly modify or change rules so you'll spend less time dealing with complex formulas. Word When you need to do some writing, whether it's for a newsletter, a brochure, or a slick-looking resume, Word now has a number of features to help you get your project done quickly.
By using the aforementioned Template Gallery as a starting point, you'll be able to browse through thousands of premade forms, letters, and layouts to get the right template to fit your needs. A new publishing layout view in Word makes arranging elements of your document much easier, with drag-and-drop functionality that automatically causes your text to wrap around objects you import. Dynamic guides appear automatically when you need them, or you can keep specific guides on the desktop while you work for easy access.
You'll also now be able to manage formatting using a new Visual Styles pane. Helpful for keeping formatting consistent, the Visual Styles pane shows where in your document specific styles are applied using a handy numbered and color-coded system. This is a major improvement over previous versions that often had users struggling to figure out which parts of the document included specific styles. Now style changes in documents are laid out in front of you.
One of our favorite features for keeping focused on your work is the new Full Screen View. With this new Mac-exclusive feature, you'll be able to write or read without distractions, blocking out everything but the specific tools you need. You also can customize your workspace with a large selection of backgrounds and page-turning effects when in reading view. There have been third-party full-screen reading solutions before now, but having the option for a distraction-free workspace within Word is a welcome addition. Office Web apps and co-authoring One of the biggest additions to Office for Windows was the addition of Web apps that let you work on the go.
With Office for Mac, you'll now be able to easily take your work with you as long as you have an Internet connection.
You can save your Word, PowerPoint, and Excel files online, then access them from anywhere--even with proper formatting--and you'll be able to use a slimmed-down, but familiar Office-like feature set. Best of all, it's easy to switch back and forth between your desktop and Web versions of your work.
Download Microsoft Office for Mac - Best Software & Apps
You can create your document on your desktop, for example, then save it to the cloud via Windows Live SkyDrive or SharePoint , then make small edits on the road via the Web apps, and then open them again on your desktop to continue editing. What sets these apps apart from Google Docs and other services is that your documents and spreadsheets retain their formatting, giving Office 's Web apps a leg up against online counterparts.
- Publisher's Description.
- running mac os on pc laptop.
- Microsoft Excel for Mac | Macworld?
- scriptina pro font for mac free!
- report a problem mac app store?
- open source usenet client mac.
When you need to work on a project with one or more co-workers, new co-authoring in Word and PowerPoint lets you edit the same document or presentation with someone in another location. Once connected, you'll be able to see who is working on the document and you can quickly communicate with them as long as you have Microsoft Messenger 8 installed on your Mac.
Also, with Office 's new co-authoring technology, you won't get locked out of a document when your co-worker goes offline; all of your content is still available so you can continue working. Conclusions Does Office for Mac offer enough to make it worth the upgrade from earlier versions? With all the new features that will save you time from quick image edits within the suite to easy sharing of your work, and much more, Office is a huge improvement over Office New templates and quick access to video- and image-editing tools are welcome additions for those who create visual presentations of their content.
Serious spreadsheet power users will like the new features that tie data together in Excel while making complex data more accessible in the Ribbon and more exciting visually with Sparklines. Outlook's new conversation-view features for saving time managing your e-mail could save daily e-mail users a lot of time, if they're willing to learn the ropes initially. With it's return in Office , the Ribbon is clearly the preferred method across the entire suite for getting to features quickly. If you didn't like the Ribbon in Office , you probably won't like it now, but we think there's plenty of utility in having a common interface tool across all the apps.
If you're still not convinced the Ribbon is worth your time, you can turn it off easily and use familiar drop-downs and palettes. The new Web apps and co-authoring features make Office a bit better than Google Docs solutions, letting you easily retain your original formatting and providing an easy way to switch from online to desktop with only a couple of clicks.
Office is a worthy upgrade for those who desire new templates and visual styles, better ways of editing multimedia content in publications and presentations, and easier methods of collaboration. The ability to work from anywhere with the new Web apps is surely a big reason to upgrade if your job requires that kind of flexibility. Share files with confidence knowing that the documents you create using Office on your Mac will look the same and work seamlessly when opened in Office for Windows. Co-authoring allows you to save time and simplify your work by allowing you to edit the same Word document or PowerPoint presentation at the same time as others in different locations who are using Office on a Mac or Office on Windows.
Office Web Apps allow you to get things done when and where you want, from virtually any computer with an Internet connection. Sparklines visually summarizes your data using tiny charts that fit within a cell near its corresponding values. Publishing Layout view combines a desktop publishing environment with familiar Word features, giving you a customized workspace designed to simplify complex layouts.
Picture Editing gives you tools throughout the suite to crop, recolor, remove background and compress photos within your document. Charts and SmartArt gives you dozens of SmartArt layouts from more than diagram layouts, ranging from organization charts to lists, processes and relationship diagrams. Dynamic Reorder helps you simplify complex layouts. Get an instant, 3-D view of all layers on your Publishing Layout view page and PowerPoint presentation.
The new ribbon creates an intuitive experience for the Mac user. Familiar Office for Mac tools are still available so you can take advantage of the new ribbon without reinventing the wheel.
Download Microsoft Office for Mac 2011 14.5.5 Update from Official Microsoft Download Center
Template Galleries give you easy, organized access to a wide range of online and custom templates and recently opened documents. You can also access movies and iMovie projects right from the Movies tab. Rich presence and on-the-spot communication lets you instantly connect with your contacts without leaving your work.
Presence and communication are available while editing documents with others. MS Office is not for me. It's expensive and has extremely poor support for non proprietary file formats like OpenDocumentFormat. LibreOffice does all I need. It's more buggy, but it's slowly evolving and becoming more reliable. But Outlook is absolutely refusing to open the main window, whatever I do. Without that, I can't even export everything to Mail! Has anyone any ideas? Read reply 1.
Happened to me too, twice. Only way I got back was to erase my accounts and set time up again. Then everything was fine I love this Microsoft product, it's the best ever with all its tools. Don't know I would live without. Expands PDF files to make them approx. I also had compatibility issues, because the first one I bought was supporting PowerPC applications, which my Mac does not so I had to get a refund and get another one.
Other than that, and PDF issues, Office is a well rounded software. This is the standard word processing program. You must use it or be unable to function with the rest of the English speaking world. There is no use complaining about something that cannot be changed. Whoever wrote this part of the program does not know grammar. My latest complaint is that the use of possessives before gerunds is marked as an error. This is not an error. This is the way it should be. The user must know grammar, not rely on the checker. I do feel sorry for writers who do not know grammar On line help is also bad.
There are many problems for which there is no help. I don't think Microsoft cares whether or not the product is perfect.