{"product_id":"microsoft-365-portable-genius-9781119763673","title":"Microsoft 365 Portable Genius","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\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","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49407144526167,"sku":"9781119763673","price":12.79,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119763673.jpg?v=1730498325","url":"https:\/\/bookcurl.com\/products\/microsoft-365-portable-genius-9781119763673","provider":"Book Curl","version":"1.0","type":"link"}