About the Author iiiAcknowledgments vIntroduction xiChapter 1 How Do I Start Using Microsoft 365? 2Starting and Exiting an App 4Taking a Look Around 6Reviewing key screen features 6Changing views 8Zooming 10Working with Files 11Creating a blank file 11Exploring templates 12Opening an existing file 14Switching to another file 15Typing in a Word Document 17Making Your First Cell Entries in Excel 19Exploring the Excel screen 19Moving around the sheet 21Adding text and values 22Adding dates and times 23Number formatting on the fly 24Adding Slide Content in PowerPoint 26Making and Working with Selections 27Selecting content in Word 27Selecting content in Excel 28Selecting content in PowerPoint 30Copying or moving a selection 31Refining Your Content 33Spell checking your work 34Using Find and Replace 36Saving and Closing a File 37Chapter 2 How Do I Develop Document Content in Word? 40Using Outlining to Organize Your Thoughts 42More on Navigating, Selecting, and Editing in Word 44Creating Bulleted and Numbered Lists 47Working with Tabs and Indent Settings 49Setting tab stops 50Setting indents 52Working with Line, Page, and Section Breaks 54Creating Columns of Text 56Using Review Tools to Improve Your Writing 57Getting word suggestions from the Thesaurus 58Tracking changes and commenting 58Chapter 3 How Do I Make Changes in Excel? 62Working with Sheets 64Adding, renaming, and jumping to a sheet 64Moving or copying a sheet 65Cell Editing Basics 66Making changes 66Clearing cell contents 67Using Auto Fill and Filling Series 68Inserting and Deleting Rows, Columns, and Cells 71Working with Column Width and Row Height 73Creating Range Names 75Using the Name box 76Using the New Name dialog box 77Deleting a range name 78Freezing Rows and Columns On-Screen 79Chapter 4 How Do I Do Math with Excel Formulas and Functions? 82Entering a Basic Formula 84Typing the formula 84Cell and range references in formulas 85Using the mouse to save time 86Dealing with minor errors 88Learning More About Operators and Order of Precedence 88Reviewing operators in Excel 89Understanding how order of precedence works 91Using parentheses in formulas 93Making a Cell or Range Reference Absolute Rather Than Relative 94Changing the reference type in a formula 94How referencing works when filling, copying, or moving a formula 95Understanding and Using Functions 97Using AutoSum on the Home or Formulas tab 98Typing a function in a formula 101Using the Formulas tab to insert a function 103Using Range Names in Formulas 107Chapter 5 How Do I Create a PowerPoint Presentation? 110Understanding Slide Layouts 112Adding Slides 114Rearranging and Deleting Slides 116Working with Content Placeholders 117Regular content 117Speaker notes 119Editing Slide Content 120Changing Slide Size or Background 121Preparing and Playing the Slide Show 122Adding transitions 123Adding animations 124Playing the show 125Chapter 6 How Do I Use Formatting to Enhance My Documents? 128Changing the Number or Date Format in Excel 130Using number formats 132Using date and time formats 134Changing Text Formatting 134Applying font formatting 135Applying alignment formatting 139Changing Paragraph and PageFormatting in Word and PowerPoint 142Changing overall line spacing 143Changing spacing before and after paragraphs 143Working with Borders and Shading 146Using borders and shading in Word 146Adding a page border in Word 147Changing cell borders and shading in Excel 148Using Styles 149Understanding Themes 152Reviewing elements of a theme 152Changing themes 153Chapter 7 How Do I Use Graphics? 156Inserting Simple Graphics 158Shapes 158Pictures 160Icons 164Selecting and Formatting Graphics 165Adding text to shapes 165Changing styles 166Changing sizing and position 168Working with layering, alignment, and rotation 170Working with wrapping in Word 173Creating and Working with SmartArt 173Adding a SmartArt graphic 173Editing and rearranging shapes 176Changing the graphic type and formatting 177Deleting Graphics 177Chapter 8 How Do I Manage Lists of Information? 180Adding a Table in Word or PowerPoint 182Adding the table and making entries 182Adding and deleting rows or columns 183Arranging a List in Excel 184Understanding Excel's Table Feature 187Converting a range to a table 187Importing or connecting to a list of data 189Resizing a table 192Adding a total row 192Sorting and Filtering Lists and Tables 193Changing Table Styles 197Converting a Table Back to Regular Content 198Chapter 9 How Do I Present My Data in Charts? 200Using Different Chart Types 202Creating a Chart in Excel 203Creating a Chart in Word or PowerPoint 207Changing the Chart Type and Layout 209Formatting Chart Elements 211Changing the Charted Data 213Deleting a Chart 215Chapter 10 How Do I Manage Emails and Contacts in Outlook? 216Adding Your Account 218Creating and Sending Messages 220Receiving, Reading, and Replying to Messages 224Organizing Messages 227Adding Contacts 229Chapter 11 How Do I Print and Share My Content? 232Creating Headers and Footers 234Changing Page Settings 238Margins 238Orientation and paper size 240Scaling an Excel printout 240Changing Sheet Settings in Excel 241Adding print titles 241Controlling whether gridlines and other features print 243Working with Page Breaks in Excel 243Setting a print area 243Viewing and moving breaks 245Previewing a Printout and Printing 246Sharing Information in Other Ways 247Exporting a PDF 247Using OneDrive 249Index 251
Lisa A. Bucki is an author, trainer, and content creator who's been educating others about computers and software since 1990. She's written dozens of books, provided marketing and training services to her clients, and written online tutorials. She is the co-founder of 1x1 Media.Fun, hip, and straightforward, the Portable Genius series gives forward-thinking technology users helpful information in handy, compact books that are easy to navigate and don't skimp on the essentials. Collect the whole series and make the most of your digital lifestyle.