PivotTables in Excel 2011 are in many ways like those in Excel 2010, but the Mac version does not support all of the high-end features—including Slicers or built-in database connectivity—found. Slicers are NOT available in 2011 for Mac. The workaround is to use the Excel WebApp, which is available to all users for free on OneDrive (formerly SkyDrive). Excel 2011 is the latest version for Mac. A couple of weeks ago, we what you wanted to know about Office 2011, the latest update to Microsoft's venerable software suite. (It goes.) Based on our own research and consultations with Microsoft, here are answers to your questions about ( ); stay tuned for our answers about the suite's other apps. Interface Can all Excel 2011 commands be accessed by menu options (in addition to buttons, the Ribbon, and so forth)? Yes, the menus work just as they did in Excel 2008. Can I set the menus and Ribbons in Excel 2011 so they’re the same as in Excel 2007 for Windows? Although the user interface is similar on both platforms, they are a bit different, so you won’t be able to make Excel 2011 look and feel exactly the same as Excel 2007. Did Microsoft add menu-item shortcuts to Excel for Mac like the ones that are in Excel for Windows? Microsoft added some menu-item shortcuts similar to what you get in Excel for Windows. However, as the Mac and Windows operating systems differ, there are some differences in the shortcuts. Does pressing the slash key (/) in Excel 2011 jump the focus up to the menu bar, as it does in the Windows version? The Mac version used to do this; it was nice to not have to reach for the mouse. No, that is not supported in Excel 2011. In a workbook with multiple tabs, can you color each tab individually? You could do it in Excel X and 2003, but not since. Yes, you can color tabs individually. Did Microsoft bring back the ability to see (and manipulate) page breaks in a page-break view? Yes, you can see and change page breaks in the Page Layout view. Are there pencil-and-eraser tools for selecting borders? (I didn’t see them in the beta versions.) No, Excel 2011 doesn’t have this feature. Overwatch for mac download. The Macbook's and Macbook Air's, sure. 13' Macbook Pro should do fine in theory, and 15' is guaranteed to work. Anything above that (ie. Mac Pro and newer iMac models) should easily manage the game. Overwatch is a pretty game, but it's hardly graphically intensive. ![]() ![]() Interoperability There’s been an inconsistency between the ways the Mac and Windows versions of Excel have managed dates (the 1900 versus 1904 problem). Has that been solved? New workbooks in Excel 2011 now automatically default to the 1900 date system, as they do in the Excel 2010 for Windows. Can I exchange spreadsheets freely with colleagues who use the Windows 2007 version? Yes, Excel 2011 files are compatible with Excel 2007. Does Excel 2011 for Mac support macros created with Excel 2007 for Windows? Will data files created by Excel X be compatible with Excel 2011, and vice versa? If you use the free, you can open documents saved in Excel 2011’s default file format in Excel X or later. VBA and AppleScript Is the version of Visual Basic for Applications (VBA) in Excel 2011 different from the one that worked with Excel 2004? There are two major differences between the two: First, Microsoft ported the Windows Office VBA environment to the Mac. The engine was upgraded from VBA 6 to VBA 6.5. The company also enabled some functions—such as FormatCurrency, FormatNumber, and Replace—that had been disabled in Office 2004. Second, whenever it was possible and made sense, Microsoft aligned the object models in Office 2011 with those used in Office 2010 for Windows. The company says that should result in much better compatibility across the two platforms. Is the VBA in Excel 2011 compatible with the version in Office 2004? Is the Solver integrated into Excel now that VBA is back?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |