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 Keeping up with Microsoft 365
Chapter 1 What’s in It for You: Overview of Features
Tasting the Flavors of Microsoft 365
Understanding the versions for home
Exploring the options for the workplace
Honing in on the Workplace Features
Reining in the apps and services
No, the robots have not taken over
Connecting the dots to get work done
Chapter 2 Work, Meet Life: The New World of Work
Going Native, Digitally
How to get your colleague’s attention
Turn back the hands of time with version history
Prioritizing Self-Care and Well-Being
Viva la vida loca!
Taming the “too-connected” beast
Calling it a day with Virtual Commute
Part 2 Reimagining Teamwork
Chapter 3 Unlocking Digital Collaboration
There’s a Purpose for That App
Office 365 versus Microsoft 365: What’s the diff?
Installing the Office 365 apps
The right tools for the right purpose
Connecting Experiences Across Apps
The lowdown on connected experiences
Look Ma, no hands! Using the Dictation feature
Chapter 4 Zooming In on Teams
Getting to Know Teams
Touring the Teams interface
Co-authoring documents in Teams
Don’t get ghosted — use Read Receipts
Reading instead of listening to voicemail
Creating a Humanistic Workplace
To hide or not to hide the kids (or pets)
The many ways to see each other
Eat chips without being annoying
Chapter 5 Rocking Your Meeting Like a Boss
The Things You Do Before
Get meeting insights from Outlook
Chat with attendees to prep
Preload agenda and documents
The Stuff You Do During
Present like a pro with one monitor
Reporting live from . . . your home office!
Follow along with live captions or live transcriptions
The Actions to Take After
Play back the meeting
Track action items
Continue to engage via chat
Chapter 6 Facilitating Meetings and Breakout Sessions
The Basics of Teams Meetings
Scheduling a meeting
Calling for an impromptu meeting
Joining a meeting
Meeting within a Meeting with Breakout Rooms
Creating Breakout rooms
Starting the breakout session
Rejoining the main session
Chapter 7 All About Webinars and Live Events
Calling the Shots with a Webinar
Preparing for a webinar
Creating the webinar event
Delivering the webinar
So, You Want to be a Producer
Getting ready to produce a live event
Scheduling a live event
Producing the live event
Part 3 Modernizing the Workplace with Office Apps
Chapter 8 Getting the Most Out of Word
It’s Alive! Your Document, That Is
Jazz it up with pictures
Your screen is paper, draw on it
Immerse yourself in your reading
Becoming a Better Writer
Make your writing so much better
Support your facts with Researcher
That Time When Word Helped Your Career
Sprucing up your resume
Smashing the language barrier
Chapter 9 Stepping up Your Excel Chops
Excelling in Excel
Everyday Excel tasks
Get it all sorted out
Talk to your team from your workbook
Taking a Shortcut to Completing Tasks
Get to know Office Scripts
Stop the repetition; create a script
Run and share your script
So, You’re a Data Analyst Now?
Around the world with data types
Giving yourself permission to be curious
You’ve got questions, Excel has answers
Chapter 10 Wowing Your Audience with PowerPoint
More than Just the Basics of PowerPoint
Navigating the web and desktop apps
Have an interesting topic? There’s’ a deck for that!
The Art of Creating a Deck
Be artsy (even when you’re not) with Designer
Mastering the Slide Master
Reuse, recycle decks with templates
The Science of Presenting a Deck
Practice with AI makes perfect
Give a unique experience with Live Presentations
Experiencing Live Presentations as an audience
Chapter 11 Going Digital with OneNote
Exploring Basic Functions
Understanding the different versions
Getting around the user interface
Creating a new notebook
Moving a notebook to a new location
Stepping Up the Notetaking Game
Tagging content for later use
Viewing and restoring page versions
Sharing your notebook
Chapter 12 Staying Connected with Outlook
The Not-Just-Basic of Outlook
Just a few words will do
My thoughts exactly: When AI reads minds
Ask questions, naturally
Schedule Management with the Calendar
Click to meet from an email
Color your world with categories
Don’t get between your colleagues and their lunch
Outlook Out of the Ball Park
Sliding into a Teams chat from Outlook
Notes and Sticky Notes integration
Play my emails, please
Part 4 Storing Your Data in the Cloud
Chapter 13 Centralizing Data in SharePoint
Getting to Know SharePoint Online
No-code website in a flash? Yes you can!
Who let the dogs in? Setting permissions
The Wonders of Microsoft Lists
Creating and editing a List
A view for different points of view
Never miss an update with alerts
The Marvels of Document Libraries
Contributing to a document library
Help, I changed my mind! Versioning to the rescue
Chapter 14 Goodbye Hard Drive, Hello OneDrive
Storing and Syncing Files in OneDrive
Ready, get set, sync! Using the sync app
What’s in a name? Work or School versus Home
What’s the diff? OneDrive versus SharePoint
The Many Ways to Share Files
May I have a quick link, please?
Managing access before it gets out of hand
Part 5 Giving Power to the People Like You and Me
Chapter 15 Understanding the Power Platform
What Is the Power Platform?
Creating Workflows with Power Automate
Getting to Know Power Apps
Telling a Story with Data in Power BI
Advanced Concepts
Meet the AI Builder
About the Microsoft Dataverse
Chapter 16 Creating a Power-Automated Approval Process
Gathering What You need
Nailing the scenario
Building the library
Picking the template
All Systems Go, Let’s Flow!
Building the flow, making the connections
Testing the workflow
Checking for approvals in Teams
Turning off the flow
Chapter 17 Developing Your First App with Power Apps
Before Building the App
Creating the list to hold data
Managing access to the list
Fine-tuning the properties of the list
Specifying the survey questions
Building the App
Designing the app
Connecting the data source
Building the Survey screen
Adding buttons and labels to the form
Building the Welcome screen
Building the Thank You screen
Finalizing the Survey screen
Launching the App
Saving and sharing the app
Updating the app
Reviewing the data
Chapter 18 Dashboarding with Power BI
Understanding Power BI Concepts
What’s in it for you?
How Power BI is licensed
It’s the elements, dear Watson
Exploring a Sample Data Set
Navigating the Power BI Service
Loading the dataset
Interacting with the dashboard
Part 6 Being Your Own IT Department
Chapter 19 Getting Up Close and Personal
Let’s Get Personal
Paint a thousand words with your picture
Spice things up with a custom cover photo
Don’t be shy, toot your own horn
IT Tasks You’re Empowered to Do
Updating your security information
Changing your password
Self-service password reset
Chapter 20 Reining in Your Devices
Managing Your Devices
Securing your devices
Auditing and disabling devices
Checking for impossible travel
You Have Left the Building — Virtually
Signing out from devices all at once
Disconnecting a BYOD
Part 7 The Part of Tens
Chapter 21 Ten More Apps that Get the Work Done
People
MyAnalytics
Kaizala
Stream
Whiteboard
Lists
Forms
Yammer
Sway
Planner
Chapter 22 Ten Ways to Rock Delve
Know Thyself with MyAnalytics
Delve Away, Your Docs Are Safe
Delve Consumes OneDrive and SharePoint data
The Search Is On for People and Docs
Act On a Document
Favorite Documents for Later Use
Group Documents in a Board
Documents-at-a-Glance with Cards
Popularity Contest for Documents
Get to Know Your Colleagues
Chapter 23 Ten Microsoft 365 Remote Work Tips
Set Lunch Hours and Enjoy Your Meal
Chill and Decompress: Go Meditate
Start Your Zero-Carbon Commute
Keep Your Promises with Help from AI
Work Late but Let Others Not
Make Your Meeting Worth Their Time
Wrap It Up in Five Minutes
Say Thanks with Praise
Your Status Is Not Complicated
Give a Heads Up with Signatures
Index
EULA