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


