Sale!

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

Original price was: $50.00.Current price is: $14.99.

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

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.