The Shelly Cashman Series® Microsoft® 365® & Office® Intermediate,
1st Edition

COVER.
BRIEF CONTENTS.
CONTENTS.
GETTING TO KNOW MICROSOFT OFFICE VERSIONS.
USING SAM PROJECTS AND TEXTBOOK PROJECTS.
MICROSOFT WORD.
Module 4: Creating a Multipage Document.
Module 5: Creating a Resume and Sharing Documents.
Module 6: Using Mail Merge.
Module 7: Creating a Newsletter.
MICROSOFT POWERPOINT.
Module 4: Customizing Slide Masters and Presentations.
Module 5: Collaborating and Adding Animation.
Module 6: Formatting Tables and Charts.
Module 7: Adding Media and Enhancing SmartArt.
MICROSOFT EXCEL.
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.
MICROSOFT ACCESS.
Module 4: Designing Reports and Forms.
Module 5: Multiple-Table Forms.
Module 6: Advanced Report Techniques.
Module 7: Advanced Form Techniques.
INDEX.

• Steven M. Freund

  Steven M. Freund serves as a lead 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 and other customer events. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, Mozilla Firefox, Windows® Internet Explorer, Windows® Office and Dreamweaver books. In addition, he has written numerous successful instructor supplements. He attended the University of Central Florida.

• Rob Wilson

• Susan L. Sebok

  Susan L. Sebok is a retired professor at South Suburban College in South Holland, Illinois. She also is a licensed attorney. Working with the leading Shelly Cashman Series® since 1993, she has co-authored several successful textbooks, including multiple versions of DISCOVERING COMPUTERS and Microsoft® PowerPoint® books. She holds both Master of Arts and Juris Doctor degrees.

• Misty E. Vermaat

  Misty E. Vermaat has more than 25 years of experience in the field of computer and information technology. In addition to consulting in the field, she was an Associate Professor at Purdue University Calumet, teaching or developing Microsoft® Office, computer concepts, database management, systems analysis and design, and programming courses. Since 1990, Ms. Vermaat has led the development of the Shelly Cashman Series and has written or co-authored numerous Series textbooks, including many editions of DISCOVERING COMPUTERS, DISCOVERING COMPUTERS FUNDAMENTALS and Microsoft® Word books.

• Jill West

  Jill West, a C.I.S. instructor at Georgia Northwestern Technical College, brings a unique cross-section of experience in business, writing and education to the development of innovative educational materials. She has taught students of multiple ages -- K through college-level -- and has embraced a variety of content using a flipped classroom approach, distance learning and a hybrid teaching approach. She has also provided highly valued educational counseling. Ms. West has been instrumental in designing and authoring critical-thinking simulations for several of Cengage’s computer courses. She regularly presents at regional and national conferences and international webinars, frequently offering CompTIA certifications for students and train-the-trainer sessions for instructors. She’s also a member of the 2019 inaugural cohort of Faculty Ambassadors for A.W.S. Educate. Ms. West and her husband, Mike, live in northwest Georgia with three children at home and one in college.

• This text is updated to reflect Microsoft 365 features including Accessibility Checker.

• New features for Excel include XLOOKUP, LET function, Dynamic Arrays, Spilling, Accessibility Checker, updated Draw tab, Co-authoring to collaborate with colleagues on workbooks, Threaded Comments for discussions about data and Notes to annotate data.

• New features for PowerPoint include the ability for the user to display comments in contextual view or in the Comments pane, updated search features, the ability for the user to record and save a presentation including digital inking, the Speaker Coach feature which uses AI to improve presentation skills and giving feedback on use of sensitive and filler words, pitch and pace.

• New features for Word include the new focus mode, the updated collaboration experience and Microsoft's expanded search feature and voice options.

• New features for Access include completely updated projects using gapped Start and Solution files to ensure students use new, authentic files for each project from module to module. Module projects alternate between two sets of scenarios for expanded relevance and practicality.

• This trademark step-by-step, screen-by-screen, project-based approach encourages students to expand their understanding of Microsoft Office through experimentation and critical thinking.

• Introductory Textbook Projects are designed to ensure successful completion by Mac users for Word, Excel and PowerPoint.

• Embracing Change modules in MindTap help students navigate through Microsoft 365 continual software changes. Each module includes accessibility features, application-specific tips, a Microsoft ribbon and toolbar visual overview, plus review and discussion questions.

• This title gives you access to a complete digital library of content spanning Computer Concepts, Operating Systems (for Windows and Mac) and the Microsoft Office Suite -- all for one price including low-cost rental options. Learn more about Cengage Unlimited at https://www.cengage.com/unlimited.

• Module Learning Objectives are mapped to the Microsoft Office Specialist (MOS) exam. Users of MindTap Collections and SAM will have access to exam preparation materials and the option to purchase a discounted MOS exam voucher.

• Students carefully examine the context for their projects, which increases the motivation to learn as students understand the “why” behind each step in the process.

• Other Ways boxes allow users to see alternate click paths to achieve a step.

• BTW call-outs provide helpful hints to readers as they complete their projects.

• Q&A boxes anticipate questions users may have as they work through the steps and provide additional information as it may be needed so that users understand all aspects of the steps required to complete a task.

• Consider This boxes promote critical thinking, and the module-ending Consider This: Plan Ahead box presents a single planning guide, helping users successfully create their own documents.

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

Cengage Testing, powered by Cognero® for Cable/Freund/Hoisington/Kaye/Porter/Sebok/Vermaat/West's The Shelly Cashman Series® Collection, Microsoft® 365® & Office®
9780357881385

Cengage Testing, powered by Cognero® for Cable/Freund/Hoisington/Kaye/Porter/Sebok/Vermaat/West's The Shelly Cashman Series® Collection, Microsoft® 365® & Office®, Instant Access
9780357881392

Instructor's Companion Website for Cable/Freund/Hoisington/Kaye/Porter/Sebok/Vermaat/West's The Shelly Cashman Series® Collection, Microsoft® 365® & Office®
9780357881378

Cengage eBook: The Shelly Cashman Series® Microsoft® 365® & Office® Intermediate 12 Months
9788000070858