Introduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Beyond the Book 3 Where to Go from Here 3 Part 1: Keeping up with Microsoft 365 5 Chapter 1: What''s in It for You: Overview of Features 7 Tasting the Flavors of Microsoft 365 8 Understanding the versions for home 9 Exploring the options for the workplace 9 Honing in on the Workplace Features 11 Reining in the apps and services 11 No, the robots have not taken over 12 Connecting the dots to get work done 13 Chapter 2: Work, Meet Life: The New World of Work 17 Going Native, Digitally 18 How to get your colleague''s attention 18 Turn back the hands of time with version history 20 Prioritizing Self-Care and Well-Being 21 Viva la vida loca! 21 Taming the "too-connected" beast 22 Calling it a day with Virtual Commute 24 Part 2: Reimagining Teamwork 25 Chapter 3: Unlocking Digital Collaboration 27 There''s a Purpose for That App 28 Office 365 versus Microsoft 365: What''s the diff? 28 Installing the Office 365 apps 29 The right tools for the right purpose 30 Connecting Experiences Across Apps 32 The lowdown on connected experiences 32 Look Ma, no hands! Using the Dictation feature 34 Chapter 4: Zooming In on Teams 37 Getting to Know Teams 38 Touring the Teams interface 38 Co-authoring documents in Teams 41 Don''t get ghosted -- use Read Receipts 42 Reading instead of listening to voicemail 43 Creating a Humanistic Workplace 44 To hide or not to hide the kids (or pets) 45 The many ways to see each other 46 Eat chips without being annoying 48 Chapter 5: Rocking Your Meeting Like a Boss 51 The Things You Do Before 52 Get meeting insights from Outlook 52 Chat with attendees to prep 54 Preload agenda and documents 56 The Stuff You Do During 57 Present like a pro with one monitor 57 Reporting live from your home office! 58 Follow along with live captions or live transcriptions 60 The Actions to Take After 62 Play back the meeting 63 Track action items 63 Continue to engage via chat 64 Chapter 6: Facilitating Meetings and Breakout Sessions 67 The Basics of Teams Meetings 68 Scheduling a meeting 69 Calling for an impromptu meeting 70 Joining a meeting 71 Meeting within a Meeting with Breakout Rooms 72 Creating Breakout rooms 73 Starting the breakout session 75 Rejoining the main session 76 Chapter 7: All About Webinars and Live Events 79 Calling the Shots with a Webinar 80 Preparing for a webinar 80 Creating the webinar event 81 Delivering the webinar 85 So, You Want to be a Producer 86 Getting ready to produce a live event 86 Scheduling a live event 87 Producing the live event 88 Part 3: Modernizing the Workplace with Office Apps 91 Chapter 8: Getting the Most Out of Word 93 It''s Alive! Your Document, That Is 94 Jazz it up with pictures 94 Your screen is paper, draw on it 97 Immerse yourself in your reading 99 Becoming a Better Writer 100 Make your writing so much better 101 Support your facts with Researcher 103 That Time When Word Helped Your Career 104 Sprucing up your resume 104 Smashing the language barrier 105 Chapter 9: Stepping up Your Excel Chops 107 Excelling in Excel 108 Everyday Excel tasks 108 Get it all sorted out 110 Talk to your team from your workbook 111 Taking a Shortcut to Completing Tasks 114 Get to know Office Scripts 114 Stop the repetition; create a script 114 Run and share your script 116 So, You''re a Data Analyst Now? 118 Around the world with data types 119 Giving yourself permission to be curious 121 You''ve got questions, Excel has answers 123 Chapter 10: Wowing Your Audience with PowerPoint 125 More than Just the Basics of PowerPoint 126 Navigating the web and desktop apps 127 Have an interesting topic? There''s'' a deck for that! 128 The Art of Creating a Deck 131 Be artsy (even when you''re not) with Designer 131 Mastering the Slide Master 133 Reuse, recycle decks with templates 134 The Science of Presenting a Deck 135 Practice with AI makes perfect 135 Give a unique experience with Live Presentations 138 Experiencing Live Presentations as an audience 141 Chapter 11: Going Digital with OneNote 145 Exploring Basic Functions 146 Understanding the different versions 146 Getting around the user interface 149 Creating a new notebook 150 Moving a notebook to a new location 152 Stepping Up the Notetaking Game 153 Tagging content for later use 154 Viewing and restoring page versions 155 Sharing your notebook 156 Chapter 12: Staying Connected with Outlook 159 The Not-Just-Basic of Outlook 160 Just a few words will do 162 My thoughts exactly: When AI reads minds 164 Ask questions, naturally 167 Schedule Management with the Calendar 168 Click to meet from an email 168 Color your world with categories 169 Don''t get between your colleagues and their lunch 171 Outlook Out of the Ball Park 173 Sliding into a Teams chat from Outlook 173 Notes and Sticky Notes integration 174 Play my emails, please 175 Part 4: Storing Your Data in the Cloud 177 Chapter 13: Centralizing Data in SharePoint 179 Getting to Know SharePoint Online 180 No-code website in a flash? Yes you can! 181 Who let the dogs in? Setting permissions 184 The Wonders of Microsoft Lists 187 Creating and editing a List 187 A view for different points of view 189 Never miss an update with alerts 191 The Marvels of Document Libraries 192 Contributing to a document library 192 Help, I changed my mind! Versioning to the rescue 193 Chapter 14: Goodbye Hard Drive, Hello OneDrive 197 Storing and Syncing Files in OneDrive 198 Ready, get set, sync! Using the sync app 198 What''s in a name? Work or School versus Home 201 What''s the diff? OneDrive versus SharePoint 202 The Many Ways to Share Files 204 May I have a quick link, please? 204 Managing access before it gets out of hand 206 Part 5: Giving Power to the People Like You and Me 209 Chapter 15: Understanding the Power Platform 211 What Is the Power Platform? 212 Creating Workflows with Power Automate 213 Getting to Know Power Apps 214 Telling a Story with Data in Power BI 217 Advanced Concepts 218 Meet the AI Builder 219 About the Microsoft Dataverse 219 Chapter 16: Creating a Power-Automated Approval Process 221 Gathering What You need 222 Nailing the scenario 222 Building the library 223 Picking the template 224 All Systems Go, Let''s Flow! 226 Building the flow, making the connections 226 Testing the workflow 230 Checking for approvals in Teams 231 Turning off the flow 232 Chapter 17: Developing Your First App with Power Apps 233 Before Building the App 234 Creating the list to hold data 235 Managing access to the list 236 Fine-tuning the properties of the list 238 Specifying the survey questions 240 Building the App 243 Designing the app 244 Connecting the data source 244 Building the Survey screen 247 Adding buttons and labels to the form 250 Building the Welcome screen 253 Building the Thank You screen 255 Finalizing the Survey screen 255 Launching the App 256 Saving and sharing the app 257 Updating the app 257 Reviewing the data 258 Chapter 18: Dashboarding with Power BI 259 Understanding Power BI Concepts 260 What''s in it for you? 261 How Power BI is licensed 261 It''s the elements, dear Watson 262 Exploring a Sample Data Set 263 Navigating the Power BI Service 263 Loading the dataset 266 Interacting with the dashboard 267 Part 6: Being Your Own IT Department 271 Chapter 19: Getting Up Close and Personal 273 Let''s Get Personal 274 Paint a thousand words with your picture 274 Spice things up with a custom cover photo 276 Don''t be shy, toot your own horn 276 IT Tasks You''re Empowered to Do 277 Updating your security information 278 Changing your password 279 Self-service password reset 280 Chapter 20: Reining in Your Devices 283 Managing Your Devices 284 Securing your devices 284 Auditing and disabling devices 285 Checking for impossible travel 287 You Have Left the Building -- Virtually 288 Signing out from devices all at once 288.
Microsoft 365 for Dummies