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
Donate to keep this site alive
To access the Link, solve the captcha.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.
