New Perspectives MicrosoftOffice 365 & Office 2019 Introductory

Length: 1032 pages
Edition: 1
Language: English
Publisher: Cengage Learning
Publication Date: 2019-03-05
ISBN-10: 0357025741
ISBN-13: 9780357025741
Sales Rank: #52547 (See Top 100 Books)

Develop the Microsoft Office 365 and Office 2019 skills students need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT OFFICE 365 & OFFICE 2019 INTRODUCTORY. Updated with all-new case scenarios, this edition clearly applies the skills students are learning to real-world situations to make concepts even more relevant across the applications and reinforces critical skills to make them successful in their educational and professional careers. NEW PERSPECTIVES MICROSOFT OFFICE 365 & OFFICE 2019 INTRODUCTORY demonstrates the importance of what students are learning while strengthening your skills and helping students transfer those skills to other applications and disciplines for further success. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.

Cover
Brief Contents
Table of Contents
Getting to Know Microsoft Office Versions
Using SAM Projects and Textbook Projects
Word Modules
	Module 1: Creating and Editing a Document: Writing a Business Letter and Formatting a Flyer
		Session 1.1 Visual Overview: The Word Window
		Starting Word
		Setting Up the Word Window
		Saving a Document
		Entering Text
		Using the Undo and Redo Buttons
		Correcting Errors as You Type
		Proofreading a Document
		Adjusting Paragraph and Line Spacing
		Adjusting the Margins
		Previewing and Printing a Document
		Creating an Envelope
		Session 1.1 Quick Check
		Session 1.2 Visual Overview: Formatting a Document
		Opening an Existing Document
		Using the Editor Pane
		Changing Page Orientation
		Changing the Font and Font Size
		Applying Text Effects, Font Colors, and Font Styles
		Aligning Text
		Adding a Paragraph Border and Shading
		Copying Formatting with the Format Painter
		Inserting a Picture and Adding Alt Text
		Adding a Page Border
		Creating Bulleted and Numbered Lists
		Getting Help
		Session 1.2 Quick Check
		Review Assignments
		Case Problems
	Module 2: Navigating and Formatting a Document: Editing an Academic Document According to MLA Style
		Session 2.1 Visual Overview: The Navigation Pane and Styles
		Reviewing the Document
		Working with Comments
		Moving Text in a Document
		Using the Navigation Pane
		Finding and Replacing Text
		Working with Styles
		Session 2.1 Quick Check
		Session 2.2 Visual Overview: MLA Formatting Guidelines
		Reviewing the MLA Style
		Indenting a Paragraph
		Inserting and Modifying Page Numbers
		Creating a Footnote
		Creating Citations and a Bibliography
		Session 2.2 Quick Check
		Review Assignments
		Case Problems
	Module 3: Creating Tables and a Multipage Report: Writing a Recommendation
		Session 3.1 Visual Overview: Organizing Information in Tables
		Working with Headings in the Navigation Pane
		Collapsing and Expanding Body Text in the Document
		Inserting a Blank Table
		Entering Data in a Table
		Selecting Part of a Table
		Sorting Rows in a Table
		Inserting Rows and Columns in a Table
		Deleting Rows and Columns
		Changing Column Widths and Row Heights
		Formatting Tables with Styles
		Adding Formulas
		Merging Cells
		Session 3.1 Quick Check
		Session 3.2 Visual Overview: Working with Headers and Footers
		Setting Tab Stops
		Hyphenating a Document
		Formatting a Document into Sections
		Creating SmartArt
		Adding Headers and Footers
		Inserting a Cover Page
		Working with Themes
		Reviewing a Document in Read Mode
		Session 3.2 Quick Check
		Review Assignments
		Case Problems
	Module 4: Enhancing Page Layout and Design: Creating a Newsletter
		Session 4.1 Visual Overview: Elements of Desktop Publishing
		Using Continuous Section Breaks to Enhance Page Layout
		Formatting Text in Columns
		Inserting Symbols and Special Characters
		Introduction to Working with Objects
		Inserting Text Boxes
		Inserting Drop Caps
		Session 4.1 Quick Check
		Session 4.2 Visual Overview: Editing Pictures
		Formatting Text with WordArt
		Working with Pictures
		Balancing Columns
		Enhancing the Newsletter's Formatting
		Saving a Document as a PDF
		Converting a PDF to a Word Document
		Session 4.2 Quick Check
		Review Assignments
		Case Problems
Excel Modules
	Module 1: Getting Started with Excel: Tracking Miscellaneous Expenses for a Conference
		Session 1.1 Visual Overview: The Excel Workbook
		Introducing Excel and Spreadsheets
		Exploring a Workbook
		Closing a Workbook
		Planning a Workbook
		Starting a New Workbook
		Entering Text, Dates, and Numbers
		Resizing Columns and Rows
		Session 1.1 Quick Check
		Session 1.2 Visual Overview: Excel Formulas and Functions
		Calculating with Formulas
		Calculating with Functions
		Modifying a Worksheet
		Using the COUNT Function
		Modifying Rows and Columns
		Using Flash Fill
		Formatting a Worksheet
		Printing a Workbook
		Viewing Worksheet Formulas
		Session 1.2 Quick Check
		Review Assignments
		Case Problems
	Module 2: Formatting Workbook Text and Data: Creating a Sales Report
		Session 2.1 Visual Overview: Formatting a Worksheet
		Formatting Cell Text
		Working with Fill Colors and Backgrounds
		Using Functions and Formulas with Sales Data
		Formatting Numbers
		Formatting Worksheet Cells
		Exploring the Format Cells Dialog Box
		Session 2.1 Quick Check
		Session 2.2 Visual Overview: Designing a Printout
		Calculating Averages
		Applying Cell Styles
		Copying and Pasting Formats
		Finding and Replacing Text and Formats
		Working with Themes
		Highlighting Data with Conditional Formats
		Formatting a Worksheet for Printing
		Session 2.2 Quick Check
		Review Assignments
		Case Problems
	Module 3: Performing Calculations with Formulas and Functions: Staffing a Call Center
		Session 3.1 Visual Overview: Formulas and Functions
		Designing a Workbook for Calculations
		Calculating with Dates and Times
		AutoFilling Formulas and Data Patterns
		Applying Excel Functions
		Interpreting Error Values
		Session 3.1 Quick Check
		Session 3.2 Visual Overview: Lookup Tables and Logical Functions
		Calculating Running Totals with the Quick Analysis Tool
		Exploring Cell References
		Working with the IF Logical Function
		Formatting Input, Calculated, and Output Values
		Looking Up Data
		Performing What-If Analyses with Formulas and Functions
		Session 3.2 Quick Check
		Review Assignments
		Case Problems
	Module 4: Analyzing and Charting Financial Data: Preparing an Investment Report
		Session 4.1 Visual Overview: Chart Elements
		Getting Started with Excel Charts
		Creating a Pie Chart
		Working with Chart Elements
		Performing What-If Analyses with Charts
		Creating a Column Chart
		Creating a Line Chart
		Creating a Combination Chart
		Session 4.1 Quick Check
		Session 4.2 Visual Overview: Scatter Charts, Data Bars, and Sparklines
		Creating a Scatter Chart
		Editing the Chart Data Source
		Adding Graphic Objects to a Workbook
		Exploring Other Chart Types
		Creating Data Bars
		Creating Sparklines
		Session 4.2 Quick Check
		Review Assignments
		Case Problems
Access Modules
	Module 1: Creating a Database: Tracking Patient, Visit, and Billing Data
		Session 1.1 Visual Overview: The Access Window
		Introduction to Database Concepts
		Starting Access and Creating a Database
		Creating a Table in Datasheet View
		Creating a Table in Design View
		Closing a Table and Exiting Access
		Session 1.1 Quick Check
		Session 1.2 Visual Overview: The Create Tab Options
		Entering Data into Tables
		Copying Records from Another Access Database
		Navigating a Datasheet
		Creating a Simple Query
		Creating a Simple Form
		Creating a Simple Report
		Viewing Objects in the Navigation Pane
		Using Microsoft Access Help
		Managing a Database
		Session 1.2 Quick Check
		Review Assignments
		Case Problems
	Module 2: Building a Database and Defining Table Relationships: Creating the Billing and Patient Tables
		Session 2.1 Visual Overview: Table Window in Design View
		Guidelines for Designing Databases
		Guidelines for Setting Field Properties
		Modifying a Table in Design View
		Modifying the Structure of an Access Table
		Modifying Field Properties
		Session 2.1 Quick Check
		Session 2.2 Visual Overview: Understanding Table Relationships
		Adding Records to a New Table
		Importing Data from an Excel Worksheet
		Creating a Table by Importing an Existing Table or Table Structure
		Adding Fields to a Table Using the Data Type Gallery
		Modifying the Structure of an Imported Table
		Setting the Default Value Property for a Field
		Adding Data to a Table by Importing a Text File
		Defining Table Relationships
		Session 2.2 Quick Check
		Review Assignments
		Case Problems
	Module 3: Maintaining and Querying a Database: Updating and Retrieving Information about Patients, Visits, and Invoices
		Session 3.1 Visual Overview: Query Window in Design View
		Updating a Database
		Introduction to Queries
		Creating and Running a Query
		Updating Data Using a Query
		Creating a Multitable Query
		Sorting Data in a Query
		Filtering Data
		Session 3.1 Quick Check
		Session 3.2 Visual Overview: Selection Criteria in Queries
		Defining Record Selection Criteria for Queries
		Defining Multiple Selection Criteria for Queries
		Changing a Datasheet's Appearance
		Creating a Calculated Field
		Using Aggregate Functions
		Working with the Navigation Pane
		Session 3.2 Quick Check
		Review Assignments
		Case Problems
	Module 4: Creating Forms and Reports: Using Forms and Reports to Display Patient and Visit Data
		Session 4.1 Visual Overview: Form Displayed in Form View
		Creating a Form Using the Form Wizard
		Modifying a Form's Design in Layout View
		Navigating a Form
		Finding Data Using a Form
		Maintaining Table Data Using a Form
		Previewing and Printing Selected Form Records
		Creating a Form with a Main Form and a Subform
		Session 4.1 Quick Check
		Session 4.2 Visual Overview: Report Displayed in Print Preview
		Creating a Report Using the Report Wizard
		Modifying a Report's Design in Layout View
		Using Conditional Formatting in a Report
		Session 4.2 Quick Check
		Review Assignments
		Case Problems
PowerPoint Modules
	Module 1: Creating a Presentation: Presenting Information about an Insurance Company
		Session 1.1 Visual Overview: The PowerPoint Window
		Planning a Presentation
		Starting PowerPoint and Creating a New Presentation
		Creating a Title Slide
		Saving and Editing a Presentation
		Adding New Slides
		Creating Lists
		Formatting Text
		Moving and Copying
		Manipulating Slides
		Changing the Theme
		Closing a Presentation
		Session 1.1 Quick Check
		Session 1.2 Visual Overview: Slide Show and Presenter Views
		Opening a Presentation and Saving It with a New Name
		Inserting Pictures and Adding Alt Text
		Cropping Pictures
		Resizing and Moving Objects
		Compressing Pictures
		Converting a List to a SmartArt Graphic
		Adding Speaker Notes
		Editing Common File Properties
		Checking Spelling
		Running a Slide Show
		Printing a Presentation
		Closing PowerPoint
		Session 1.2 Quick Check
		Review Assignments
		Case Problems
	Module 2: Adding Media and Special Effects: Using Media in a Presentation for a Veterinary Hospital
		Session 2.1 Visual Overview: Formatting Graphics
		Applying a Theme Used in Another Presentation
		Inserting Shapes
		Formatting Objects
		Duplicating Objects
		Rotating and Flipping Objects
		Creating and Formatting a Table
		Inserting Symbols
		Adding Footers and Headers
		Session 2.1 Quick Check
		Session 2.2 Visual Overview: Using Animations and Transitions
		Applying Transitions
		Applying Animations
		Using the Morph Transition
		Adding and Modifying Video
		Compressing Media
		Session 2.2 Quick Check
		Review Assignments
		Case Problems
Index