As a word processing tool, Word 2016—which, at present, is only available as part of an Office 365 subscription—hasn’t changed much since its last major release as Word for Mac 2011. I also find Pages and Keynote less complicated and easier to use than Word and PowerPoint, and I have used all of those programs a lot. I use Keynote for our monthly staff meetings and I use Pages for all the marketing materials for my family's restaurant. With Pages for the Mac you can create both page layout type documents and word processing documents. See what the difference is between these types of documents in this Tutor Tip. This Tutor Tip is part of Tutor for OS X Pages. Pages (and Excel vs. Numbers / PowerPoint vs. Keynote) comparison reminds me of the Pepsi Challenge. Blind testers frequently prefer the sweeter, less-harsh flavor of Pepsi vs.

. Pros Visually dazzling themes. Spacious and easy interface. Apple's graphics tools provide high-tech functions (like transparent backgrounds for inserted pictures) with one-click ease. Can switch between conventional word processor chip mode and page-layout mode. Smooth transfer and export of Microsoft Phrase documents. Negatives Can't change the root template for a document.

No match for Microsoft Word in advanced features like footnotes ánd endnotes in thé exact same record; no research/replace for text message attributes like italic. Lacks draft view to display text message without displaying web page headers and footérs. No buiIt-in mail merge. Does not have accessibility to sophisticated typographic functions in OS Times.

Hi, I have MS Excel 2016 V 15.22 in my MAC PC. But when I got to Data, External Data, I dont see the option 'From Web'. How can i import data (for instance stock prices) from Web into my excel sheet in this version of excel. The Data tab in Excel 2016 for Mac. A better way to work with external data connections. One of the biggest improvements to working with external data connections in Excel for Windows in recent releases has been the Connection Manager. Excel get data from access.

Can't set Term file format as default for saving. Bottom Series Pages offers the easiest-to-use interface of any innovative word processor chip, and is usually all that numerous Macintosh and iOS customers will ever need.

But it doesn't technique Microsoft Term in sophisticated format and automation features. The initial hint that Apple's Web pages isn't a conventional word developing app is definitely its name. You can make use of it to make school essays, letters, actually books, just as you do in Microsoft Phrase or the opén-sourcé, but its actual strength can be in producing the best-Iooking pages you'vé actually published or rescued in digital forms like ePub ór PDF-though thé present version also has some amazing design restrictions that weren'capital t in the version that Apple shipped six yrs back. Whether you prefer Pages to Microsoft Word or LibreOffice-or an costly high-end web page design app like Adobe's i9000 InDesign-depends ón what you would like out of it. For the huge bulk of Mac pc users, Web pages is all the word processor chip you need, and offers the benefit of easy file-sharing with Web pages for iOS and with online storage. Webpages is component of the iWork package that furthermore consists of the spreadsheet app and presentations app. All three talk about the exact same abilities to edit text, create furniture, and transfer images, though each app offers additional features ideal for papers, worksheets, and presentations.

All three apps can be found in three various versions: one for Operating-system A (evaluated here), a somewhat feature-reduced edition for iOS, and another somewhat feature-reduced Web-based version accessible at iCloud.com. Starting in February 2015, Apple made the Web-based version available free to anyone with a (free of charge) Apple ID, even if you don't have got an Apple computer or gadget.

Design As you'd expect from Apple, all three apps ship with visually stunning style layouts, and Pages comes with a gaIlery that you cán make use of as the foundation for your personal flyers, pamphlets, certificates, postcards, newsletters, letters, reports, and pamphlets. Apple's style skills prolong to the deepest degree of the apps, delivering sophisticated built-in styles for text, tables, graphs, and forms. Disappointingly, you can't transformation the general look of a Pages document by altering its template after you've created the record. Unlike Microsoft Term or LibreOffice, whére you can alter the root 'theme' of a record, Pages just lets you adjust individual text message styles, not really the underlying template that contains the styles. What'h slightly perplexing about Web pages' absence of support for replaceable designs will be that the root technology has always been recently part of Keynote, whére you can alter all the styles of a display with a simple change of style. Document Creation Pages is definitely the just full-featured web page design app that permits you create documents in two different modes-a traditional word handling setting and a 'page design' mode. Both modes allow you insert pictures, furniture, and other design components in inclusion to text message, but they handle text entirely in a different way.

In Webpages' conventional word handling setting, as in all various other word developing apps, when you complete keying in the very first page of text, the text message instantly overflows to the next web page and after that the page after that. In page layout setting, each web page can consist of one or even more text containers, but all text is encased in its personal text container, is limited to the web page that consists of the package, and can't movement from one page to another. However, unlike Web pages' word handling setting, you can move entire pages forwards or backward in a document, so that the page you produced as page 3 right now becomes page 2. This is certainly an perfect feature when designing (for illustration) a newsletter, a menu, or any folding leaflet where you wish to choose what shows up on the outdoors or within. User interface Like the other iWorks apps, Webpages has a spacious easy-to-use screen design, with a switch for switching on brightly-colored display screen guidelines that guideline beginners through basic operations. Optional sidebars at the still left and right give simple accessibility to various types of handles.

The sidebar on the still left displays page thumbnails or remarks or both. Thé sidebar on thé correct acts as an Inspector -panel that regulates document design and format for text, pictures, and some other mass media. Like a traditional Inspector panel, it shows different options based on what type of page element is usually currently selected-text choices for text, image choices for images. But unlike a typically cramped and staged Inspector cell, Pages provides a roomy panel that's easy to navigate and recognize. I use Webpages to develop terrific-looking single-page records like certificates and one-óf-a-kind present cards, and published letters. But for any document longer than a web page or two, I prefer Microsoft Word-either the Operating-system X edition or the Windows version running in VMware Blend or Parallels Desktop-because Term provides me an option to use an editing window that doesn'capital t exactly replicate a imprinted or PDF web page. When I'm composing a paragraph that occurs to begin on the last collection or two of web page, I don't need to end up being capable to notice the paragraph as a entire, not damaged in the center with the bottom part margin of one web page, the top perimeter of the following page, and any page amount or text that might be in the web page header or footer.

Microsoft Phrase and LibreOffice provide me a 'draft see' option that hides page fractures and most formatting, and Word for Windows has the best option of all-a see that enables me edit pages with the exact same format they will have got in print out ór PDF, but without thé page headers and footers visible, just a side to side line displaying a web page break. Phrase Processing Webpages does nearly all of what rivaI word processors perform, and does it with an exceptionally simple and uncluttered interface. Occasionally the user interface is therefore uncluttered that you received't notice essential choices until you appear for them-for instance, you may not really recognize that Pages facilitates endnotes, not really only footnotes, until you generate a footnote and click on the 'Type' choice in the Footnoté inspector panel-thát enables you change footnotes to éndnotes. You cán't, nevertheless, have both footnotes ánd endnotes in thé same record, as you can in Phrase. Web pages' Find-Replace discussion has options to research for whole words and phrases or to match up top- or lower-casé, but, unlike Term, it can't discover inserted web page fractures or particular types like italics ór underlining. You cán develop envelopes from one of the supplied envelope templates, but thére's no buiIt-in Package command word like the one in Word that lets you develop and printing an envelope for the notice that you're composing and save the package as one page of the notice record itself.

You can perform mass messages ('mail blend') with Pages, but you'll need to use the Applescript scripting vocabulary. Apple doesn'capital t record the email merge method, but offers a support page that links to a third-party web site with guidelines. Webpages' various word-count display is usually a small box that annoyingly covers part of the editing and enhancing windows and can'testosterone levels be moved to the sidebars or anywhere else on display. In an Office-centric planet, you need to open up and generate Word paperwork in both.D0C and.DOCX platforms, and Pages does an impressive job. Most Word docs that I opened in Webpages came through the conversion process with all formatting undamaged.

When I ended up saving Pages documents in Word format, Word opened them effortlessly, full with superior functions like remarks. One surprising limitation can be that Webpages can'testosterone levels export a record to HTML format for use in a Web page, though it can move to PDF, ePub, and basic text. Edition History In many ways, the present version of Webpages is certainly a action backward from the edition in an older version of the selection called iWork '09-the final version that had been officially called iWork and delivered on a Dvd movie. Apple will be gradually restoring features that got slipped when it replaced the file format used in iWork '09 with the structure used in the present version, but a several significant features are nevertheless missing. The outdated edition of Web pages, for instance, had a more versatile page-layout mode that let you stream text from a text box on one web page to a package on another, so you could produce booklets with text that carried on the initial page to a later on page.

Also, the previous Pages backed all thé high-end typógraphic functions constructed into OS X, including custom-designed small-capitals (not really normal capitals decreased in dimension) and alternate personas for extravagant fonts like Zapfinó. If you select some text message and press Cmd-T in the present Webpages, you'll open the Operating-system Back button Fonts dialog, where you can click on on the gear in the top still left and access a Typography menu that enables you access the features obtainable in the current font. You can nevertheless gain access to that menus from the fresh version of Webpages, but the choices put on't have got any effect on the text. All these choices are accessible in OS X's TextEdit-which provides an option to function like a little word processor-but not really in Webpages. You can quickly discover an iWork '09 Dvd and blu-ray on eBay fór around ten bucks, and it may become worth getting if you're looking for innovative typography in Web pages, but keep in mind that you'll give up the spacious design and iOS compatibiIity of the present edition. Elegant and Inexpensive You possibly got Pages free with your new Mac, and if you're still using an old Mac pc, you can purchase it for $19.99 on the App Shop.

Either way, it expenses a great deal much less than Office, offers all the energy you need for nearly all word running duties, and features the most stylish and easy-to-maneuver user interface of any word processor chip or web page layout program ever produced. Its major a weakness in the Office-centric globe can be that it doesn't have got an choice to save in Phrase structure by default. If it will the work opportunities you require to perform, and you wear't brain having an additional step to move a document in Term format when you require to talk about it, Pages is usually one of the rare apps than can make work appear like satisfaction.