Microsoft 365 Portable Genius

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