| Introduction |
|
1 | (4) |
|
|
|
1 | (1) |
|
|
|
2 | (1) |
|
|
|
2 | (1) |
|
|
|
3 | (1) |
|
|
|
3 | (2) |
|
PART 1 INTRODUCTION TO MICROSOFT OFFICE FOR MAC |
|
|
5 | (42) |
|
Chapter 1 Overview from 10,000 Feet |
|
|
7 | (6) |
|
The Many Faces of Office for Mac |
|
|
7 | (2) |
|
|
|
9 | (1) |
|
Getting a Microsoft account |
|
|
9 | (1) |
|
Downloading and installing Office |
|
|
9 | (2) |
|
Keeping Your Apps Up-to-Date |
|
|
11 | (2) |
|
Chapter 2 A Sweet Suite: Introducing the Office Apps |
|
|
13 | (10) |
|
|
|
15 | (1) |
|
|
|
15 | (3) |
|
|
|
18 | (1) |
|
|
|
18 | (1) |
|
|
|
19 | (1) |
|
|
|
19 | (1) |
|
|
|
20 | (1) |
|
|
|
21 | (2) |
|
Chapter 3 Common Features in All Office Apps |
|
|
23 | (24) |
|
Using Menus in Office Apps |
|
|
23 | (2) |
|
Toolbars, Ribbons, and Panes: Think "Visual" Menus |
|
|
25 | (1) |
|
|
|
26 | (1) |
|
|
|
26 | (2) |
|
Panes are anything but a pain |
|
|
28 | (1) |
|
Customizing the Quick Access Toolbar, Ribbon Tabs, and Keyboard Shortcuts |
|
|
29 | (1) |
|
Customize the Quick Access toolbar |
|
|
29 | (1) |
|
Customize ribbon tabs and menus |
|
|
30 | (2) |
|
Creating ribbon tabs and tab groups |
|
|
32 | (1) |
|
Customizing keyboard shortcuts |
|
|
32 | (2) |
|
Creating and Saving Documents |
|
|
34 | (1) |
|
Using the gallery to open templates or recent documents |
|
|
34 | (2) |
|
|
|
36 | (3) |
|
Saving and Using Documents in the Cloud |
|
|
39 | (1) |
|
Saving a file on a OneDrive or SharePoint location |
|
|
40 | (1) |
|
Sharing a file you've saved using OneDrive or SharePoint |
|
|
41 | (1) |
|
Opening a file you've saved on your OneDrive or SharePoint location |
|
|
41 | (1) |
|
Understanding App Preferences |
|
|
42 | (1) |
|
|
|
42 | (1) |
|
|
|
42 | (2) |
|
Help: If's more than just a Beatles movie |
|
|
44 | (2) |
|
Official Microsoft websites |
|
|
46 | (1) |
|
PART 2 MASTERING MICROSOFT WORD |
|
|
47 | (122) |
|
Chapter 4 Getting to Know Microsoft Word |
|
|
49 | (16) |
|
Using a Variety of Versatile Views |
|
|
50 | (1) |
|
|
|
51 | (1) |
|
|
|
51 | (2) |
|
|
|
53 | (1) |
|
|
|
54 | (1) |
|
|
|
54 | (2) |
|
|
|
56 | (1) |
|
|
|
57 | (1) |
|
|
|
58 | (1) |
|
Getting around in Your Document |
|
|
59 | (1) |
|
A scroll new world: Navigating by using the mouse or trackpad |
|
|
59 | (2) |
|
Navigating by using keyboard navigation |
|
|
61 | (4) |
|
Chapter 5 Creating Documents |
|
|
65 | (24) |
|
Adding Text and Graphics to Your Document |
|
|
65 | (1) |
|
Entering text in your document |
|
|
66 | (1) |
|
Inserting an image in your document |
|
|
66 | (5) |
|
Selecting Text for Editing and Formatting |
|
|
71 | (3) |
|
Formatting Text, Paragraphs, and Images |
|
|
74 | (1) |
|
Changing the look of the font |
|
|
74 | (2) |
|
Changing the look of paragraphs |
|
|
76 | (3) |
|
Changing the look of images |
|
|
79 | (4) |
|
Copying Words and Images from Other Sources |
|
|
83 | (1) |
|
|
|
83 | (1) |
|
|
|
84 | (1) |
|
Working with Other Document Elements |
|
|
85 | (1) |
|
Adding elements by using the ribbon |
|
|
86 | (1) |
|
Modifying elements by using the ribbon |
|
|
87 | (1) |
|
|
|
87 | (2) |
|
Chapter 6 Refining and Editing Documents with Word |
|
|
89 | (24) |
|
Moving Text and Images in Your Documents |
|
|
90 | (1) |
|
Moving items easily within a document |
|
|
90 | (1) |
|
Using special Word features that make moving stuff easier |
|
|
91 | (2) |
|
Check It Out: Checking Your Spelling, Grammar, and Hyphenation |
|
|
93 | (1) |
|
Double-checking your spelling and grammar |
|
|
94 | (1) |
|
Utilizing Word's built-in editor |
|
|
95 | (3) |
|
Correcting your errors automatically with AutoCorrect |
|
|
98 | (3) |
|
|
|
101 | (1) |
|
Discovering the Reference Tools |
|
|
102 | (1) |
|
The thoroughly terrific thesaurus |
|
|
102 | (2) |
|
The online reference tools |
|
|
104 | (4) |
|
Saving Time with the Find and Replace Feature |
|
|
108 | (1) |
|
Finding and replacing text |
|
|
108 | (1) |
|
Using Find and Replace to make formatting changes |
|
|
109 | (1) |
|
Using advanced search options to do more |
|
|
110 | (3) |
|
Chapter 7 Using Templates and Other Design Elements |
|
|
113 | (30) |
|
Canned Design: Working with Word Templates |
|
|
114 | (1) |
|
Getting started with the Document Gallery |
|
|
114 | (1) |
|
Sample project: Starting a custom newsletter from a template |
|
|
114 | (2) |
|
Creating a customized version of a Word template |
|
|
116 | (1) |
|
Saving your customized template |
|
|
116 | (2) |
|
Adding Basic Design Elements to Your Document |
|
|
118 | (1) |
|
Imagine that: Adding and resizing an image |
|
|
119 | (1) |
|
Moving images around documents |
|
|
119 | (2) |
|
Creating headers and footers |
|
|
121 | (3) |
|
Adding lines to your header or footer |
|
|
124 | (1) |
|
Arranging text with some help from tabs |
|
|
125 | (1) |
|
Setting Tabs, Margins, and Other Types of Indents |
|
|
126 | (1) |
|
|
|
126 | (3) |
|
|
|
129 | (1) |
|
|
|
130 | (2) |
|
Columns and Lists and Text Boxes (Oh, My) |
|
|
132 | (1) |
|
|
|
132 | (2) |
|
Lists made easy (and pretty) |
|
|
134 | (1) |
|
Text anywhere with text boxes |
|
|
135 | (1) |
|
|
|
136 | (1) |
|
|
|
136 | (3) |
|
|
|
139 | (4) |
|
Chapter 8 This and That: Advanced and Collaboration Features |
|
|
143 | (26) |
|
Going in Style: Defining Styles for Easy Formatting |
|
|
144 | (1) |
|
The easy way: Defining a style by example |
|
|
144 | (3) |
|
The harder way: Defining a style by dialog |
|
|
147 | (1) |
|
Customizing Interface Elements |
|
|
147 | (1) |
|
Customizing ribbon tabs and menus |
|
|
148 | (1) |
|
Create ribbon tabs and tab groups |
|
|
149 | (1) |
|
Customizing the Quick Access toolbar |
|
|
150 | (2) |
|
Customizing keyboard shortcuts |
|
|
152 | (2) |
|
Creating a Table of Contents Automatically |
|
|
154 | (3) |
|
Using Collaboration Features |
|
|
157 | (1) |
|
Turning on the Track Changes feature |
|
|
158 | (2) |
|
Accepting or rejecting changes |
|
|
160 | (2) |
|
Addressing Envelopes and Creating Labels |
|
|
162 | (1) |
|
Creating and printing an envelope |
|
|
162 | (2) |
|
|
|
164 | (3) |
|
|
|
167 | (2) |
|
PART 3 POWERFUL PRESENTATIONS WITH MICROSOFT POWERPOINT |
|
|
169 | (84) |
|
Chapter 9 Getting to Know Microsoft PowerPoint |
|
|
171 | (10) |
|
Viewing Slides with Various Views |
|
|
172 | (1) |
|
|
|
173 | (1) |
|
|
|
174 | (1) |
|
|
|
174 | (2) |
|
|
|
176 | (1) |
|
|
|
176 | (1) |
|
|
|
177 | (1) |
|
Planning Your Presentation: A Few Tips for Making Your Slide Shows Better |
|
|
178 | (1) |
|
|
|
178 | (1) |
|
|
|
179 | (2) |
|
Chapter 10 Creating Slide Shows |
|
|
181 | (32) |
|
|
|
182 | (1) |
|
Giving Your Presentation a Visual Theme |
|
|
182 | (1) |
|
|
|
182 | (2) |
|
Customizing a theme's colors or fonts |
|
|
184 | (2) |
|
Using Laborsaving Slide Layouts |
|
|
186 | (1) |
|
|
|
186 | (5) |
|
Working with title and text objects |
|
|
191 | (2) |
|
Working with PowerPoint Objects |
|
|
193 | (1) |
|
|
|
194 | (2) |
|
|
|
196 | (3) |
|
|
|
199 | (2) |
|
More media: Adding images, movies, or sounds |
|
|
201 | (2) |
|
Using Quick Styles and Effects |
|
|
203 | (3) |
|
Aligning, arranging, and distributing objects |
|
|
206 | (7) |
|
Chapter 11 Making Your Slide Shows Sing |
|
|
213 | (24) |
|
Using Transitions to Create a Polished-Looking Presentation |
|
|
214 | (1) |
|
|
|
214 | (2) |
|
|
|
216 | (1) |
|
|
|
217 | (1) |
|
Animating text or graphics |
|
|
217 | (6) |
|
Animating a chart or SmartArt graphic |
|
|
223 | (1) |
|
Creating Interactivity with Action Buttons |
|
|
224 | (2) |
|
|
|
226 | (1) |
|
|
|
226 | (3) |
|
Exporting (saving) your presentations as files |
|
|
229 | (8) |
|
Chapter 12 Presentation Prowess |
|
|
237 | (16) |
|
Working with the Basic PowerPoint Tools |
|
|
238 | (1) |
|
Ribbon and Quick Access toolbar customization |
|
|
238 | (3) |
|
Proofing and reference tools |
|
|
241 | (1) |
|
|
|
242 | (2) |
|
Templates and other miscellaneous tools |
|
|
244 | (1) |
|
|
|
244 | (2) |
|
|
|
246 | (1) |
|
Making the Most of Your PowerPoint Presentation |
|
|
247 | (1) |
|
Rehearsing and setting slide timings |
|
|
247 | (2) |
|
Using the presenter tools |
|
|
249 | (1) |
|
Working with a single display |
|
|
250 | (3) |
|
PART 4 CRUNCHING DATA WITH MICROSOFT'S MOST EXCELLENT EXCEL |
|
|
253 | (62) |
|
Chapter 13 Getting to Know Microsoft Excel |
|
|
255 | (6) |
|
Interfacing with Excel's User Interface |
|
|
256 | (1) |
|
Understanding the Concept of Rows, Columns, and Cells |
|
|
257 | (1) |
|
|
|
258 | (1) |
|
Navigating within Your Worksheets |
|
|
258 | (3) |
|
Chapter 14 Crunching Numbers (and Data) with Excel |
|
|
261 | (20) |
|
|
|
262 | (1) |
|
Choosing a local template |
|
|
262 | (1) |
|
Working with online templates |
|
|
263 | (1) |
|
Entering, Formatting, and Editing Data in Cells |
|
|
264 | (2) |
|
Copying and Pasting Data (and Formatting) between Cells |
|
|
266 | (2) |
|
|
|
268 | (1) |
|
Understanding Formulas and Functions |
|
|
269 | (1) |
|
|
|
269 | (1) |
|
Keeping track of Excel formulas with Formula Builder |
|
|
270 | (3) |
|
Using the Error Checking Feature |
|
|
273 | (2) |
|
Sorting and Filtering Data |
|
|
275 | (1) |
|
|
|
275 | (1) |
|
Using filters to narrow your data searches |
|
|
276 | (1) |
|
Finding and Replacing Data |
|
|
277 | (4) |
|
Chapter 15 Enhancing and Printing Your Excel Spreadsheets |
|
|
281 | (18) |
|
Creating and Formatting Charts |
|
|
282 | (3) |
|
Including Pictures and Shapes |
|
|
285 | (3) |
|
Adding Formatting and Special Effects |
|
|
288 | (3) |
|
Creating and Sorting Custom Lists |
|
|
291 | (1) |
|
|
|
292 | (1) |
|
|
|
292 | (1) |
|
Adding Headers and Footers |
|
|
293 | (1) |
|
Creating a header or footer |
|
|
293 | (1) |
|
Editing a header or footer |
|
|
294 | (1) |
|
Printing Your Spreadsheets |
|
|
295 | (1) |
|
Preparing for printing with Page Setup |
|
|
296 | (2) |
|
|
|
298 | (1) |
|
Chapter 16 Advanced Spreadsheeting |
|
|
299 | (16) |
|
|
|
300 | (1) |
|
|
|
300 | (4) |
|
|
|
304 | (3) |
|
|
|
307 | (1) |
|
Working with Multiple Worksheets |
|
|
307 | (1) |
|
|
|
308 | (2) |
|
Collaboration and Revision Tracking (a.k.a. Change Tracking) |
|
|
310 | (1) |
|
|
|
310 | (2) |
|
|
|
312 | (1) |
|
Accepting and rejecting your changes |
|
|
313 | (2) |
|
PART 5 MICROSOFT OUTLOOK: MIRACULOUS MANAGER OF MOST THINGS |
|
|
315 | (64) |
|
Chapter 17 Getting to Know Outlook |
|
|
317 | (6) |
|
Taking a Quick Tour of Outlook |
|
|
318 | (1) |
|
|
|
318 | (1) |
|
|
|
319 | (1) |
|
|
|
320 | (1) |
|
The Notes and Tasks modules |
|
|
320 | (3) |
|
Chapter 18 Emailing with Outlook |
|
|
323 | (22) |
|
Setting Up Outlook for Email |
|
|
323 | (1) |
|
Setting up your email automatically |
|
|
324 | (3) |
|
Setting up your email account manually |
|
|
327 | (3) |
|
Sending, Receiving, and Managing Your Email |
|
|
330 | (1) |
|
Creating and sending messages |
|
|
330 | (6) |
|
|
|
336 | (4) |
|
|
|
340 | (5) |
|
Chapter 19 Managing Your Affairs with Outlook |
|
|
345 | (22) |
|
Scheduling Events with Calendar |
|
|
346 | (7) |
|
Managing Your Crew with the People Module |
|
|
353 | (1) |
|
Adding and removing contacts |
|
|
353 | (3) |
|
|
|
356 | (4) |
|
Delving into the Home tab |
|
|
360 | (3) |
|
Tracking Progress with the Tasks Module |
|
|
363 | (2) |
|
|
|
365 | (2) |
|
Chapter 20 Getting Advanced with Outlook |
|
|
367 | (12) |
|
Customizing: Ifs Not Just for Hot Rods Anymore |
|
|
367 | (1) |
|
|
|
368 | (1) |
|
|
|
368 | (1) |
|
Hiding, showing, and rearranging interface elements |
|
|
369 | (1) |
|
The fast way to start an advanced search |
|
|
370 | (1) |
|
|
|
371 | (1) |
|
Your personal preferences |
|
|
371 | (2) |
|
Roll over, Beethoven, and catch the email preferences |
|
|
373 | (2) |
|
Everything but the Kitchen Sync |
|
|
375 | (1) |
|
"New" Outlook? Yes, Please! |
|
|
376 | (3) |
|
|
|
379 | (26) |
|
Chapter 21 Ten Unsung Office Features and Microsoft Apps for Mac |
|
|
381 | (8) |
|
|
|
381 | (1) |
|
|
|
382 | (1) |
|
|
|
383 | (1) |
|
|
|
384 | (1) |
|
|
|
384 | (2) |
|
|
|
386 | (1) |
|
|
|
386 | (1) |
|
|
|
387 | (1) |
|
|
|
388 | (1) |
|
|
|
388 | (1) |
|
Chapter 22 Ten Timesaving Shortcuts and Tips for Enhanced Productivity |
|
|
389 | (8) |
|
Memorize Keyboard Shortcuts |
|
|
389 | (1) |
|
Get to Know Your Preferences |
|
|
390 | (1) |
|
Save a Document as a PDF File |
|
|
391 | (1) |
|
Save Time by Using the Share o Email (as Attachment) Menu Item |
|
|
392 | (1) |
|
Focus on the Task at Hand |
|
|
393 | (1) |
|
Use the Open Recent Feature to Open Items from the Dock |
|
|
393 | (1) |
|
|
|
393 | (1) |
|
|
|
394 | (1) |
|
Speak Your Mind with Dictation |
|
|
394 | (1) |
|
Don't Forget Your Free OneDrive |
|
|
395 | (2) |
|
Chapter 23 Ten Ways to Customize Office |
|
|
397 | (8) |
|
Modify the Quick Access Toolbar |
|
|
397 | (1) |
|
Modify Existing Ribbon Tabs and Tab Groups |
|
|
398 | (1) |
|
Create a New Ribbon Tab or Tab Group for Frequently Used Commands |
|
|
399 | (1) |
|
|
|
400 | (1) |
|
Deal with Frequently Used Documents |
|
|
401 | (1) |
|
Remove Unused Keyboard Shortcuts |
|
|
401 | (1) |
|
Change an Existing Keyboard Shortcut |
|
|
402 | (1) |
|
Create a New Keyboard Shortcut |
|
|
402 | (1) |
|
Create Your Own Templates |
|
|
403 | (1) |
|
Experiment with Dark Mode |
|
|
403 | (2) |
| Index |
|
405 | |
Lisainfo e-raamatute kohta