Оглавление
Bob LeVitus. Office 2021 for Macs For Dummies
Microsoft® Office® 2021 For Macs® For Dummies® To view this book's Cheat Sheet, simply go to www.dummies.com and search for “Microsoft Office 2021 For Macs For Dummies Cheat Sheet” in the Search box. Table of Contents
List of Tables
List of Illustrations
Guide
Pages
Introduction
About This Book
Foolish Assumptions
Icons Used in This Book
Beyond the Book
Where to Go from Here
Introduction to Microsoft Office for Mac
Overview from 10,000 Feet
The Many Faces of Office for Mac
Installing Office
Getting a Microsoft account
Downloading and installing Office
DEALING WITH MULTIPLE VERSIONS OF OFFICE
Keeping Your Apps Up-to-Date
A Sweet Suite: Introducing the Office Apps
What’s New and Good
The suite life
Word
PowerPoint
Excel
Outlook
What’s New but Bad
Together, They’re Better
Common Features in All Office Apps
Using Menus in Office Apps
Toolbars, Ribbons, and Panes: Think “Visual” Menus
The Quick Access toolbar
Reveling in the ribbon
Panes are anything but a pain
Customizing the Quick Access Toolbar, Ribbon Tabs, and Keyboard Shortcuts
Customize the Quick Access toolbar
Customize ribbon tabs and menus
Creating ribbon tabs and tab groups
Customizing keyboard shortcuts
Creating and Saving Documents
Using the gallery to open templates or recent documents
Saving a document
Part I: The initial save
Part II: The resave
DECIDING WHICH FILE FORMAT TO CHOOSE WHEN SAVING A DOCUMENT
SAVE VERSUS SAVE AS
A-U-T-O-matic Recovery
Saving and Using Documents in the Cloud
Saving a file on a OneDrive or SharePoint location
Sharing a file you’ve saved using OneDrive or SharePoint
Opening a file you’ve saved on your OneDrive or SharePoint location
Understanding App Preferences
App preferences: Why?
App preferences: How?
Help: It’s more than just a Beatles movie
Official Microsoft websites
Mastering Microsoft Word
Getting to Know Microsoft Word
Using a Variety of Versatile Views
Print layout view
Web layout view
Outline view
Draft view
Focus view
Full screen view
Immersive reader view
Zoom, zoom, zoom
Getting around in Your Document
A scroll new world: Navigating by using the mouse or trackpad
Navigating by using keyboard navigation
MAKING THINGS EVEN EASIER
Creating Documents
Adding Text and Graphics to Your Document
Entering text in your document
Inserting an image in your document
Stock Images gallery
Online Pictures browser
Your own images
Selecting Text for Editing and Formatting
Formatting Text, Paragraphs, and Images
Changing the look of the font
Changing the look of paragraphs
Changing the look of images
Copying Words and Images from Other Sources
Dragging and dropping
Copying and pasting
Working with Other Document Elements
Adding elements by using the ribbon
Modifying elements by using the ribbon
Removing elements
Refining and Editing Documents with Word
Moving Text and Images in Your Documents
Moving items easily within a document
Using special Word features that make moving stuff easier
Splitting a window
Opening a new window
Check It Out: Checking Your Spelling, Grammar, and Hyphenation
Double-checking your spelling and grammar
Utilizing Word’s built-in editor
Correcting your errors automatically with AutoCorrect
Turning on and configuring AutoCorrect
Using AutoFormat as You Type
Using AutoText
Hypnotic hyphenation
Hyphenating manually, one word at a time
Hyphenating a document automatically, in one fell swoop
Discovering the Reference Tools
The thoroughly terrific thesaurus
The online reference tools
Smart Lookup
Researcher
Translator
Saving Time with the Find and Replace Feature
Finding and replacing text
Using Find and Replace to make formatting changes
Using advanced search options to do more
Using Templates and Other Design Elements
Canned Design: Working with Word Templates
Getting started with the Document Gallery
Sample project: Starting a custom newsletter from a template
Creating a customized version of a Word template
Saving your customized template
Adding Basic Design Elements to Your Document
Imagine that: Adding and resizing an image
Moving images around documents
Creating headers and footers
Adding lines to your header or footer
Arranging text with some help from tabs
Setting Tabs, Margins, and Other Types of Indents
Setting tabs
Setting tabs using the Tabs dialog
Clearing tab stops
Making your margins
Working with indents
Columns and Lists and Text Boxes (Oh, My)
Column creation
Lists made easy (and pretty)
Text anywhere with text boxes
Working with Tables
Creating a table
Formatting a table
Dragging boundary lines isn’t a drag
Using the ribbon’s table tabs
Uncovering the (sometimes) hidden tools of the Layout tab for tables
This and That: Advanced and Collaboration Features
Going in Style: Defining Styles for Easy Formatting
The easy way: Defining a style by example
The harder way: Defining a style by dialog
Customizing Interface Elements
Customizing ribbon tabs and menus
Create ribbon tabs and tab groups
Customizing the Quick Access toolbar
Customizing keyboard shortcuts
Creating a Table of Contents Automatically
Using Collaboration Features
Turning on the Track Changes feature
Accepting or rejecting changes
Addressing Envelopes and Creating Labels
Creating and printing an envelope
Creating labels
Creating Web Pages
Powerful Presentations with Microsoft PowerPoint
Getting to Know Microsoft PowerPoint
Viewing Slides with Various Views
Normal view
Slide sorter view
Slide show view
Notes page view
Presenter view
Reading view
Planning Your Presentation: A Few Tips for Making Your Slide Shows Better
Use the 10/20/30 rule
Start with an outline
Creating Slide Shows
Getting Started
Giving Your Presentation a Visual Theme
Using a theme as is
Customizing a theme’s colors or fonts
Using Laborsaving Slide Layouts
Mastering slide masters
Working with title and text objects
The shadow knows: Creating a drop shadow effect
Getting your point across with bulleted or numbered lists
Working with PowerPoint Objects
Formatting tables
Creating a chart
Get smart: Use SmartArt
More media: Adding images, movies, or sounds
Using Quick Styles and Effects
Aligning, arranging, and distributing objects
Arranging isn’t just for songs any more
Alignment isn’t just for car wheels any more
Distribution isn’t just a mathematical term any more
Aligning objects with dynamic guides
Making Your Slide Shows Sing
Using Transitions to Create a Polished-Looking Presentation
Applying transitions
Transition options
Using Custom Animation
Animating text or graphics
Animating a chart or SmartArt graphic
Creating Interactivity with Action Buttons
Share and Share Alike
Printing hard copy
Printing slides
Printing handouts
Printing notes
Printing an outline
Exporting (saving) your presentations as files
Exporting a presentation as a movie
Exporting slides as individual picture files
Exporting a presentation as a PDF file
Saving your presentation online
Presentation Prowess
Working with the Basic PowerPoint Tools
Ribbon and Quick Access toolbar customization
Customize ribbon tabs and tab groups by rearranging them
Creating ribbon tabs and tab groups
Customizing the Quick Access toolbar
Proofing and reference tools
Commenting on slides
Templates and other miscellaneous tools
Using Hyperlinks
Recording Narration
Making the Most of Your PowerPoint Presentation
Rehearsing and setting slide timings
HOW TO SET UP YOUR MAC FOR TWO DISPLAYS
Using the presenter tools
Working with a single display
Crunching Data with Microsoft’s Most Excellent Excel
Getting to Know Microsoft Excel
Interfacing with Excel’s User Interface
Understanding the Concept of Rows, Columns, and Cells
Using the Views
Navigating within Your Worksheets
Crunching Numbers (and Data) with Excel
Working with Templates
Choosing a local template
Working with online templates
Entering, Formatting, and Editing Data in Cells
Copying and Pasting Data (and Formatting) between Cells
AutoFilling Cells
Understanding Formulas and Functions
Creating a formula
Keeping track of Excel formulas with Formula Builder
ABSOLUTE VERSUS RELATIVE REFERENCES
Using the Error Checking Feature
Sorting and Filtering Data
Sorting data
Using filters to narrow your data searches
Finding and Replacing Data
Enhancing and Printing Your Excel Spreadsheets
Creating and Formatting Charts
Including Pictures and Shapes
Adding Formatting and Special Effects
Creating and Sorting Custom Lists
Creating a custom list
Sorting a list
Adding Headers and Footers
Creating a header or footer
Editing a header or footer
Printing Your Spreadsheets
Preparing for printing with Page Setup
Ready, set, print
Advanced Spreadsheeting
Customizing Excel
Preferences
General pane
View pane
Ribbon & Toolbar pane
Edit pane
AutoCorrect pane
Chart pane
East Asian Languages pane
Calculation pane
Error Checking pane
Custom Lists pane
AutoComplete pane
Tables & Filters pane
Save pane
Compatibility pane
Security pane
Privacy pane
Conditional Formatting
Naming a Cell Range
Working with Multiple Worksheets
Hyperlinking
Collaboration and Revision Tracking (a.k.a. Change Tracking)
Saving a workbook online
Tracking your changes
Accepting and rejecting your changes
Microsoft Outlook: Miraculous Manager of Most Things
Getting to Know Outlook
Taking a Quick Tour of Outlook
The Mail module
The Calendar module
The People module
The Notes and Tasks modules
OUTLOOK’S CHAMELEON MENUS AND RIBBON
Emailing with Outlook
Setting Up Outlook for Email
Setting up your email automatically
Setting up your email account manually
HOW TO FIND INFORMATION ABOUT YOUR EMAIL ACCOUNT
Sending, Receiving, and Managing Your Email
Creating and sending messages
Formatting your message text
Including attachments
Adding a signature
Receiving messages
Checking for messages manually
Scheduling an email to be sent later
Dealing with junk mail
Managing your email
Organizing your messages in folders
Searching your messages
Creating rules for received messages
Managing Your Affairs with Outlook
Scheduling Events with Calendar
Switching views
Scheduling appointments and meetings
Sending invitations to meetings and receiving responses
Printing the event
Deleting an event
Managing Your Crew with the People Module
Adding and removing contacts
Creating a contact
Adding the sender of an email message as a contact
Removing a contact
Working with contacts
Finding contacts
Using searches and views
Creating groups
Delving into the Home tab
Tracking Progress with the Tasks Module
Understanding Notes
Getting Advanced with Outlook
Customizing: It’s Not Just for Hot Rods Anymore
Reducin’ the ribbon
Concentrating on columns
Hiding, showing, and rearranging interface elements
The fast way to start an advanced search
What’s Your Preference?
Your personal preferences
General pane
Accounts pane
Notifications & Sounds pane
Categories pane
Fonts pane
AutoCorrect pane
Spelling & Grammar pane
Roll over, Beethoven, and catch the email preferences
Reading pane
Composing pane
Signatures pane
Rules pane
Junk pane
Everything but the Kitchen Sync
Calendar pane
Contacts pane
Privacy pane
“New” Outlook? Yes, Please!
The Part of Tens
Ten Unsung Office Features and Microsoft Apps for Mac
The Developer Ribbon Tab
A Multitude of Fonts
Icons Gallery
Import Outlook Archives
Microsoft Teams
Outlook Profile Manager
Microsoft Remote Desktop
Microsoft Edge
Microsoft To Do
Microsoft OneNote
Ten Timesaving Shortcuts and Tips for Enhanced Productivity
Memorize Keyboard Shortcuts
Get to Know Your Preferences
Save a Document as a PDF File
Save Time by Using the Share ⇒ Email (as Attachment) Menu Item
Focus on the Task at Hand
Use the Open Recent Feature to Open Items from the Dock
Get Help
Use Format Painter
Speak Your Mind with Dictation
Don’t Forget Your Free OneDrive
Ten Ways to Customize Office
Modify the Quick Access Toolbar
Modify Existing Ribbon Tabs and Tab Groups
Create a New Ribbon Tab or Tab Group for Frequently Used Commands
Focus with Full Screen
Deal with Frequently Used Documents
Remove Unused Keyboard Shortcuts
Change an Existing Keyboard Shortcut
Create a New Keyboard Shortcut
Create Your Own Templates
Experiment with Dark Mode
Index. Symbols and Numerics
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
About the Authors
Dedications
Authors' Acknowledgments
WILEY END USER LICENSE AGREEMENT
