Title Page
Copyright Page
Table of Contents
Introduction
About This Book
Foolish Assumptions
Icons Used in This Book
Beyond the Book
Where to Go from Here
Part 1 Introduction to Microsoft Office for Mac
Chapter 1 Overview from 10,000 Feet
The Many Faces of Office for Mac
Installing Office
Getting a Microsoft account
Downloading and installing Office
Keeping Your Apps Up-to-Date
Chapter 2 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
Chapter 3 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
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
Part 2 Mastering Microsoft Word
Chapter 4 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
Chapter 5 Creating Documents
Adding Text and Graphics to Your Document
Entering text in your document
Inserting an image in your document
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
Chapter 6 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
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
Hypnotic hyphenation
Discovering the Reference Tools
The thoroughly terrific thesaurus
The online reference tools
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
Chapter 7 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
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
Chapter 8 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
Part 3 Powerful Presentations with Microsoft PowerPoint
Chapter 9 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
Chapter 10 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
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
Chapter 11 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
Exporting (saving) your presentations as files
Chapter 12 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
Using the presenter tools
Working with a single display
Part 4 Crunching Data with Microsoft’s Most Excellent Excel
Chapter 13 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
Chapter 14 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
Using the Error Checking Feature
Sorting and Filtering Data
Sorting data
Using filters to narrow your data searches
Finding and Replacing Data
Chapter 15 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
Chapter 16 Advanced Spreadsheeting
Customizing Excel
Preferences
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
Part 5 Microsoft Outlook: Miraculous Manager of Most Things
Chapter 17 Getting to Know Outlook
Taking a Quick Tour of Outlook
The Mail module
The Calendar module
The People module
The Notes and Tasks modules
Chapter 18 Emailing with Outlook
Setting Up Outlook for Email
Setting up your email automatically
Setting up your email account manually
Sending, Receiving, and Managing Your Email
Creating and sending messages
Receiving messages
Managing your email
Chapter 19 Managing Your Affairs with Outlook
Scheduling Events with Calendar
Managing Your Crew with the People Module
Adding and removing contacts
Working with contacts
Delving into the Home tab
Tracking Progress with the Tasks Module
Understanding Notes
Chapter 20 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
Roll over, Beethoven, and catch the email preferences
Everything but the Kitchen Sync
“New” Outlook? Yes, Please!
Part 6 The Part of Tens
Chapter 21 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
Chapter 22 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
Chapter 23 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
EULA