Microsoft 365 Portable Genius

Lisa A. Bucki

• Publisher: Wiley
• Year: 2021
• Print ISBN: 9781119763673
• eBook ISBN: 9781119763734
• Edition: 1
• Topic: Informatica
• Subtopic: Applicazioni desktop

Power up your proficiency with this genius guide to popular Microsoft 365 apps

Do you want to make your Microsoft 365 account a productivity behemoth? Do you want to squeeze every last bit of awesome from Word, Excel, and PowerPoint and learn a little more about Outlook, too? Microsoft 365 Portable Genius has got you covered. A seasoned tech expert and trainer, author Lisa A. Bucki shows you how to build Word documents, Excel workbooks, and PowerPoint presentations the right way, as well as how to use high-impact design techniques to make your documents pop.

This book answers 11 key questions about how to make the most of Microsoft 365, providing genius tips as it leads you through the essentials. You'll learn how to:

• Tackle common skills like creating files, adding basic content, navigating in a file, making selections, copying and moving content, and saving files
• Build a new Word document by using outlining, bullets and numbering, columns, and other features for creating and enhancing content
• Enhance Excel workbook files by organizing data on different sheets, filling entries, creating range names, and entering powerful, accurate formulas
• Develop a PowerPoint presentation by choosing the right layout for each slide and adding content to placeholders, and then transform it into an on-screen show with transitions and animations
• Add punchy design and branding by using text formatting, themes, and graphics in your files
• Use lists, tables, and charts to make data easier to interpret
• Create, send, reply to, and organize email in Outlook, as well as add contacts Share file contents on paper or digitally
• Check out the Online Bonus Appendix at Wiley for more genius coverage of topics including additional Excel formula review techniques, essential Excel functions, theme colors and fonts changes, and WordArt

Whether you have used Office in the past or are new to its subscription successor Microsoft 365, Microsoft 365 Portable Genius provides the expert guidance you need to work smarter in Microsoft 365.

Index

• A
• absolute references, 94–97
• Accounting number format (Excel), 132, 133
• accounts (Outlook), 218–220
• active cell (Excel), 21
• adding
  • accounts in Outlook, 218–220
  • animations to PowerPoint slide shows, 124–125
  • borders in Word, 147–148
  • columns to tables in Word and PowerPoint, 183–184
  • contacts in Outlook, 229–230
  • dates in Excel, 23–24
  • hyperlinks in Excel, 22–23
  • PowerPoint slides, 114–116
  • print titles in Excel, 241–242
  • rows to tables in Word and PowerPoint, 183–184
  • slide content in PowerPoint, 26–27
  • SmartArt graphics, 173–175
  • tables in Word and PowerPoint, 182–183
  • text
    • in Excel, 22–23
    • to shapes, 165–166
  • times in Excel, 23–24
  • a total row in Excel, 192–193
  • transitions in PowerPoint slide shows, 123–124
  • values in Excel, 22–23
  • worksheets in Excel, 64–65

• adjusting
  • background of PowerPoint slides, 121–122
  • cell borders/shading in Excel, 148–149
  • chart type/layout, 209–211
  • charted data, 213–215
  • column width in Excel, 73–75
  ...

Table of contents

• Cover
• Table of Contents
• Title Page
• Copyright
• About the Author
• Acknowledgments
• Introduction
• How Do I Start Using Microsoft 365?
• How Do I Develop Document Content in Word?
• How Do I Make Changes in Excel?
• How Do I Do Math with Excel Formulas and Functions?
• How Do I Create a PowerPoint Presentation?
• How Do I Use Formatting to Enhance My Documents?
• How Do I Use Graphics?
• How Do I Manage Lists of Information?
• How Do I Present My Data in Charts?
• How Do I Manage Emails and Contacts in Outlook?
• How Do I Print and Share My Content?
• Index
• End User License Agreement