In the search field, click the magnifying glass, and then click Advanced Search, and then on the Look in pop-up menu, click Formulas, Values, or Comments. Search for case-sensitive content In the search field, click the magnifying glass, and then click Advanced Search, and then select the Match case check box. Sep 2, 2015 - Microsoft's spreadsheet app is more friendly to general Mac users, but less friendly to power users.
Microsoft Office remains the gold standard of productivity suites, but there are several different versions/editions of Office available for users of Apple hardware. Together with and, the Apple user can access just about any of these versions/editions on each of their hardware platforms.
While Microsoft produces all of these suites and the suites have a very high degree of similar functionality and visual fidelity, they are not identical, and no single suite has all the features of the entire group. This blog post will enumerate most of the differences between the following suites and their apps:. Office 2016 for Windows (“WinOffice 2016”). Office 2016 for Mac (“MacOffice 2016”).
Office 2013 for Windows (“WinOffice 2013”). Office 2011 for Mac (“MacOffice 2011”). Office for iPad (“iPad Office”) The vast bulk of the content in this post is in the following five tables, which list the differences I found.
Note that because the tables lists differences, no row of the table will be all checkmarks (since this would mean that all the suites had this feature, and thus this wasn’t a difference) nor will any row be all “X”s (since this would mean that no suite had this feature, and thus it isn’t a difference either). I am listing the differences because listing the similarities would take much too much room—the suites are that identical.
Hopefully, this will assist you in choosing the best version/edition for your use. In addition, I will describe my personal Office setup.
Here are the five tables ( click on each thumbnail for an enlarged view): Table 1: Suite-wide differences. Figure 1: Arabic text in iPad Word on iPad Pro No multiple selection support in iPad PowerPoint: All Office programs provide some way to select content in a document (text, cells, or shapes, for example). This is needed so that the user can apply some operation on just that content (change the color, for example). The Windows or Mac Office applications also provide for “advanced” types of selections. In Word, this is non-contiguous text selections; in Excel this is non-contiguous cell selections; and in PowerPoint this is the simultaneous selection of multiple objects. In Word and Excel, these really are advanced types of selections that are rarely needed by even sophisticated users of Word or Excel.
(See Figures 2 and 3.). Figure 4: Multiple selections in MacPowerPoint 2011. I wasn’t surprised to learn that non-contiguous selections were not supported in iPad Word or iPad Excel, but I was astonished and very disappointed to learn that multiple selections were not supported in iPad PowerPoint.
My Use of Office So, which do I use? The short answer is that I use all of them.
I worked on the MacOffice team at Microsoft for several years, and at that time I also worked closely with colleagues on the WinOffice teams. Because of this background, I am often able to pick just the right Office app that will make a given task the easiest to do. One task might be particularly well suited to MacWord 2011 because Publishing Layout View—a feature only in that one Word version—will make this task easy. Another task might be suited to WinPPT because of the Animation Painter, which is not in any MacPPT version. Yet another task might be best suited to WinPPT 2013 because it needs an Office extension not available in other Office suites. Having all the versions of Office at your fingertips used to be rather hard to setup, not to mention very expensive.
Luckily, that is no longer the case. With a single, you get five installs of the Office suite and you can pick which versions make up this set of five. Since I have on my Mac, I can run any version of Windows without rebooting. Because I have different versions of Windows running on my Mac, I can also run different versions of WinOffice on my Mac and have everything I need on one computer.
(You can ) Here’s my setup:. MacOffice 2011 is my main productivity suite and is installed on my El Capitan MacBook Pro. MacOutlook 2016 came out long before the entire MacOffice 2016 suite, and because of the vastly improved performance of MacOutlook 2016, I use it as my main email client, instead of MacOutlook 2011. WinOffice 2013 is installed in a Windows 7 virtual machine (VM) (under Parallels Desktop for Mac Pro Edition) on my MacBook Pro. iPad Office is installed on my iPad. As you saw in the tables above, iPad Office is lacking many of the features of WinOffice and MacOffice, so I also have on my iPad which lets me access and run the full featured versions of any Office suite (or any other application) on my computers and use them with natural iPad gestures.
(You can download a free trial of Parallels Access for iOS and Android to access your Mac and/or PC at ). MacOffice 2016 is installed in an El Capitan VM (under Parallels Desktop for Mac Pro Edition) on my MacBook Pro. WinOffice 2016 is installed in a Windows 10 VM (under Parallels Desktop for Mac Pro Edition) on my MacBook Pro.
So, why don’t I use MacOffice 2016 as my main productivity suite? Four reasons:. Only MacWord 2011 has Publishing Layout View, a feature I depend on heavily and consider essential. To me, MacOffice 2016 has a kind of cartoon-like look to the user interface that just doesn’t appeal to me. There was no compelling feature pulling me to MacOffice 2016, and.
Inertia was keeping me in MacOffice 2011. Those are my five installs, and with this setup, I have easy and immediate access to the best Office app for any particular task. I tend to store all my documents on so that I have easy access to them from any of my Office suites or Apple platforms. Which Office suite(s) do you use, and what’s your setup? Need Microsoft Windows operating system? Buy directly below: Interested in running Microsoft Office on your Mac?
14 day free trial of Parallels Desktop for Mac.
After a long, long wait, the 2016 version of Microsoft Excel has finally arrived on. Like the latest version of, Excel is available now to Microsoft Office 365 subscribers and will be coming later this month as a one-time purchase.
The latest version of the popular spreadsheet application delivers a long list of new features including support for Retina Display, a streamlined user interface, full-screen view, and multitouch gestures. But that's only scratching the surface of what individual components like Excel 2016 have to offer, which is why we've compiled this gallery of six ways to improve your spreadsheet experience while learning a few tricks at the same time. Prev Page 1 of 7 Next Prev Page 1 of 7 Next Windows keyboard shortcuts.
The dual-platform nature of Office 365 means some users will be required to jump between Windows (for work) and Mac (for home) — an experience that has been quite exasperating over the years when it comes to keyboard shortcuts. The good news is Excel 2016 has brought some sanity to this dilemma at long last, with many shortcuts that require the Windows CTRL modifier key now working the same way on the Mac. Most common functions like cut, copy, paste, undo, redo, and save also retain the equivalent Command key shortcut as well. Microsoft has a full list of Excel 2016 keyboard shortcuts on its, should you need a refresher. Prev Page 2 of 7 Next Prev Page 2 of 7 Next Formula Builder to the rescue.
Those who use Excel day in and day out certainly don't need hand-holding when it comes to crunching numbers. For the rest of us, Excel 2016 introduces Formula Builder, a new feature that helps novice users overcome daring financial acrobatics with the greatest of ease. A click on Shift-F3 calls up this handy option, which offers the complete range of formulas, along with the kind of hand-holding novices need to overcome their unnatural fear of mathematical computations. Prev Page 3 of 7 Next Prev Page 3 of 7 Next Charts made simple. Converting a spreadsheet to a chart hasn't always been the most simple or intuitive task, even in an application as powerful as Excel. That's why Microsoft added a new Recommended Charts feature to Excel 2016, which assists in the process by offering suggestions for a chart based upon the data selected in the worksheet. To use it, click the Insert option on the Ribbon, highlight the data to be included, and click the Recommended Charts button; a drop-down menu serves up one or more samples of the chart Excel will create for you in just a click.
From there, the chart is added to the spreadsheet for the user to do as they wish with it. Prev Page 4 of 7 Next Prev Page 4 of 7 Next Slice those PivotTables. We're not hardcore number crunchers that use PivotTables on a daily basis, but if we were, we'd probably be dancing on the ceiling over Excel 2016's new slicer tool. Now PivotTables can be set up with options to limit the type of data being viewed — for example, only displaying relevant data from specific years, category, or just about any other way you desire. This new feature can be initiated by clicking the Insert Slicer option when using PivotTable Analyze mode on the Ribbon. Prev Page 5 of 7 Next Prev Page 5 of 7 Next Analyze this.
Most Excel users won't have a huge volume of data in any given spreadsheet, but those in the engineering or academic fields are another story entirely. Microsoft has come to their aid with an optional Analysis ToolPak, which can be enabled in Excel 2016 for Mac by heading to the Tools Add-Ins menu, selecting the Analysis ToolPak option, and clicking OK. Doing so will add a new Data Analysis feature to the Tools menu, and from there you can scrutinize massive sets of data in a wide variety of different ways. Prev Page 6 of 7 Next Prev Page 6 of 7 Next Clean or green. You've seen the screenshots and may have wondered, 'Why does their Excel 2016 window have a green header and mine is plain white?' Glad you asked. New to all Office 2016 applications is the ability to select themes, which can be found by navigating to the Excel Preferences menu and clicking General.
![Creating a gantt chart in excel 2016 for mac Creating a gantt chart in excel 2016 for mac](http://www.customguide.com/wp-content/uploads/2015/10/interactive-training-excel-2016-mac.png)
At the bottom Personalize section, you'll see a pulldown menu for Office theme, which is probably set to Classic by default. Select Colorful instead, and a pop-up will appear reminding you this choice applies to all Office apps; click OK and bask in the warm glow of forest pine green for Excel. Prev Page 7 of 7 Next Prev Page 7 of 7 Next.