Office 2021 for Macs For Dummies

Bob LeVitus has written nearly 100 reference books on Apple technologies. He’s the author or coauthor of macOS For Dummies, iPad For Dummies, and iPhone For Dummies, among others.Dwight Spivey probably wrote the rest of the For Dummies books on Apple products, including iPhone For Seniors For Dummies, iPad For Seniors For Dummies, and Apple Watch For Seniors For Dummies.

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