Microsoft Office for Mac Quick Start Guides

Microsoft Office Downloadable Guides – Mac version

Even though Apple’s iWork productivity suite is free and full featured.  many users still rely upon om Microsoft Office for their Business and School Applications. I recently ran across some handy Quick Start Guides for the Mac Versions of the Microsoft Office Suite that I wanted to share. These are great resources if you use office on a regular basis. Just click on the Image or link to download the guides.

 

Images and guides coutesty of Microsoft. Microsoft Office, Microsoft Excel , Microsoft Word, Microsoft Oultook, Microsoft OneNote, aand Microsoft PowerPoint are trademarks of Microsoft.

Collaborate with Colleagues in Pages, Numbers, and Keynote

We talked last month generally about real-time collaboration and why it’s so efficient and effective—see “Stop Mailing Files Around and Use Collaborative Apps.” Now we’re going to explain how to start collaborating in Apple’s iWork suite of apps: Pages, Numbers, and Keynote. Happily, the basics are similar in all three apps.

We’ll focus on the Mac versions here (make sure you have the latest updates!), but note that the iOS versions can participate as full-fledged collaboration citizens (Apple has more details). It’s even possible to use the iCloud versions of these apps for collaboration, but with some limitations (notably that Pages documents with tracked changes can only be viewed, not edited, in iCloud).

Invite Collaborators

Once you have a document you want to share, the first step is to invite your collaborators. Choose Share > Collaborate with Others, or click the Collaborate button in the toolbar.

The document must be stored in iCloud Drive (or the Box file sharing service), and the iWork apps will automatically move the file there if need be. To find the file later, choose Go > iCloud Drive in the Finder and look in the folder associated with the app you’re using.

Next, the app displays the Add People dialog, where you can choose with whom you’re going to share the document, how to send the invitation, and what permissions to set.

The Share Options are important. First, you can limit access to “Only people you invite” or “Anyone with the link.” With the former, the invitees must have iCloud accounts and be signed in. With the latter, you can share with anyone, even if they don’t use Apple devices.

Second, with the Permission menu, you can let collaborators make changes, or if you want them just to see the document, you can restrict them to View Only.

When you’re done, click Share to send the iCloud link via the specified channel (or copy it to the clipboard for sending in whatever way you prefer).

Accept an Invitation

When the recipient clicks the link or clicks Accept in a sharing notification, they get a dialog asking to open the document and telling them where it’s stored, in case they don’t want to work on it right away.

When they open the document, it will look and feel exactly like a normal document in Pages, Numbers, or Keynote.

For someone who isn’t an Apple user, clicking the iCloud URL will open the document in the Web version of the appropriate app on iCloud.com. They’ll need to enter a name to identify them in the document, after which they can work in the Web app.

Add and Change Data

For the most part, you can do anything in a shared document that you can do with a normal document. There a few general limitations, such as managing styles and working with media files over 50 MB, plus some app-specific restrictions, such as working with tables of contents in Pages, transposing tables in Numbers, and changing themes in Keynote. Apple has a full list.

While you’re working, you can see who else is in the document at the same time by clicking the Collaborate button and looking for a colored dot next to a person’s name.

You’ll see color-coded cursors, text, and object selections as other people work, but if that’s distracting, choose View > Hide Collaboration Activity.

It can be hard to be work in a document while seeing someone else making changes, so don’t be shy about hiding collaboration activity. Or, if you are actively working with someone on a particular part of the document, consider doing so while you can talk in person or on the phone.

Add Comments

Commenting is the big win for collaboration with remote colleagues—it can save a vast amount of time to discuss a particular aspect of a document in context. To add a comment, select some text or an object, and then choose Insert > Comment or click the Comment button on the toolbar. (The controls look a bit different in iOS; Apple explains the differences.)

Comments appear as color-coded selections, boxes, or in the case of Numbers, corner triangles in cells. If they’re in the way, you can hide them by choosing View > Comments > Hide Comments. Other commands in View > Comments let you easily navigate to next and previous comments so you don’t have to find them visually.

Other collaborators can click Reply to continue the conversation right within that comment. You can edit one of your comments at any time by clicking to the right of the timestamp and choosing Edit Comment (or Edit Reply). Once the discussion has been resolved, either the person who started the comment thread or the document owner can delete the comment thread by clicking Delete.

Track Changes

Tracking who made what changes to a document is available only in Pages, and it’s hugely helpful when you need editing. Only the document owner can enable the feature by choosing Edit > Track Changes, but once that’s done, the change tracking toolbar appears above the document with controls for navigating between comments and changes, buttons for accepting or rejecting changes, and a button for pausing change tracking. A pop-up menu at the right side lets you configure whether you want to see all changes, changes other than deletions (which is generally the best setting), or what the document will look like in the end. A left-hand sidebar lists all comments and changes—show it by choosing View > Show Comments & Changes Pane.

Anyone with edit access can accept or reject any particular change by clicking Accept or Reject in the Comments & Changes pane; you can also use the buttons in the change tracking toolbar to navigate from change to change, accepting and rejecting as you go. If there’s no need to deal with each change individually, use the pop-up menu’s commands to accept or reject all changes.

Needless to say, you can work on shared documents only when you’re online when you’re using the Mac or iOS version of an iWork app (if you try to edit while offline, the app will only let you edit a copy that is no longer shared). With any iCloud.com documents that you already have open, however, you can work offline, but your changes won’t appear to others until you reconnect.

When you’re done collaborating on a document, click the Collaborate button in the toolbar and then Stop Sharing (below left). Doing so immediately prevents others from making more changes and deletes the document from iCloud Drive on their devices (below right).

Simultaneous collaboration is wonderful when you’re working intensely with other people to develop a presentation, brainstorm budget estimates, or wordsmith a mission statement. In such situations, you’ll want to be able to talk at the same time. But for other sorts of projects, it’s also useful to allow people to collaborate when it’s convenient for them—the important thing is that everyone is working in the same document and can see each other’s changes and comments. If you rely on Apple’s iWork app for word processing, spreadsheets, or presentations, give their collaboration features a try!

Stop Mailing Files Around and Use Collaborative Apps

Have you ever emailed a document to several colleagues for feedback, and then had to go through each of their changes in turn, merging everything into your master document? What if one of them needs to see the changes that another suggested? Plus, what if you need to make substantial changes after you’ve sent the document out for review, but before you’ve heard back from everyone?

If you’re still doing this document dance, it’s time to quickstep into the modern world and try the real-time collaboration features that are built into many apps, including Apple’s iWork apps (Pages, Numbers, and Keynote), the Microsoft Office 365 suite (Word, Excel, and PowerPoint), and Google’s online app suite (Google Docs, Google Sheets, and Google Slides).

Let’s look at why real-time collaboration is the most efficient and productive solution for working with colleagues.

One Document to Rule Them All

In the old model of collaboration, where you gave each person their own copy of the document, you had to bring their changes and comments back into your master copy. That’s clumsy, time-consuming, and error-prone, even when the apps in question have features for merging.

With modern collaboration systems, there is only one document that everyone works on, so there’s no need to keep track of different copies or merge changes. Plus, you never have to worry about someone’s copy getting corrupted or lost.

Work Simultaneously or Sequentially

In many collaborative scenarios, the people with whom you’re working need to be aware of what the others are doing. Theoretically, you could send your document to one person, get it back, send to the next, get it back, and so on. That way each person sees the changes and comments from those who have gone before, but it takes a lot of time and coordination effort.

But in a real-time collaboration system with a single document, everyone can work at the same time. That’s not to say they will, but even after Alice has taken her primary pass and Bob and Carmen have added more changes and comments, Alice can dip in again to see and react to what they did, assuming they had track changes enabled. It’s a much faster way to resolve differing opinions on a document’s wording or a slide’s appearance.

Some collaboration systems also feature a revision history, which lets you go back in time and see what each person has done at different points. That can be helpful if the app wasn’t set to track changes when a collaborator made some edits.

Have In-Document Conversations

“Collaboration” generally takes two forms: changing information in the document and commenting on it. For instance, if you’re collaborating on a budget spreadsheet with colleagues, each person can add or update the information about annual expenses for their department, saving you the trouble of collecting and entering that information. And if someone makes a mistake, it’s easy for another person to correct it. Collaboration systems generally identify the person who makes each change, so Alice knows that Bob added his department’s expenses and Carmen updated all the dates to the current year.

Equally useful are comments, which you can generally attach to one or more words on a document or presentation, or a cell in a spreadsheet. Also, in many systems, a change or comment can be the start of a conversation much like in Messages, where each person gets to weigh in and the conversation stays tied to that change or comment.

Invite Multiple Types of Collaborators

A key feature of most collaboration systems is that people can take on different roles. There are generally three levels of access—view, comment, and edit—and you can invite any given person to a particular role. So you might ask Alice to proofread your document and give her edit access, while you ask Bob and Carmen merely to add comments. And if you need to show the document to Deepak (but you don’t want to let him even comment), you could invite him with just view permissions.

There’s one implicit role here—you as the document’s owner. Someone with edit access can generally make the same changes you can, but it’s always best to have one person who’s in charge of accepting or rejecting changes and resolving differences. That person might even change occasionally, but you should always make clear what you expect others to do at what point. For instance, if you’re an author collaborating with an editor, you should deal with your editor’s changes, and your editor should accept your subsequent edits.

You’re probably already using apps that can be used for real-time collaboration, so if you’d like help figuring out the best way to get started, get in touch.

Apple debuts New iPad with Apple Pencil Support, Updates iWork

At a special education event on March 27th, Apple introduced a new 9.7-inch iPad that offers faster performance, support for the Apple Pencil, and a few new camera-related features. The company also released new versions of the iWork apps—Pages, Numbers, and Keynote—that let users draw, sketch, and write with the Apple Pencil.

Sixth-generation iPad

For the most part, the new sixth-generation iPad is the same as the fifth-generation model it replaces. Its physical dimensions are unchanged, so existing cases and accessories should continue to work. It comes in the same three colors: silver, gold, and space gray. Even the pricing and options remain the same, with a 32 GB model starting at $329—the jump to 128 GB adds $100, and cellular capabilities add $130.

What sets the sixth-generation iPad apart from its predecessor is its support for the Apple Pencil stylus, which was previously restricted to the iPad Pro line, which started at $649. Thanks to a high-resolution touch sensor in the iPad’s Retina screen and palm-rejection technology, you can now use the $99 Apple Pencil in compatible apps. As with the iPad Pro, the Apple Pencil is sensitive to pressure and tilt so you can vary line weight and shading, much as with a traditional pencil.

Also new in the sixth-generation iPad is Apple’s A10 Fusion chip, with its embedded M10 coprocessor. The company claims that the new processors provide up to 40-percent faster CPU and 50-percent faster graphics performance.

The extra performance may also be related to the iPad’s new camera capabilities. Unlike the previous iPad, the sixth-generation iPad can take Live Photos and supports body detection in images along with the previously supported face detection. Also new is support for the Retina Flash feature that turns the screen into a giant flash when taking selfies.

iWork with Apple Pencil Support

If you haven’t been using Pages, Numbers, and Keynote on the iPad, the latest updates may encourage you to try Apple’s iWork apps—remember, they’re available for free in the App Store. Notably, the three apps allow you to draw, sketch, and write directly within documents. Even more interesting, though, is Apple’s Smart Annotations feature, currently in beta. With it, your comments and proofing marks anchor dynamically to text, and stay with the text they were attached to even as the document changes.

Smart Annotations are particularly welcome for those who take advantage of the real-time collaboration features built into the iWork apps. This was an education event, and it’s clear that Apple is building tools that will allow teachers to mark up and comment on student documents. But the same capabilities are equally as useful in the business world. For business users, Apple also announced that the real-time collaboration features in the iWork apps now work on documents stored in the Box file sharing service. Previously they were available only for documents stored in iCloud, which has little adoption in the enterprise.

Finally, the iPad version of Pages gains features that help users create ebooks in EPUB format. And Apple added a new Presenter mode to Pages, which lets you turn your iPhone or iPad into a teleprompter for distraction-free reading.

In the end, if you’re interested in using the Apple Pencil, the combination of the sixth-generation iPad and the updated iWork apps will let you do more for over $300 less than before.