Cengage/Higher Education/Spreadsheets/Shelly Cashman Series® Microsoft® Office 365® & Excel® 2019 Comprehensive
Return to search
New edition available!
The Shelly Cashman Series® Microsoft® Office 365® & Excel® 2021 Comprehensive, 1st Edition is now available.
View course
Shelly Cashman Series® Microsoft® Office 365® & Excel® 2019 Comprehensive book cover
Student viewInstructor view

Shelly Cashman Series® Microsoft® Office 365® & Excel® 2019 Comprehensive

By Steven M. Freund, Joy L. Starks

1st Edition © 2020
Discipline:Computing & Information Technology
Course:Spreadsheets
Starting from$50.00
See pricing details and explore formats

Get your course materials

Learning Platforms

MindTap

Get course content, assignments, practice, and AI-powered support all in one place to keep learning on track.

New edition available

SAM

New edition available

Cengage Unlimited

Get day-one access to course content, AI-powered support, and resources to build college and career-ready skills.

Manage Subscription

eBook

Get instant access to your course content on the device of your choice, with built-in tools like highlighting, bookmarking, and search.

Paperback

Buy or Rent the textbook

Get a new, printed copy of your textbook, ready for notes and highlighting. Plus, free shipping and returns on orders. *See terms and conditions.

New edition available
Added to cart.
Something went wrong. Please try again.

Questions about this product?

Get help with product, platform or format questions.

Let’s connect
Explore instructor resources

About your course materials

Introduce your students to the latest advancements that Microsoft® Office and Excel® have to offer with MICROSOFT® OFFICE 365 & EXCEL 2019 -- new to the acclaimed Shelly Cashman Series®. MICROSOFT® OFFICE 365 & EXCEL 2019 continues the series' strong history of innovation with a hallmark learning approach enhanced to address the varied learning styles of today's students. A trademark step-by-step, screen-by-screen approach encourages students to expand their understanding of the software through experimentation, critical thought, and personalization. This new edition and accompanying resources are designed to engage readers and improve retention while also engaging them in real-world scenarios to reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.

Related study tools

MindTap for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series Collection, Microsoft® Office 365 & Office 2019, 1 term Instant Access cover
Higher Education

MindTap for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series Collection, Microsoft® Office 365 & Office 2019, 1 term Instant Access

MindTap for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series Collection, 1st Edition, is the digital learning solution that powers students from memorization to mastery and gives yo…

ISBN-13:9780357026229Copied!
$149.00
Add to cart
MindTap for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series Collection, Microsoft® Office 365® & Office 2019, 2 terms Instant Access cover
Higher Education

MindTap for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series Collection, Microsoft® Office 365® & Office 2019, 2 terms Instant Access

MindTap for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series Collection, 1st Edition, is the digital learning solution that powers students from memorization to mastery and gives yo…

ISBN-13:9780357119167Copied!
$221.00
Add to cart
SAM 365 & 2019 Assessments, Training and Projects Instant Access with Access to eBook, 2 terms cover
Higher Education

SAM 365 & 2019 Assessments, Training and Projects Instant Access with Access to eBook, 2 terms

SAM 365/2019 trains and tests essential Microsoft Office and computer concepts skills. Students engage in a hands-on simulated environment, then apply their skills to real-world Microsoft application…

ISBN-13:9780357366714Copied!
$156.00
Add to cart
SAM 365 & 2019 Assessments, Training and Projects Instant Access with Access to eBook cover
Higher Education

SAM 365 & 2019 Assessments, Training and Projects Instant Access with Access to eBook

SAM 365/2019 trains and tests essential Microsoft Office and computer concepts skills. Students engage in a hands-on simulated environment, then apply their skills to real-world Microsoft application…

ISBN-13:9780357366653Copied!
$149.00
Add to cart
K12 SAM for Microsoft 365 & 2019 + 2 eReaders (1-year access) cover
Higher Education

K12 SAM for Microsoft 365 & 2019 + 2 eReaders (1-year access)

SAM (Skills Assessment Manager) offers access to (2) full, interactive eBooks as well as all SAM-powered trainings, exams and in-application projects that are automatically graded. Advanced reporting…

ISBN-13:9780357369210Copied!
$50.00
Add to cart
K12 SAM for Microsoft 365 & 2019 + 3 eReaders (1-year access) cover
Higher Education

K12 SAM for Microsoft 365 & 2019 + 3 eReaders (1-year access)

SAM (Skills Assessment Manager) offers access to (3) full, interactive eBooks as well as all SAM-powered trainings, exams and in-application projects that are automatically graded. Advanced reporting…

ISBN-13:9780357369234Copied!
$50.00
Add to cart
LMS Integrated SAM 365 & 2019 with MindTap Reader, 1 term Instant Access cover
Higher Education

LMS Integrated SAM 365 & 2019 with MindTap Reader, 1 term Instant Access

This access code will provide your student with seamless access to your SAM 365 & 2019 resources from within their campus Learning Management System. Your students will be prompted to enter this acce…

ISBN-13:9780357369463Copied!
$149.00
Add to cart
Show more

Frequently asked questions

How do I enroll in or join my course?

Your instructor will tell you how to access your course. You may join through your school’s LMS, a course link or a course key. If you’re unsure which method to use, check with your instructor.

How do I redeem an access code, or what if my code isn't working?

Sign in to your Cengage account and select Enter Access Code or Course Key, then enter your access code and select Register. If your code is damaged, missing or still doesn't work, contact Cengage Support.

Why can't I access my course?

How you access your course depends on how your instructor set it up. Start from your LMS, course link or course key. If you've purchased access but still can't open the course, Cengage Help can help you troubleshoot your access.

Where can I find my eBook or textbook?

You can access available eBooks from your Cengage student dashboard or from your Cengage course. If your class uses an LMS, your instructor may also provide access there.

What if I don't have access to my course materials yet?

Temporary access may be available for some Cengage courses. If offered, you can use your course during the grace period and purchase or register your access code before it ends. Options for expired access vary by product.

AboutTable of contentsResourcesPricing & formatsRelated products

About this product

Introduce your students to the latest advancements that Microsoft® Office and Excel® have to offer with MICROSOFT® OFFICE 365 & EXCEL 2019 -- new to the acclaimed Shelly Cashman Series®. MICROSOFT® OFFICE 365 & EXCEL 2019 continues the series' strong history of innovation with a hallmark learning approach enhanced to address the varied learning styles of today's students. A trademark step-by-step, screen-by-screen approach encourages students to expand their understanding of the software through experimentation, critical thought, and personalization. This new edition and accompanying resources are designed to engage readers and improve retention while also engaging them in real-world scenarios to reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.

Quality Learning! This series goes beyond learning Office applications by providing contextual relevance with a trusted and proven pedagogy combined with real world scenarios and assessments. With a deeper focus on employability, this new edition demonstrates real world relevance and professionalism with all-new case scenarios written to reflect the top industries hiring for Microsoft Office skills. In addition, in the Shelly Cashman Collection Series pedagogy, each chapter presents a practical problem to be solved within a project planning framework and includes step-by-step instructions with support screenshots to guide students along. Instructional steps are further supported by key features, including Q&A boxes, Experimental Steps, and BTW features. This proven project-based pedagogy teaches learning through context of personal, academic, and business-related skills to help extend and apply student learning.

Easy! As part of our new intuitive design, the updated readings are now closely aligned with SAM (Skills Assessment Manager) Trainings, Exams, and Projects to reflect the latest and greatest Office 365 and Office 2019 features. With a focus on more practice opportunities, SAM Projects have expanded Textbook Projects to all module levels (Introduction, Intermediate, and Advanced). To help students utilize Textbook Projects fully, a new SAM icon is now embedded in the readings. The icon indicates when a student should download their files from SAM or MindTap to start a Textbook Project, and when they should upload their completed Textbook Project for instantaneous grading and feedback. There are also new SAM End-of-Module Projects, which are based on the In the Lab found in each module and offer full auto grading. With a variety of easy-to-use assessments, students will be able to quickly and efficiently demonstrate their understanding of Office.

Affordable! The product suite is available in a variety of purchase options to give students the best value for the tools and resources that they need and to allow students to choose how to learn. With the launch of Cengage Unlimited, student can access all of the Microsoft Office content for just one price, plus thousands of other resources, plus opt for a low-cost rental or purchase of a bound book or loose-leaf text. Students benefit from access to the full Office Collections in MindTap.

Trusted Partner! This product suite was developed to cover the most critical features of the Office applications to drive student engagement and comprehension. By implementing feedback from partners in the Cengage Computing Community and beyond, as well as incorporating the 2019 Microsoft Office Skills (MOS), students will learn and apply key skills they need for success not just on their educational and professional journeys, but also in their day-to-day usage of Office applications. With Cengage’s dedication to providing meaningful and engaging solutions for students, our team is available to connect and assist with onboarding and training in the classroom to further support students on their Microsoft Office journey.

Table of contents

Chapters

Cover
Brief Contents
Contents
Getting to Know Microsoft Office Versions
Using SAM Projects and Textbook Projects
Module 1: Creating a Worksheet and a Chart*Preview this chapter
Module 2: Formulas, Functions, and Formatting
Module 3: Working with Large Worksheets, Charting, and What-If Analysis
Module 4: Financial Functions, Data Tables, and Amortization Schedules
Module 5: Working with Multiple Worksheets and Workbooks
Module 6: Creating, Sorting, and Querying a Table
Module 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots
Module 8: Working with Trendlines, PivotTables, PivotCharts, and Slicers
Module 9: Formula Auditing, Data Validation, and Complex Problem Solving
Module 10: Data Analysis with Power Tools and Creating Macros
Module 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features
Index
Show more

Module 1: Creating a Worksheet and a ChartPreview this chapter ↗

Objectives ↗
Introduction ↗
Project: Real Estate Budget Worksheet and Chart ↗
Starting and Using Excel ↗
Selecting a Cell ↗
Entering Text ↗
Entering Numbers ↗
Calculating Sums and Using Formulas ↗
Using the Fill Handle to Copy a Cell to Adjacent Cells ↗
Calculating Average, Maximum, and Minimum Values ↗
Saving the Project ↗
Formatting the Worksheet ↗
Adding a Pie Chart to the Worksheet ↗
Changing the Sheet Tab Names and Colors ↗
Document Properties ↗
Printing a Worksheet ↗
Viewing Automatic Calculations ↗
Correcting Errors ↗
Summary ↗
Apply Your Knowledge ↗
Extend Your Knowledge ↗
Expand Your World ↗
In the Lab ↗
Show more

Resources

Instructor resources for this title can include manuals, test banks, educator guides, multimedia and companion sites. Sign in to see what is available.

Instructor manuals
Test banks
Educator guides
Multimedia
Companion sites
Sign in to view & download

Pricing and formats

Learning Platforms
eBook
Paperback
Bundle

MindTap

Give students content, practice, assignments, and AI support, with real-time insights to track their progress.

6 months

ISBN-13: 9780357026229
$149.00
New edition available

12 months

ISBN-13: 9780357119167
$221.00
New edition available
Sign in to view & adopt this title

SAM

6 months

ISBN-13: 9780357366714
$156.00

6 months

ISBN-13: 9780357366653
$149.00
New edition available

12 months

ISBN-13: 9780357369210
$50.00

12 months

ISBN-13: 9780357369234
$50.00

6 months

ISBN-13: 9780357369463
$149.00
New edition available
Sign in to view & adopt this title

Give students more with Cengage Unlimited

Choose the Cengage content and Learning Platform that fit your course while giving students access to Cengage Learning Platforms and our entire eBook library with one subscription.

4-12 month student access

$169.99 – $244.99

eBook

Give students digital access to textbook content with tools to highlight, bookmark and search as they read.

6 months

ISBN-13: 9780357392676
$76.99

12 months

ISBN-13: 9780357392676
$105.99

4 months

ISBN-13: 9780357462928
$124.99

6 months

ISBN-13: 9780357462928
$150.00

12 months

ISBN-13: 9780357462928
$206.49
Sign in to view & adopt this title

Paperback

Purchase

ISBN-13: 9780357026403
$245.95
New edition available
Sign in to view & adopt this title

Related products

The Shelly Cashman Series® Microsoft® Office 365® & Excel® Comprehensive book cover
Higher Education

The Shelly Cashman Series® Microsoft® Office 365® & Excel® Comprehensive

Rob Wilson
1st Edition © 2025
Paperback
eBook
Starting from
$76.99
View details
Illustrated Series® Collection, Microsoft® Office 365® & Excel® 2021 Comprehensive book cover
Higher Education

Illustrated Series® Collection, Microsoft® Office 365® & Excel® 2021 Comprehensive

Lynn Wermers
1st Edition © 2023
Paperback
SAM
Starting from
$30.00
View details
New Perspectives Collection, Microsoft® 365® & Excel® 2021 Comprehensive book cover
Higher Education

New Perspectives Collection, Microsoft® 365® & Excel® 2021 Comprehensive

Patrick Carey
1st Edition © 2023
Paperback
SAM
eBook
Starting from
$30.00
View details
Illustrated Microsoft® Office 365® & Excel® 2019 Comprehensive book cover
Higher Education

Illustrated Microsoft® Office 365® & Excel® 2019 Comprehensive

Lynn Wermers
1st Edition © 2020
MindTap
Paperback
SAM
Starting from
$50.00
View details
MindTap Computing, 1 term (6 months) Instant Access for The Illustrated Collection Microsoft Office 365 & Office 2016 book cover
Higher Education

MindTap Computing, 1 term (6 months) Instant Access for The Illustrated Collection Microsoft Office 365 & Office 2016

Cengage
1st Edition © 2018
MindTap
Starting from
$76.99
View details

This product is provided solely for instructional purposes, and your use of this product is governed by Cengage's Terms of Use. By using this product, you acknowledge your obligation to comply with these terms. View Terms of Use.

Cengage support team
Cengage support team

Still need support?

Get help with course access, registration, purchases or technical issues from Cengage Support.
Contact support
Cengage support team
Cengage support team

Need help?

Connect with us today, and let’s explore how we can support your goals.
Get in touch
Cengage
Higher Education
K–12
Higher Education

Higher Education

Future-focused tools to teach, learn, and build career-ready skills.
Get started

Students

Instructors

Leaders

Librarians

Career and Workforce
Sign In

Higher Education

Student
Instructor
Gale
ELL
Name
Dashboard
Profile
Sign Out
Support

Recent searches

Chemistry
Mindtap Biology
Calculus
Recent query

Suggestions

Calculus230 results
Calculus Early Transcendentals84 results
Calculus Concepts37 results
Suggestion0 results

Matching products

2 results
Abstract navy to teal gradient placeholder
TAGTAGTAG
9th Edition•© 2021

Calculus: Early Transcendentals

James Stewart, Daniel K. Clegg and Saleem Watson

Abstract navy to teal gradient placeholder
TAGTAGTAG
9th Edition•© 2021

Calculus

James Stewart, Daniel K. Clegg and Saleem Watson

TAG
Edition

Product title

Authors
No matching products. Press Enter to search the full catalog.
Product suggestions are unavailable right now. Press Enter to search the full catalog.
Searching…
Sign In

Higher Education

Student
Instructor
Gale
ELL
Name
Dashboard
Profile
Sign Out
Your basket (3)
eTextbook: Calculus | 12th Edition
eTextbook Access: 360 days
$76.99
Cengage Unlimited - Full - Multi-Term Access (12 months)
Digital Access: 365 days
$124.99
Introduction to Physical Anthropology | 15th Edition
Textbook
$124.99
This is some text inside of a div block.
This is some text inside of a div block.
This is some text inside of a div block.
Your basket is empty.
We couldn’t load your basket. Please try again.
Loading your basket…
Total:
$201.98
I’m ready to checkout
Get Support
US
Change Country
Students

Students

See Overview

Access & Use Products

Access Instructions
Help Center

Get Help

Instructors

Instructors

See Overview

Products

Disciplines
Learning Platforms
Cengage Unlimited

Access & Use Products

Instructor Support
Course Setup
Training
Help Center

Get help

Leaders & Admins

Leaders & Admins

See Overview

Programs

Cengage Unlimited
Gale

Access & Use Products

LMS Integration

Resources

Published Research
Help Center

Get help

Librarians

Librarians

See Overview

Products

Databases
Primary Sources
Digital Humanities Tools
eLearning

Access & Use Products

Discovery Services
Gale Support
Gale Support

Get Support

Find Your Local Cengage Site

Select country
🇦🇫
Afghanistan
🇦🇱
Albania
🇩🇿
Algeria
🇦🇩
Andorra
🇦🇴
Angola
🇦🇮
Anguilla
🇦🇬
Antigua and Barbuda
🇦🇷
Argentina
🇦🇲
Armenia
🇦🇼
Aruba
🇦🇺
Australia
🇦🇹
Austria
🇦🇿
Azerbaijan
🇧🇸
Bahamas
🇧🇭
Bahrain
🇧🇩
Bangladesh
🇧🇧
Barbados
🇧🇾
Belarus
🇧🇪
Belgium
🇧🇿
Belize
🇧🇯
Benin
🇧🇲
Bermuda
🇧🇹
Bhutan
🇧🇴
Bolivia
🇧🇦
Bosnia and Herzegovina
🇧🇼
Botswana
🇧🇷
Brazil
🇻🇬
British Virgin Islands
🇧🇳
Brunei
🇧🇬
Bulgaria
🇧🇫
Burkina Faso
🇧🇮
Burundi
🇰🇭
Cambodia
🇨🇲
Cameroon
🇨🇦
Canada
🇨🇻
Cape Verde
🇰🇾
Cayman Islands
🇨🇫
Central African Republic
🇹🇩
Chad
🇨🇱
Chile
🇨🇳
China
🇨🇴
Colombia
🇰🇲
Comoros
🇨🇰
Cook Islands
🇨🇷
Costa Rica
🇨🇮
Côte d'Ivoire
🇭🇷
Croatia
🇨🇺
Cuba
🇨🇾
Cyprus
🇨🇿
Czech Republic
🇨🇩
Democratic Republic of the Congo
🇩🇰
Denmark
🇩🇯
Djibouti
🇩🇲
Dominica
🇩🇴
Dominican Republic
🇪🇨
Ecuador
🇪🇬
Egypt
🇸🇻
El Salvador
🇬🇶
Equatorial Guinea
🇪🇷
Eritrea
🇪🇪
Estonia
🇸🇿
Eswatini
🇪🇹
Ethiopia
🇫🇰
Falkland Islands (Malvinas)
🇫🇴
Faroe Islands
🇫🇯
Fiji
🇫🇮
Finland
🇫🇷
France
🇬🇫
French Guiana
🇬🇪
Georgia
🇩🇪
Germany
🇬🇭
Ghana
🇬🇮
Gibraltar
🇬🇷
Greece
🇬🇱
Greenland
🇬🇩
Grenada
🇬🇵
Guadeloupe
🇬🇺
Guam
🇬🇹
Guatemala
🇬🇳
Guinea
🇬🇼
Guinea-Bissau
🇬🇾
Guyana
🇭🇹
Haiti
🇭🇳
Honduras
🇭🇰
Hong Kong
🇭🇺
Hungary
🇮🇸
Iceland
🇮🇳
India
🇮🇩
Indonesia
🇮🇷
Iran
🇮🇶
Iraq
🇮🇪
Ireland
🇮🇱
Israel
🇮🇹
Italy
🇯🇲
Jamaica
🇯🇵
Japan
🇯🇴
Jordan
🇰🇿
Kazakhstan
🇰🇪
Kenya
🇰🇮
Kiribati
🇰🇼
Kuwait
🇰🇬
Kyrgyzstan
🇱🇦
Laos
🇱🇻
Latvia
🇱🇧
Lebanon
🇱🇸
Lesotho
🇱🇷
Liberia
🇱🇮
Liechtenstein
🇱🇹
Lithuania
🇱🇺
Luxembourg
🇲🇴
Macau
🇲🇬
Madagascar
🇲🇼
Malawi
🇲🇾
Malaysia
🇲🇻
Maldives
🇲🇱
Mali
🇲🇹
Malta
🇲🇭
Marshall Islands
🇲🇶
Martinique
🇲🇷
Mauritania
🇲🇺
Mauritius
🇲🇽
Mexico
🇲🇩
Moldova
🇲🇨
Monaco
🇲🇳
Mongolia
🇲🇪
Montenegro
🇲🇸
Montserrat
🇲🇦
Morocco
🇲🇿
Mozambique
🇲🇲
Myanmar
🇳🇦
Namibia
🇳🇷
Nauru
🇳🇵
Nepal
🇳🇱
Netherlands
🇳🇿
New Zealand
🇳🇮
Nicaragua
🇳🇪
Niger
🇳🇬
Nigeria
🇳🇺
Niue
🇰🇵
North Korea
🇲🇰
North Macedonia
🇳🇴
Norway
🇴🇲
Oman
🇵🇰
Pakistan
🇵🇼
Palau
🇵🇸
Palestine
🇵🇦
Panama
🇵🇬
Papua New Guinea
🇵🇾
Paraguay
🇨🇬
People's Republic of Congo
🇵🇪
Peru
🇵🇭
Philippines
🇵🇱
Poland
🇵🇹
Portugal
🇵🇷
Puerto Rico
🇶🇦
Qatar
🇷🇴
Romania
🇷🇺
Russia
🇷🇼
Rwanda
🇼🇸
Samoa
🇸🇲
San Marino
🇸🇹
Sao Tome and Principe
🇸🇦
Saudi Arabia
🇸🇳
Senegal
🇷🇸
Serbia
🇸🇨
Seychelles
🇸🇱
Sierra Leone
🇸🇬
Singapore
🇸🇰
Slovakia
🇸🇮
Slovenia
🇸🇧
Solomon Islands
🇸🇴
Somalia
🇿🇦
South Africa
🇰🇷
South Korea
🇪🇸
Spain
🇱🇰
Sri Lanka
🇰🇳
St. Kitts and Nevis
🇱🇨
St. Lucia
🇵🇲
St. Pierre and Miquelon
🇻🇨
St. Vincent & The Grenadines
🇸🇩
Sudan
🇸🇷
Suriname
🇸🇯
Svalbard and Jan Mayen Islands
🇸🇪
Sweden
🇨🇭
Switzerland
🇸🇾
Syria
🇹🇼
Taiwan
🇹🇯
Tajikistan
🇹🇿
Tanzania
🇹🇭
Thailand
🇹🇱
Timor-Leste
🇹🇬
Togo
🇹🇰
Tokelau
🇹🇴
Tonga
🇹🇹
Trinidad and Tobago
🇹🇳
Tunisia
🇹🇷
Turkey
🇹🇲
Turkmenistan
🇹🇨
Turks and Caicos Islands
🇹🇻
Tuvalu
🇺🇬
Uganda
🇺🇦
Ukraine
🇦🇪
United Arab Emirates
🇬🇧
United Kingdom
🇺🇸
United States
🇺🇾
Uruguay
🇺🇿
Uzbekistan
🇻🇺
Vanuatu
🇻🇦
Vatican
🇻🇪
Venezuela
🇻🇳
Vietnam
🇪🇭
Western Sahara
🇾🇪
Yemen
🇿🇲
Zambia
🇿🇼
Zimbabwe
Cengage

Welcome to Cengage

It looks like you’re visiting from another country. Would you like to visit your local Cengage site instead?

Cengage logo

Support

(800) 354-9706

support.cengage.com

K–12

Higher Education

Career and Workforce

Students

Instructors

Leaders & Admin

Librarians

Company

About

News

Research & Outcomes

Investors

Careers

Content Development Philosophy

Authors/Royalties

Cengage AI

Contact

Contact Us

Support

ServicePlus Ordering

© 2020 Cengage Learning, Inc. and its affiliates

Copyright

Privacy

Piracy

Terms of Use

Accessibility

Compliance & Ethics

Do Not Sell