{"product_id":"microsoft-365-portable-genius-isbn-9781119763673","title":"Microsoft 365 Portable Genius","description":"\u003cp\u003e\u003cb\u003ePower up your proficiency with this genius guide to popular Microsoft 365 apps\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDo 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.\u003c\/p\u003e \u003cp\u003eThis 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:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eTackle common skills like creating files, adding basic content, navigating in a file, making selections, copying and moving content, and saving files\u003c\/li\u003e \u003cli\u003eBuild a new Word document by using outlining, bullets and numbering, columns, and other features for creating and enhancing content\u003c\/li\u003e \u003cli\u003eEnhance Excel workbook files by organizing data on different sheets, filling entries, creating range names, and entering powerful, accurate formulas\u003c\/li\u003e \u003cli\u003eDevelop 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\u003c\/li\u003e \u003cli\u003eAdd punchy design and branding by using text formatting, themes, and graphics in your files\u003c\/li\u003e \u003cli\u003eUse lists, tables, and charts to make data easier to interpret\u003c\/li\u003e \u003cli\u003eCreate, send, reply to, and organize email in Outlook, as well as add contacts Share file contents on paper or digitally\u003c\/li\u003e \u003cli\u003eCheck 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\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eWhether 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.\u003c\/p\u003e \u003cp\u003eAbout the Author iii\u003c\/p\u003e \u003cp\u003eAcknowledgments v\u003c\/p\u003e \u003cp\u003eIntroduction xi\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 How Do I Start Using Microsoft 365? 2\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eStarting and Exiting an App 4\u003c\/p\u003e \u003cp\u003eTaking a Look Around 6\u003c\/p\u003e \u003cp\u003eReviewing key screen features 6\u003c\/p\u003e \u003cp\u003eChanging views 8\u003c\/p\u003e \u003cp\u003eZooming 10\u003c\/p\u003e \u003cp\u003eWorking with Files 11\u003c\/p\u003e \u003cp\u003eCreating a blank file 11\u003c\/p\u003e \u003cp\u003eExploring templates 12\u003c\/p\u003e \u003cp\u003eOpening an existing file 14\u003c\/p\u003e \u003cp\u003eSwitching to another file 15\u003c\/p\u003e \u003cp\u003eTyping in a Word Document 17\u003c\/p\u003e \u003cp\u003eMaking Your First Cell Entries in Excel 19\u003c\/p\u003e \u003cp\u003eExploring the Excel screen 19\u003c\/p\u003e \u003cp\u003eMoving around the sheet 21\u003c\/p\u003e \u003cp\u003eAdding text and values 22\u003c\/p\u003e \u003cp\u003eAdding dates and times 23\u003c\/p\u003e \u003cp\u003eNumber formatting on the fly 24\u003c\/p\u003e \u003cp\u003eAdding Slide Content in PowerPoint 26\u003c\/p\u003e \u003cp\u003eMaking and Working with Selections 27\u003c\/p\u003e \u003cp\u003eSelecting content in Word 27\u003c\/p\u003e \u003cp\u003eSelecting content in Excel 28\u003c\/p\u003e \u003cp\u003eSelecting content in PowerPoint 30\u003c\/p\u003e \u003cp\u003eCopying or moving a selection 31\u003c\/p\u003e \u003cp\u003eRefining Your Content 33\u003c\/p\u003e \u003cp\u003eSpell checking your work 34\u003c\/p\u003e \u003cp\u003eUsing Find and Replace 36\u003c\/p\u003e \u003cp\u003eSaving and Closing a File 37\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 How Do I Develop Document Content in Word? 40\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Outlining to Organize Your Thoughts 42\u003c\/p\u003e \u003cp\u003eMore on Navigating, Selecting, and Editing in Word 44\u003c\/p\u003e \u003cp\u003eCreating Bulleted and Numbered Lists 47\u003c\/p\u003e \u003cp\u003eWorking with Tabs and Indent Settings 49\u003c\/p\u003e \u003cp\u003eSetting tab stops 50\u003c\/p\u003e \u003cp\u003eSetting indents 52\u003c\/p\u003e \u003cp\u003eWorking with Line, Page, and Section Breaks 54\u003c\/p\u003e \u003cp\u003eCreating Columns of Text 56\u003c\/p\u003e \u003cp\u003eUsing Review Tools to Improve Your Writing 57\u003c\/p\u003e \u003cp\u003eGetting word suggestions from the Thesaurus 58\u003c\/p\u003e \u003cp\u003eTracking changes and commenting 58\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 How Do I Make Changes in Excel? 62\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with Sheets 64\u003c\/p\u003e \u003cp\u003eAdding, renaming, and jumping to a sheet 64\u003c\/p\u003e \u003cp\u003eMoving or copying a sheet 65\u003c\/p\u003e \u003cp\u003eCell Editing Basics 66\u003c\/p\u003e \u003cp\u003eMaking changes 66\u003c\/p\u003e \u003cp\u003eClearing cell contents 67\u003c\/p\u003e \u003cp\u003eUsing Auto Fill and Filling Series 68\u003c\/p\u003e \u003cp\u003eInserting and Deleting Rows, Columns, and Cells 71\u003c\/p\u003e \u003cp\u003eWorking with Column Width and Row Height 73\u003c\/p\u003e \u003cp\u003eCreating Range Names 75\u003c\/p\u003e \u003cp\u003eUsing the Name box 76\u003c\/p\u003e \u003cp\u003eUsing the New Name dialog box 77\u003c\/p\u003e \u003cp\u003eDeleting a range name 78\u003c\/p\u003e \u003cp\u003eFreezing Rows and Columns On-Screen 79\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 How Do I Do Math with Excel Formulas and Functions? 82\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEntering a Basic Formula 84\u003c\/p\u003e \u003cp\u003eTyping the formula 84\u003c\/p\u003e \u003cp\u003eCell and range references in formulas 85\u003c\/p\u003e \u003cp\u003eUsing the mouse to save time 86\u003c\/p\u003e \u003cp\u003eDealing with minor errors 88\u003c\/p\u003e \u003cp\u003eLearning More About Operators and Order of Precedence 88\u003c\/p\u003e \u003cp\u003eReviewing operators in Excel 89\u003c\/p\u003e \u003cp\u003eUnderstanding how order of precedence works 91\u003c\/p\u003e \u003cp\u003eUsing parentheses in formulas 93\u003c\/p\u003e \u003cp\u003eMaking a Cell or Range Reference Absolute Rather Than Relative 94\u003c\/p\u003e \u003cp\u003eChanging the reference type in a formula 94\u003c\/p\u003e \u003cp\u003eHow referencing works when filling, copying, or moving a formula 95\u003c\/p\u003e \u003cp\u003eUnderstanding and Using Functions 97\u003c\/p\u003e \u003cp\u003eUsing AutoSum on the Home or Formulas tab 98\u003c\/p\u003e \u003cp\u003eTyping a function in a formula 101\u003c\/p\u003e \u003cp\u003eUsing the Formulas tab to insert a function 103\u003c\/p\u003e \u003cp\u003eUsing Range Names in Formulas 107\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 How Do I Create a PowerPoint Presentation? 110\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Slide Layouts 112\u003c\/p\u003e \u003cp\u003eAdding Slides 114\u003c\/p\u003e \u003cp\u003eRearranging and Deleting Slides 116\u003c\/p\u003e \u003cp\u003eWorking with Content Placeholders 117\u003c\/p\u003e \u003cp\u003eRegular content 117\u003c\/p\u003e \u003cp\u003eSpeaker notes 119\u003c\/p\u003e \u003cp\u003eEditing Slide Content 120\u003c\/p\u003e \u003cp\u003eChanging Slide Size or Background 121\u003c\/p\u003e \u003cp\u003ePreparing and Playing the Slide Show 122\u003c\/p\u003e \u003cp\u003eAdding transitions 123\u003c\/p\u003e \u003cp\u003eAdding animations 124\u003c\/p\u003e \u003cp\u003ePlaying the show 125\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 How Do I Use Formatting to Enhance My Documents? 128\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChanging the Number or Date Format in Excel 130\u003c\/p\u003e \u003cp\u003eUsing number formats 132\u003c\/p\u003e \u003cp\u003eUsing date and time formats 134\u003c\/p\u003e \u003cp\u003eChanging Text Formatting 134\u003c\/p\u003e \u003cp\u003eApplying font formatting 135\u003c\/p\u003e \u003cp\u003eApplying alignment formatting 139\u003c\/p\u003e \u003cp\u003eChanging Paragraph and Page\u003c\/p\u003e \u003cp\u003eFormatting in Word and PowerPoint 142\u003c\/p\u003e \u003cp\u003eChanging overall line spacing 143\u003c\/p\u003e \u003cp\u003eChanging spacing before and after paragraphs 143\u003c\/p\u003e \u003cp\u003eWorking with Borders and Shading 146\u003c\/p\u003e \u003cp\u003eUsing borders and shading in Word 146\u003c\/p\u003e \u003cp\u003eAdding a page border in Word 147\u003c\/p\u003e \u003cp\u003eChanging cell borders and shading in Excel 148\u003c\/p\u003e \u003cp\u003eUsing Styles 149\u003c\/p\u003e \u003cp\u003eUnderstanding Themes 152\u003c\/p\u003e \u003cp\u003eReviewing elements of a theme 152\u003c\/p\u003e \u003cp\u003eChanging themes 153\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 How Do I Use Graphics? 156\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eInserting Simple Graphics 158\u003c\/p\u003e \u003cp\u003eShapes 158\u003c\/p\u003e \u003cp\u003ePictures 160\u003c\/p\u003e \u003cp\u003eIcons 164\u003c\/p\u003e \u003cp\u003eSelecting and Formatting Graphics 165\u003c\/p\u003e \u003cp\u003eAdding text to shapes 165\u003c\/p\u003e \u003cp\u003eChanging styles 166\u003c\/p\u003e \u003cp\u003eChanging sizing and position 168\u003c\/p\u003e \u003cp\u003eWorking with layering, alignment, and rotation 170\u003c\/p\u003e \u003cp\u003eWorking with wrapping in Word 173\u003c\/p\u003e \u003cp\u003eCreating and Working with SmartArt 173\u003c\/p\u003e \u003cp\u003eAdding a SmartArt graphic 173\u003c\/p\u003e \u003cp\u003eEditing and rearranging shapes 176\u003c\/p\u003e \u003cp\u003eChanging the graphic type and formatting 177\u003c\/p\u003e \u003cp\u003eDeleting Graphics 177\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 How Do I Manage Lists of Information? 180\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdding a Table in Word or PowerPoint 182\u003c\/p\u003e \u003cp\u003eAdding the table and making entries 182\u003c\/p\u003e \u003cp\u003eAdding and deleting rows or columns 183\u003c\/p\u003e \u003cp\u003eArranging a List in Excel 184\u003c\/p\u003e \u003cp\u003eUnderstanding Excel’s Table Feature 187\u003c\/p\u003e \u003cp\u003eConverting a range to a table 187\u003c\/p\u003e \u003cp\u003eImporting or connecting to a list of data 189\u003c\/p\u003e \u003cp\u003eResizing a table 192\u003c\/p\u003e \u003cp\u003eAdding a total row 192\u003c\/p\u003e \u003cp\u003eSorting and Filtering Lists and Tables 193\u003c\/p\u003e \u003cp\u003eChanging Table Styles 197\u003c\/p\u003e \u003cp\u003eConverting a Table Back to Regular Content 198\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 How Do I Present My Data in Charts? 200\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Different Chart Types 202\u003c\/p\u003e \u003cp\u003eCreating a Chart in Excel 203\u003c\/p\u003e \u003cp\u003eCreating a Chart in Word or PowerPoint 207\u003c\/p\u003e \u003cp\u003eChanging the Chart Type and Layout 209\u003c\/p\u003e \u003cp\u003eFormatting Chart Elements 211\u003c\/p\u003e \u003cp\u003eChanging the Charted Data 213\u003c\/p\u003e \u003cp\u003eDeleting a Chart 215\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 How Do I Manage Emails and Contacts in Outlook? 216\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdding Your Account 218\u003c\/p\u003e \u003cp\u003eCreating and Sending Messages 220\u003c\/p\u003e \u003cp\u003eReceiving, Reading, and Replying to Messages 224\u003c\/p\u003e \u003cp\u003eOrganizing Messages 227\u003c\/p\u003e \u003cp\u003eAdding Contacts 229\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 How Do I Print and Share My Content? 232\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating Headers and Footers 234\u003c\/p\u003e \u003cp\u003eChanging Page Settings 238\u003c\/p\u003e \u003cp\u003eMargins 238\u003c\/p\u003e \u003cp\u003eOrientation and paper size 240\u003c\/p\u003e \u003cp\u003eScaling an Excel printout 240\u003c\/p\u003e \u003cp\u003eChanging Sheet Settings in Excel 241\u003c\/p\u003e \u003cp\u003eAdding print titles 241\u003c\/p\u003e \u003cp\u003eControlling whether gridlines and other features print 243\u003c\/p\u003e \u003cp\u003eWorking with Page Breaks in Excel 243\u003c\/p\u003e \u003cp\u003eSetting a print area 243\u003c\/p\u003e \u003cp\u003eViewing and moving breaks 245\u003c\/p\u003e \u003cp\u003ePreviewing a Printout and Printing 246\u003c\/p\u003e \u003cp\u003eSharing Information in Other Ways 247\u003c\/p\u003e \u003cp\u003eExporting a PDF 247\u003c\/p\u003e \u003cp\u003eUsing OneDrive 249\u003c\/p\u003e \u003cp\u003eIndex 251\u003c\/p\u003e \u003cp\u003e\u003cb\u003eLisa A. Bucki\u003c\/b\u003e 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.\u003cbr\u003eFun, 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.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eTHE GENIUS IS IN.\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eYou don't have to be a genius to use Microsoft 365. But to get the most out of your subscription, up your game with this savvy \u003ci\u003ePortable Genius\u003c\/i\u003e guide. Want to create a new Word document incorporating columns and graphics? Build powerful Excel formulas? Develop PowerPoint presentations with sleek slides and professional transitions? Handle email in Outlook? Whether you've used past versions of Office or you're brand new to Microsoft 365, you'll find cool and useful Genius tips, numerous screenshots, and pages of shortcuts and expert advice to save you loads of time and pump up your Microsoft 365 skills.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989622702309,"sku":"NP9781119763673","price":19.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119763673.jpg?v=1761784847","url":"https:\/\/k12savings.com\/products\/microsoft-365-portable-genius-isbn-9781119763673","provider":"K12savings","version":"1.0","type":"link"}