Microsoft 365 Portable Genius

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.

About the Author iii

Acknowledgments v

Introduction xi

Chapter 1 How Do I Start Using Microsoft 365? 2

Starting and Exiting an App 4

Taking a Look Around 6

Reviewing key screen features 6

Changing views 8

Zooming 10

Working with Files 11

Creating a blank file 11

Exploring templates 12

Opening an existing file 14

Switching to another file 15

Typing in a Word Document 17

Making Your First Cell Entries in Excel 19

Exploring the Excel screen 19

Moving around the sheet 21

Adding text and values 22

Adding dates and times 23

Number formatting on the fly 24

Adding Slide Content in PowerPoint 26

Making and Working with Selections 27

Selecting content in Word 27

Selecting content in Excel 28

Selecting content in PowerPoint 30

Copying or moving a selection 31

Refining Your Content 33

Spell checking your work 34

Using Find and Replace 36

Saving and Closing a File 37

Chapter 2 How Do I Develop Document Content in Word? 40

Using Outlining to Organize Your Thoughts 42

More on Navigating, Selecting, and Editing in Word 44

Creating Bulleted and Numbered Lists 47

Working with Tabs and Indent Settings 49

Setting tab stops 50

Setting indents 52

Working with Line, Page, and Section Breaks 54

Creating Columns of Text 56

Using Review Tools to Improve Your Writing 57

Getting word suggestions from the Thesaurus 58

Tracking changes and commenting 58

Chapter 3 How Do I Make Changes in Excel? 62

Working with Sheets 64

Adding, renaming, and jumping to a sheet 64

Moving or copying a sheet 65

Cell Editing Basics 66

Making changes 66

Clearing cell contents 67

Using Auto Fill and Filling Series 68

Inserting and Deleting Rows, Columns, and Cells 71

Working with Column Width and Row Height 73

Creating Range Names 75

Using the Name box 76

Using the New Name dialog box 77

Deleting a range name 78

Freezing Rows and Columns On-Screen 79

Chapter 4 How Do I Do Math with Excel Formulas and Functions? 82

Entering a Basic Formula 84

Typing the formula 84

Cell and range references in formulas 85

Using the mouse to save time 86

Dealing with minor errors 88

Learning More About Operators and Order of Precedence 88

Reviewing operators in Excel 89

Understanding how order of precedence works 91

Using parentheses in formulas 93

Making a Cell or Range Reference Absolute Rather Than Relative 94

Changing the reference type in a formula 94

How referencing works when filling, copying, or moving a formula 95

Understanding and Using Functions 97

Using AutoSum on the Home or Formulas tab 98

Typing a function in a formula 101

Using the Formulas tab to insert a function 103

Using Range Names in Formulas 107

Chapter 5 How Do I Create a PowerPoint Presentation? 110

Understanding Slide Layouts 112

Adding Slides 114

Rearranging and Deleting Slides 116

Working with Content Placeholders 117

Regular content 117

Speaker notes 119

Editing Slide Content 120

Changing Slide Size or Background 121

Preparing and Playing the Slide Show 122

Adding transitions 123

Adding animations 124

Playing the show 125

Chapter 6 How Do I Use Formatting to Enhance My Documents? 128

Changing the Number or Date Format in Excel 130

Using number formats 132

Using date and time formats 134

Changing Text Formatting 134

Applying font formatting 135

Applying alignment formatting 139

Changing Paragraph and Page

Formatting in Word and PowerPoint 142

Changing overall line spacing 143

Changing spacing before and after paragraphs 143

Working with Borders and Shading 146

Using borders and shading in Word 146

Adding a page border in Word 147

Changing cell borders and shading in Excel 148

Using Styles 149

Understanding Themes 152

Reviewing elements of a theme 152

Changing themes 153

Chapter 7 How Do I Use Graphics? 156

Inserting Simple Graphics 158

Shapes 158

Pictures 160

Icons 164

Selecting and Formatting Graphics 165

Adding text to shapes 165

Changing styles 166

Changing sizing and position 168

Working with layering, alignment, and rotation 170

Working with wrapping in Word 173

Creating and Working with SmartArt 173

Adding a SmartArt graphic 173

Editing and rearranging shapes 176

Changing the graphic type and formatting 177

Deleting Graphics 177

Chapter 8 How Do I Manage Lists of Information? 180

Adding a Table in Word or PowerPoint 182

Adding the table and making entries 182

Adding and deleting rows or columns 183

Arranging a List in Excel 184

Understanding Excel’s Table Feature 187

Converting a range to a table 187

Importing or connecting to a list of data 189

Resizing a table 192

Adding a total row 192

Sorting and Filtering Lists and Tables 193

Changing Table Styles 197

Converting a Table Back to Regular Content 198

Chapter 9 How Do I Present My Data in Charts? 200

Using Different Chart Types 202

Creating a Chart in Excel 203

Creating a Chart in Word or PowerPoint 207

Changing the Chart Type and Layout 209

Formatting Chart Elements 211

Changing the Charted Data 213

Deleting a Chart 215

Chapter 10 How Do I Manage Emails and Contacts in Outlook? 216

Adding Your Account 218

Creating and Sending Messages 220

Receiving, Reading, and Replying to Messages 224

Organizing Messages 227

Adding Contacts 229

Chapter 11 How Do I Print and Share My Content? 232

Creating Headers and Footers 234

Changing Page Settings 238

Margins 238

Orientation and paper size 240

Scaling an Excel printout 240

Changing Sheet Settings in Excel 241

Adding print titles 241

Controlling whether gridlines and other features print 243

Working with Page Breaks in Excel 243

Setting a print area 243

Viewing and moving breaks 245

Previewing a Printout and Printing 246

Sharing Information in Other Ways 247

Exporting a PDF 247

Using OneDrive 249

Index 251