Instruction Manual for New Perspectives Microsoft Office 365 and Excel 2016 Comprehensive 1st edition by June Jamrich Parsons, Dan Oja, Patrick Carey, Carol DesJardins ISBN 1305880404 9781305880405

Instruction Manual for New Perspectives Microsoft Office 365 & Excel 2016 Comprehensive 1st edition by June Jamrich Parsons, Dan Oja, Patrick Carey, Carol DesJardins – Ebook PDF Instant Download/Delivery: 1305880404,  9781305880405
Full download New Perspectives Microsoft Office 365 & Excel 2016 Comprehensive 1st edition after payment

Product details:

ISBN 10: 1305880404
ISBN 13: 9781305880405
Author:  June Jamrich Parsons, Dan Oja, Patrick Carey, Carol DesJardins

Help your students develop the complete set of Microsoft® Excel 2016 skills they 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 & EXCEL 2016: COMPREHENSIVE. Updated to provide all-new case scenarios, this dynamic introduction applies the skills students are learning to real-world situations to ensure that concepts remain highly relevant. New Productivity Apps provide a visual introduction to Microsoft® OneNote, Sway, Office Mix and Edge with fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help students learn to use each app. With an unmatched emphasis on learning outcomes and transference of skills, NEW PERSPECTIVES MICROSOFT® OFFICE 365 & EXCEL 2016: COMPREHENSIVE engages students by clearly demonstrating the importance of the complete Microsoft® Excel 2016 skills that they are learning.

New Perspectives Microsoft Office 365 & Excel 2016 Comprehensive 1st Table of contents:

1-1. Introduction to OneNote 2016

1-1a. Creating a OneNote Notebook
1-1b. Syncing a Notebook to the Cloud
1-1c. Taking Notes
1-1d. Converting Handwriting to Text
1-1e. Recording a Lecture

1-2. Try This Now

1-3. Introduction to Sway

1-3a. Creating a Sway Presentation
1-3b. Adding Content to Build a Story
1-3c. Designing a Sway
1-3d. Publishing a Sway
1-3e. Sharing a Sway

1-4. Try This Now

1-5. Introduction to Office Mix

1-5a. Adding Office Mix to PowerPoint
1-5b. Capturing Video Clips
1-5c. Inserting Quizzes, Live Webpages, and Apps
1-5d. Sharing an Office Mix presentation

1-6. Try This Now

1-7. Introduction to Microsoft Edge

1-7a. Browsing the Web with Microsoft Edge
1-7b. Locating Information with Cortana
1-7c. Annotating Webpages

1-8. Try This Now

---

Excel 2016

Module 1. Getting Started with Excel

Session 1.1 Visual Overview: The Excel Workbook

• Introducing Excel and Spreadsheets

• Opening an Existing Workbook

• Using Keyboard Shortcuts to Work Faster

• Getting Help

• Using Excel 2016 in Touch Mode

• Exploring a Workbook

• Changing the Active Sheet

• Navigating Within a Worksheet

• Selecting a Cell Range

• Closing a Workbook

• Planning a Workbook

• Starting a New Workbook

• Renaming and Inserting Worksheets

• Moving Worksheets

• Deleting Worksheets

• Saving a Workbook

• Entering Text, Dates, and Numbers

• Entering Text

• Undoing and Redoing an Action

• Editing Cell Content

• Understanding AutoComplete

• Displaying Numbers as Text

• Entering Dates

• Entering Numbers

• Resizing Columns and Rows

• Changing Column Widths

• Wrapping Text Within a Cell

• Changing Row Heights

• Review. Session 1.1 Quick Check

Session 1.2 Visual Overview: Excel Formulas and Functions

• Performing Calculations with Formulas

• Entering a Formula

• Copying and Pasting Formulas

• Simplifying Formulas with Functions

• Introducing Function Syntax

• Entering Functions with AutoSum

• Modifying a Worksheet

• Moving and Copying a Cell or Range

• Using the COUNT Function

• Inserting a Column or Row

• Deleting a Row or Column

• Inserting and Deleting a Range

• Using Flash Fill

• Formatting a Worksheet

• Adding Cell Borders

• Changing the Font Size

• Printing a Workbook

• Changing Worksheet Views

• Changing the Page Orientation

• Setting the Scaling Options

• Setting the Print Options

• Viewing Worksheet Formulas

• Saving a Workbook with a New Filename

• Review. Session 1.2 Quick Check

• Practice: Review Assignments

• Apply: Case Problem 1

• Create: Case Problem 2

• Challenge: Case Problem 3

• Troubleshoot: Case Problem 4

Module 2. Formatting Workbook Text and Data

Session 2.1 Visual Overview: Formatting a Worksheet

• Formatting Cell Text

• Applying Fonts and Font Styles

• Applying a Font Color

• Formatting Text Selections Within a Cell

• Working with Fill Colors and Backgrounds

• Changing a Fill Color

• Adding a Background Image

• Using Functions and Formulas to Calculate Sales Data

• Formatting Numbers

• Applying Number Formats

• Formatting Dates and Times

• Formatting Worksheet Cells

• Aligning Cell Content

• Indenting Cell Content

• Adding Borders to Cells

• Merging Cells

• Rotating Cell Contents

• Exploring the Format Cells Dialog Box

• Review. Session 2.1 Quick Check

Session 2.2 Visual Overview: Designing a Printout

• Calculating Averages

• Applying Cell Styles

• Copying and Pasting Formats

• Copying Formats with the Format Painter

• Copying Formats with the Paste Options Button

• Copying Formats with Paste Special

• Finding and Replacing Text and Formats

• Working with Themes

• Highlighting Data with Conditional Formats

• Highlighting Cells Based on Their Values

• Highlighting Cells with a Top/Bottom Rule

• Other Conditional Formatting Options

• Creating a Conditional Formatting Legend

• Formatting a Worksheet for Printing

• Using Page Break Preview

• Defining the Print Area

• Inserting Page Breaks

• Adding Print Titles

• Designing Headers and Footers

• Setting the Page Margins

• Review. Session 2.2 Quick Check

• Practice: Review Assignments

• Apply: Case Problem 1

• Apply: Case Problem 2

• Challenge: Case Problem 3

• Create: Case Problem 4

Module 3. Performing Calculations with Formulas and Functions

Session 3.1 Visual Overview: Formulas and Functions

• Making Workbooks User-Friendly

• Documenting Formulas

• Using Constants in Formulas

• Identifying Notes, Input Values, and Calculated Values

• Using Excel Functions

• Understanding Function Syntax

• Entering the COUNT function

• Nesting the ROUND and AVERAGE Functions

• Using the Function Library and the Insert Function Dialog Box

• Performing What-If Analyses

• Using Trial and Error

• Using Goal Seek

• Interpreting Error Values

• Review. Session 3.1 Quick Check

Session 3.2 Visual Overview: Cell References and Formulas

• AutoFilling Formulas and Data

• Filling a Series

• Exploring Auto Fill Options

• Filling Formulas

• Exploring Cell References

• Understanding Relative References

• Understanding Absolute References

• Understanding Mixed References

• Changing Cell References in a Formula

• Summarizing Data with the Quick Analysis Tool

• Working with Dates and Date Functions

• Using Lookup Functions

• Finding an Exact Match with the VLOOKUP Function

• Working with Logical Functions

• Review. Session 3.2 Quick Check

• Practice: Review Assignments

• Apply: Case Problem 1

• Apply: Case Problem 2

• Challenge: Case Problem 3

• Challenge: Case Problem 4

---

Module 4. Analyzing and Charting Financial Data

Session 4.1 Visual Overview: Chart Elements

• Introduction to Financial Functions

• Using the PMT Function

• Getting Started with Excel Charts

• Creating a Pie Chart

• Selecting the Data Source

• Charting with the Quick Analysis Tool

• Moving and Resizing a Chart

• Working with Chart Elements

• Choosing a Chart Style

• Formatting a Chart Legend

• Formatting Pie Chart Labels

• Changing the Pie Slice Colors

• Formatting the Chart Area

• Performing What-If Analyses with Charts

• Creating a Column Chart

• Comparing Column Chart Subtypes

• Creating a Clustered Column Chart

• Moving a Chart to a Different Worksheet

• Editing a Chart Title

• Creating a Stacked Column Chart

• Review. Session 4.1 Quick Check

Session 4.2 Visual Overview: Charts, Sparklines, and Data Bars

• Creating a Line Chart

• Working with Axes and Gridlines

• Editing the Scale of the Vertical Axis

• Adding Gridlines to a Chart

• Working with Column Widths

• Formatting Data Markers

• Formatting the Plot Area

• Creating a Combination Chart

• Working with Primary and Secondary Axes

• Editing a Chart Data Source

• Exploring Other Chart Types

• Creating a Histogram

• Creating a Pareto Chart

• Using a Waterfall Chart

• Using a Hierarchical Chart

• Creating Sparklines

• Formatting the Sparkline Axis

• Working with Sparkline Groups

• Creating Data Bars

• Modifying a Data Bar Rule

• Review. Session 4.2 Quick Check

• Practice: Review Assignments

• Apply: Case Problem 1

• Apply: Case Problem 2

• Challenge: Case Problem 3

• Create: Case Problem 4

People also search for New Perspectives Microsoft Office 365 & Excel 2016 Comprehensive 1st:

new perspectives microsoft office 365 & access 2019 comprehensive pdf

new perspectives microsoft office 365 & excel 2019 comprehensive pdf

new perspectives microsoft office 365 & office 2019 introductory

new perspectives microsoft office 365 & excel 2016 intermediate

new perspectives microsoft office 365 office 2016 brief

Tags: June Jamrich Parsons, Dan Oja, Patrick Carey, Carol DesJardins, New Perspectives, 2016 Comprehensive