Shelly Cashman Series Microsoft Office 365 & Excel 2016 Comprehensive by Steven M. Freund, ISBN-13: 978-1305870727

Description

Shelly Cashman Series Microsoft Office 365 & Excel 2016 Comprehensive by Steven M. Freund, ISBN-13: 978-1305870727

[PDF eBook eTextbook]

• Publisher: ‎ Cengage Learning; 1st edition (July 12, 2016)
• Language: ‎ English
• ‎816 pages
• ISBN-10: ‎ 1305870727
• ISBN-13: ‎ 978-1305870727

Discover all of the advancements that Microsoft Office and Excel 2016 have to offer with MICROSOFT OFFICE 365 & EXCEL 2016: COMPREHENSIVE — the new edition in the acclaimed Shelly Cashman Series. For more than three decades, the Shelly Cashman Series has effectively introduced advanced computer skills to millions of students like you. MICROSOFT OFFICE 365 & EXCEL 2016: COMPREHENSIVE provides an enhanced learning approach to help you master all aspects of Excel 2016, no matter what your learning style. A trademark, step-by-step, screen-by-screen approach encourages you to expand your understanding of Microsoft Excel 2016 through experimentation, critical thought, and personalization. This new edition delivers effective educational materials specifically designed to introduce more advanced features, improve retention, and prepare you for success in using MS Office and Excel 2016.

Table of Contents:

Contents

Productivity Apps for School and Work

Introduction to OneNote 2016

Introduction to Sway

Introduction to Office Mix

Introduction to Microsoft Edge

Microsoft Office 2016 and Windows 10

Office 2016 and Windows 10: Essential Concepts and Skills

Introduction to the Windows 10 Operating System

Introduction to Microsoft Office 2016

Running and Using an App

Document Properties

Printing, Saving, and Organizing Files

Screen Resolution

Additional Common Features of Office Apps

Renaming, Moving, and Deleting Files

Microsoft Office and Windows Help

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Microsoft Excel 2016

Module 1: Creating a Worksheet and a Chart

Introduction

Project – Personal Budget Worksheet and Chart

Selecting a Cell

Entering Text

Entering Numbers

Calculating a Sum

Using the Fill Handle to Copy a Cell to Adjacent Cells

Formatting the Worksheet

Adding a Pie Chart to the Worksheet

Changing the Sheet Tab Names

Printing a Worksheet

Autocalculate

Correcting Errors

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 2: Formulas, Functions, and Formatting

Introduction

Project – Worksheet with Formulas and Functions

Entering the Titles and Numbers into the Worksheet

Flash Fill

Entering Formulas

Option Buttons

Using the AVERAGE, MAX, and MIN Functions

Verifying Formulas Using Range Finder

Formatting the Worksheet

Checking Spelling

Printing the Worksheet

Displaying and Printing the Formulas Version of the Worksheet

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 3: Working with Large Worksheets, Charting, and What-If Analysis

Introduction

Project – Financial Projection Worksheet with What-If Analysis and Chart

Rotating Text and Using the Fill Handle to Create a Series

Copying a Range of Cells to a Nonadjacent Destination Area

Inserting and Deleting Cells in a Worksheet

Absolute versus Relative Addressing

Making Decisions – The IF Function

Adding and Formatting Sparkline Charts

Formatting the Worksheet

Adding a Clustered Column Chart to the Workbook

Organizing the Workbook

Changing the View of the Worksheet

What-If Analysis

Insights

Accessibility Features

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 4: Financial Functions, Data Tables, and Amortization Schedules

Introduction

Project – Mortgage Payment Calculator with Data Table and Amortization Schedule

Creating Cell Names

Using a Data Table to Analyze Worksheet Data

Creating an Amortization Schedule

Printing Sections of the Worksheet

Protecting and Hiding Worksheets and Workbooks

Formula Checking

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 5: Working with Multiple Worksheets and Workbooks

Introduction

Project – Consolidated Expenses Worksheet

Creating the Consolidated Worksheet

Fill Series

Date, Time, and Round Functions

Format Codes

Creating a Cell Style

Working with Multiple Worksheets

Referencing Cells across Worksheets

Formatting Pie Charts

Creating Separate Files from Worksheets

Consolidating Data by Linking Separate Workbooks

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 6: Creating, Sorting, and Querying a Table

Introduction

Project – Coffee Craft Daily Services

Creating a Table

Using a Lookup Table

Adding Calculated Fields to the Table

Conditional Formatting

Working with Tables in Excel

Sorting a Table

Querying a Table Using AutoFilter

Using Criteria and Extract Ranges

Using Database Functions

Using the Sumif, Countif, Match, and Index Functions

Summarizing Data

Treemap Charts

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots

Introduction

Project – Home Security Systems

Creating Templates

Importing Data

Using the Quick Analysis Gallery

Using the Find and Replace Commands

Inserting a Bar Chart

Working with SmartArt Graphics

Using Screenshots on a Worksheet

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 8: Working with Trendlines, PivotTables, PivotCharts, and Slicers

Introduction

Project – LinkMe Internet Service Provider

Adding a Trendline to a Chart

Creating and Formatting PivotTable Reports

Summary Functions

Creating and Formatting PivotChart Reports

Working with Slicers

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 9: Formula Auditing, Data Validation, and Complex Problem Solving

Introduction

Project – Life Coach Services Scheduling Analysis

Formula Auditing

Data Validation

Customizing Excel Add-Ins

Solving Complex Problems

Using Solver to Solve Complex Problems

Using Scenarios and Scenario Manager to Analyze Data

Summarizing Scenarios

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 10: Data Analysis with Power Tools and Creating Macros

Introduction

Project – Business Decisions Demographics

Get & Transform

Power Pivot

Power View

3D Maps

Power BI

Creating a Home Page with Hyperlinks

Macros

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Module 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel

Introduction

Project – Global Pharmaceutical Company Sales Analysis

Designing the User Interface

Sharing and Collaboration

Gathering Feedback Using Comments

Tracking Changes on a Workbook

Finalizing a Workbook

Summary

Apply Your Knowledge

Extend Your Knowledge

Expand Your World

In the Labs

Index

Steven M. Freund attended the University of Central Florida and serves as a leader instructor of various Microsoft Office, computer concepts, programming, and Internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute, as well as other customer events. Mr. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, Mozilla Firefox, Windows Internet Explorer, Windows, Office, and Dreamweaver books. He has also written numerous successful instructor supplements..

Joy Starks has taught at Indiana University Purdue University Indianapolis for 20 years. She has written chapters in several of the best-selling Shelly Cashman Series Office books and has authored the Photoshop, Java Programming, and Microsoft Publisher series of books. She speaks and presents at various conferences, seminars and forums across the U.S.

For over 15 years, Eric Schmieder has served as a computer technology instructor in adjunct and full-time capacities in curriculum instruction, corporate training, continuing education, economic and workforce development, professional development, small business, and webmaster certificate programs throughout North Carolina. His classroom instruction has served students at NC State University and many schools in the NC Community College System. He is a member of the NC Computer Instructors Association (NCCIA), NC Community College Faculty Association (NCCCFA), Textbook and Academic Authors Association (TAA), and US Distance Learning Association (USDLA). He holds certifications as a Microsoft Certified Trainer and Microsoft Office Master Specialist and is a regular presenter at local and national conferences.

What makes us different?

• Instant Download

• Always Competitive Pricing

• 100% Privacy

• FREE Sample Available

• 24-7 LIVE Customer Support