Shelly Cashman Series Microsoft Office 365 & Office 2019 Introductory

Cover
Brief Contents
Contents
Getting to Know Microsoft Office Versions
Using SAM Projects and Textbook Projects
Word 2019
	Module 1: Creating and Modifying a Flyer
		What Is Word?
		Introduction
		Project: Flyer with a Picture
		Starting and Using Word
		Entering Text in a Document
		Formatting Paragraphs and Characters
		Inserting and Formatting a Picture in a Word Document
		Enhancing the Page
		Correcting Errors and Revising a Document
		Using Word Help
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
	Module 2: Creating a Research Paper
		Introduction
		Project: Research Paper
		Changing Document Settings
		Creating a Header
		Typing the Research Paper Text
		Creating an Alphabetical Works Cited Page
		Proofreading and Revising the Research Paper
		Working with Comments in a Document
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
	Module 3: Creating a Business Letter
		Introduction
		Project: Business Letter
		Creating a Letterhead
		Creating a Business Letter
		Working with SmartArt Graphics
		Addressing and Printing Envelopes and Mailing Labels
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
PowerPoint 2019
	Module 1: Creating and Editing Presentations with Pictures
		What Is PowerPoint?
		Project: Presentation with a Bulleted List and Pictures
		Starting and Using PowerPoint
		Creating a Title Slide
		Formatting Characters
		Adding a Slide with a Bulleted List
		Adding Slides, Changing Slide Layouts, and Changing the Theme
		Inserting, Resizing, and Moving Pictures
		Resizing Photos and Illustrations
		Making Changes to Slide Text Content
		Saving and Printing Files
		Using PowerPoint Help
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
	Module 2: Enhancing Presentations with Shapes and SmartArt
		Introduction
		Project-Presentation with SmartArt and Shapes
		Downloading a Theme and Editing Slides
		Creating and Formatting a SmartArt Graphic
		Inserting and Formatting a Shape
		Positioning Slide Elements
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
	Module 3: Inserting WordArt, Charts, and Tables
		Introduction
		Project-Presentation with WordArt, a Chart, and a Table
		Adding a Chart to a Slide and Formatting
		Adding a Table to a Slide and Formatting
		Inserting and Formatting a Text Box
		Inserting and Moving Slides
		Inserting Pictures and Adding Effects
		Creating and Formatting WordArt
		Animating Slide Content
		Adding Media to Slides
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
Microsoft Excel 2019
	Module 1: Creating a Worksheet and a Chart
		Introduction
		Project: Real Estate Budget Worksheet and Chart
		Starting and Using Excel
		Selecting a Cell
		Entering Text
		Entering Numbers
		Calculating Sums and Using Formulas
		Using the Fill Handle to Copy a Cell to Adjacent Cells
		Calculating Average, Maximum, and Minimum Values
		Saving the Project
		Formatting the Worksheet
		Adding a Pie Chart to the Worksheet
		Changing the Sheet Tab Names and Colors
		Document Properties
		Printing a Worksheet
		Viewing Automatic Calculations
		Correcting Errors
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
	Module 2: Formulas, Functions, and Formatting
		Introduction
		Project: Worksheet with Formulas and Functions
		Entering the Titles and Numbers into the Worksheet
		Flash Fill
		Entering Formulas
		Option Buttons
		Using the AVERAGE, MAX, MIN, and Other Statistical Functions
		Verifying Formulas Using Range Finder
		Formatting the Worksheet
		Checking Spelling
		Printing the Worksheet
		Displaying and Printing the Formulas Version of the Worksheet
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
	Module 3: Working with Large Worksheets, Charting, and What-If Analysis
		Introduction
		Project: Financial Projection Worksheet with What-If Analysis and Chart
		Rotating Text and Using the Fill Handle to Create a Series
		Copying a Range of Cells to a Nonadjacent Destination Area
		Inserting and Deleting Cells in a Worksheet
		Absolute versus Relative Addressing
		Making Decisions-The IF Function
		Adding and Formatting Sparkline Charts
		Formatting the Worksheet
		Adding a Clustered Column Chart to the Workbook
		Organizing the Workbook
		Changing the View of the Worksheet
		What-If Analysis
		Insights
		Accessibility Features
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
Microsoft Access 2019
	Module 1: Databases and Database Objects: An Introduction
		Introduction
		Project-Database Creation
		Creating a Database
		The Access Window
		Determining Tables and Fields
		Creating a Table in Datasheet View
		Additional Database Objects
		Database Properties
		Special Database Operations
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
	Module 2: Querying a Database
		Introduction
		Project-Querying a Database
		Creating Queries
		Sorting
		Joining Tables
		Creating a Form for a Query
		Exporting Data from Access to Other Applications
		Adding Criteria to a Join Query
		Calculations
		Crosstab Queries
		Customizing the Navigation Pane
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Lab
	Module 3: Maintaining a Database
		Introduction
		Project-Maintaining a Database
		Updating Records
		Filtering Records
		Changing the Database Structure
		Mass Changes
		Validation Rules
		Making Additional Changes to the Database
		Changing the Appearance of a Datasheet
		Multivalued Fields in Queries
		Referential Integrity
		Ordering Records
		Summary
		Apply Your Knowledge
		Extend Your Knowledge
		Expand Your World
		In the Labs
Index