New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive 1st Edition, ISBN-13: 978-0357025765

Description

New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive 1st Edition, ISBN-13: 978-0357025765

[PDF eBook eTextbook]

• Publisher: ‎ Cengage Learning; 1st edition (July 16, 2019)
• Language: ‎ English
• ‎912 pages
• ISBN-10: ‎ 0357025768
• ISBN-13: ‎ 978-0357025765

Develop the Microsoft Office 365 and Excel 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 & EXCEL 2019 COMPREHENSIVE. 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 & EXCEL 2019 COMPREHENSIVE 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.

Table of Contents:

Brief Contents

Table of Contents

Getting to Know Microsoft Office Versions

Using SAM Projects and Textbook Projects

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

Module 5: Generating Reports from Multiple Worksheets and Workbooks: Summarizing Profit and Loss Sta

Session 5.1 Visual Overview: Worksheet Groups and 3-D References

Working with Multiple Worksheets

Viewing a Workbook in Multiple Windows

Working with Worksheet Groups

Writing 3-D References

Session 5.1 Quick Check

Session 5.2 Visual Overview: External References and Links

Linking to External Workbooks

Creating Hyperlinks

Session 5.2 Quick Check

Session 5.3 Visual Overview: Named Ranges and Templates

Simplifying Formulas with Named Ranges

Exploring Workbook Templates

Session 5.3 Quick Check

Review Assignments

Case Problems

Module 6: Managing Data with Data Tools: Analyzing Employment Data

Session 6.1 Visual Overview: Data Ranges, Workbook Panes, and Subtotals

Handling Data in Excel

Using Panes to View Data

Locating Duplicate Records

Sorting Records in a Data Range

Calculating Subtotals

Session 6.1 Quick Check

Session 6.2 Visual Overview: Filters and Excel Tables

Locating Cells Within a Worksheet

Filtering Data

Creating an Excel Table

Session 6.2 Quick Check

Session 6.3 Visual Overview: Slicers and Dashboards

Filtering Data with Slicers

Creating a Dashboard

Session 6.3 Quick Check

Review Assignments

Case Problems

Module 7: Summarizing Data with PivotTables: Preparing a Social Media Marketing Report

Session 7.1 Visual Overview: Summary IF Functions and VLOOKUP

Using Lookup Functions

Exploring Logical Functions

Applying Summary IF Functions

Session 7.1 Quick Check

Session 7.2 Visual Overview: PivotTables

Creating PivotTables

Formatting a PivotTable

Setting PivotTable Options

Setting the PivotTable Design

Session 7.2 Quick Check

Session 7.3 Visual Overview: PivotCharts and Slicers

Introducing PivotCharts

Using Slicers and PivotTables

Drilling Down a PivotTable

Session 7.3 Quick Check

Review Assignments

Case Problems

Module 8: Performing What-If Analyses: Maximizing Profits with the Right Product Mix

Session 8.1 Visual Overview: Data Tables and What-If Analysis

Understanding Cost-Volume Relationships

Working with Data Tables

Creating a Two-Variable Data Table

Session 8.1 Quick Check

Session 8.2 Visual Overview: What-If Scenarios

Exploring Financial Scenarios with Scenario Manager

Creating Scenario Summary Reports

Session 8.2 Quick Check

Session 8.3 Visual Overview: Optimal Solutions with Solver

Optimizing a Product Mix

Finding the Optimal Solution with Solver

Exploring the Iterative Process

Saving and Loading Solver Models

Session 8.3 Quick Check

Review Assignments

Case Problems

Module 9: Exploring Financial Tools and Functions: Analyzing a Business Plan

Session 9.1 Visual Overview: Loan and Investment Functions

Introducing Financial Functions

Calculating Borrowing Costs

Creating an Amortization Schedule

Session 9.1 Quick Check

Session 9.2 Visual Overview: Income Statements and Depreciation

Projecting Future Income and Expenses

Calculating Depreciation of Assets

Adding Taxes and Interest Expenses to an Income Statement

Session 9.2 Quick Check

Session 9.3 Visual Overview: NPV and IRR Functions and Auditing

Calculating Interest Rates with the RATE Function

Viewing the Payback Period of an Investment

Calculating Net Present Value

Calculating the Internal Rate of Return

Auditing a Workbook

Session 9.3 Quick Check

Review Assignments

Case Problems

Module 10: Analyzing Data with Business Intelligence Tools: Presenting Sales and Revenue Data

Session 10.1 Visual Overview: Queries and Trendlines

Introducing Business Intelligence

Writing a Data Query

Transforming Data with Queries

Charting Trends

Creating a Forecast Sheet

Session 10.1 Quick Check

Session 10.2 Visual Overview: Power Pivot and the Data Model

Introducing Databases

Exploring the Data Model

Transforming Data with Power Pivot

Creating a PivotTable from the Data Model

Session 10.2 Quick Check

Session 10.3 Visual Overview: Hierarchies and Maps

Working with Outlines and Hierarchies

Viewing Data with Map Charts

Session 10.3 Quick Check

Review Assignments

Case Problems

Module 11: Exploring PivotTable Design: Summarizing Sales and Revenue Data

Session 11.1 Visual Overview: Layouts, Sorting, Filtering, and Grouping

Laying Out a PivotTable

Sorting a PivotTable

Filtering a PivotTable

Grouping PivotTable Fields

Session 11.1 Quick Check

Session 11.2 Visual Overview: Conditional Formats and Calculations

Calculations with PivotTables

Displaying PivotTables with Conditional Formats

Exploring the PivotTable Cache

Working with Calculated Items and Calculated Fields

Session 11.2 Quick Check

Session 11.3 Visual Overview: PivotTable Measures

Introducing PivotTable Design under the Data Model

Calculating Distinct Counts

Creating a Measure

Calculating Measures across Tables and Rows

Retrieving PivotTable Data with GETPIVOTDATA

Exploring Database Functions

Session 11.3 Quick Check

Review Assignments

Case Problems

Module 12: Developing an Excel Application: Creating a Data Entry App

Session 12.1 Visual Overview: WordArt and Funnel Charts

Planning an Excel Application

Creating a WordArt Graphic

Displaying Data with a Funnel Chart

Hiding Error Values with the IFERROR Function

Session 12.1 Quick Check

Session 12.2 Visual Overview: Data Validation and Workbook Protection

Validating Data Entry

Hiding Workbook Content

Protecting Workbook Contents

Session 12.2 Quick Check

Session 12.3 Visual Overview: Macros and Visual Basic for Applications

Loading the Excel Developer Tab

Automating Tasks with Macros

Assigning Macros to Shapes and Buttons

Working with the VBA Editor

Protecting against Macro Viruses

Session 12.3 Quick Check

Review Assignments

Case Problems

Index

A leading textbook author, lecturer and instructor, Patrick Carey has authored or co-authored more than 40 popular academic and trade texts for the academic market. He has taught and written about a wide range of topics, including website design, JavaScript programming, Microsoft Office and Excel, statistics, data analysis and mathematics. Mr. Carey received his M.S. in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. Today, he splits his time between Wisconsin and Colorado, and when he is not writing, he can be found hiking and cycling.

What makes us different?

• Instant Download

• Always Competitive Pricing

• 100% Privacy

• FREE Sample Available

• 24-7 LIVE Customer Support