Microsoft 365 Portable Genius

go site Cover Title Page Copyright Page About the Author Acknowledgments Contents Introduction How Do I Start Using Microsoft 365? Starting and Exiting an App Taking a Look Around Reviewing key screen features Changing views Zooming Working with Files Creating a blank file Exploring templates Opening an existing file Switching to another file Typing in a Word Document Making Your First Cell Entries in Excel Exploring the Excel screen Moving around the sheet Adding text and values Adding dates and times Number formatting on the fly Adding Slide Content in PowerPoint Making and Working with Selections Selecting content in Word Selecting content in Excel Selecting content in PowerPoint Copying or moving a selection Refining Your Content Spell checking your work Using Find and Replace Saving and Closing a File How Do I Develop Document Content in Word? Using Outlining to Organize Your Thoughts More on Navigating, Selecting, and Editing in Word Creating Bulleted and Numbered Lists Working with Tabs and Indent Settings Setting tab stops Setting indents Working with Line, Page, and Section Breaks Creating Columns of Text Using Review Tools to Improve Your Writing Getting word suggestions from the Thesaurus Tracking changes and commenting How Do I Make Changes in Excel? Working with Sheets Adding, renaming, and jumping to a sheet Moving or copying a sheet Cell Editing Basics Making changes Clearing cell contents Using Auto Fill and Filling Series Inserting and Deleting Rows, Columns, and Cells Working with Column Width and Row Height Creating Range Names Using the Name box Using the New Name dialog box Deleting a range name Freezing Rows and Columns On-Screen How Do I Do Math with Excel Formulas and Functions? Entering a Basic Formula Typing the formula Cell and range references in formulas Using the mouse to save time Dealing with minor errors Learning More About Operators and Order of Precedence Reviewing operators in Excel Understanding how order of precedence works Using parentheses in formulas Making a Cell or Range Reference Absolute Rather Than Relative Changing the reference type in a formula How referencing works when filling, copying, or moving a formula Understanding and Using Functions Using AutoSum on the Home or Formulas tab Typing a function in a formula Using the Formulas tab to insert a function Using Range Names in Formulas How Do I Create a PowerPoint Presentation? Understanding Slide Layouts Adding Slides Rearranging and Deleting Slides Working with Content Placeholders Regular content Speaker notes Editing Slide Content Changing Slide Size or Background Preparing and Playing the Slide Show Adding transitions Adding animations Playing the show How Do I Use Formatting to Enhance My Documents? Changing the Number or Date Format in Excel Using number formats Using date and time formats Changing Text Formatting Applying font formatting Applying alignment formatting Changing Paragraph and Page Formatting in Word and PowerPoint Changing overall line spacing Changing spacing before and after paragraphs Working with Borders and Shading Using borders and shading in Word Adding a page border in Word Changing cell borders and shading in Excel Using Styles Understanding Themes Reviewing elements of a theme Changing themes How Do I Use Graphics? Inserting Simple Graphics Shapes Pictures Icons Selecting and Formatting Graphics Adding text to shapes Changing styles Changing sizing and position Working with layering, alignment, and rotation Working with wrapping in Word Creating and Working with SmartArt Adding a SmartArt graphic Editing and rearranging shapes Changing the graphic type and formatting Deleting Graphics How Do I Manage Lists of Information? Adding a Table in Word or PowerPoint Adding the table and making entries Adding and deleting rows or columns Arranging a List in Excel Understanding Excel’s Table Feature Converting a range to a table Importing or connecting to a list of data Resizing a table Adding a total row Sorting and Filtering Lists and Tables Changing Table Styles Converting a Table Back to Regular Content How Do I Present My Data in Charts? Using Different Chart Types Creating a Chart in Excel Creating a Chart in Word or PowerPoint Changing the Chart Type and Layout Formatting Chart Elements Changing the Charted Data Deleting a Chart How Do I Manage Emails and Contacts in Outlook? Adding Your Account Creating and Sending Messages Receiving, Reading, and Replying to Messages Organizing Messages Adding Contacts How Do I Print and Share My Content? Creating Headers and Footers Changing Page Settings Margins Orientation and paper size Scaling an Excel printout Changing Sheet Settings in Excel Adding print titles Controlling whether gridlines and other features print Working with Page Breaks in Excel Setting a print area Viewing and moving breaks Previewing a Printout and Printing Sharing Information in Other Ways Exporting a PDF Using OneDrive Index EULA