Cengage India

Home

Higher Education

Illustrated Microsoft® 365® Excel® Comprehensive with MindTap

Author(s): Lynn Wermers

ISBN: 9789366607719

1st Edition

₹750

Binding: Paperback

Pages: 320

Trim Size : 279 x 216 mm

Refer Book > Order Inspection Copy >

Wermers' ILLUSTRATED MICROSOFT® 365® EXCEL® COMPREHENSIVE, FIRST EDITION, helps you quickly master the nuances of Microsoft® Office. Each module begins with a brief overview of the principles covered while large images illustrate what you see on your computer. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, and module scenarios are based on data from market insights, helping you sharpen the critical skills you need for real-world success. In addition, MindTap and SAM (Skills Assessment Manager) digital resources help maximize your study time and results.

New features for Excel include a new lesson on using dynamic array functions, including UNIQUE, FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY, TRANSPOSE and information on spill ranges and using array formulas. There are also new clues on data types (geography, stocks, new data types) and on LET function.
Students carefully examine the context for their projects, increasing the motivation to learn as students understand the “why” behind each step in the process.
Each module begins with a brief overview of the principles covered while large, full-color screen images illustrate what you see on your computer.
Integration of Learning Outcomes to module skills - Module Learning Outcomes are mapped to the End-of-Module exercises.
Multiple Learning Styles Addressed - Quick tips offer additional information and frequently different approaches for readers as they work through their project steps.
The SAM integration aligns textbook readings with SAM trainings, exams, and projects to reflect current Office 365 and Excel 365 skills. It emphasizes hands-on practice through SAM Projects available at introductory, intermediate, and advanced levels, clearly marked with embedded SAM icons to guide downloading, submission, and instant feedback. End-of-module SAM projects provide fully auto-graded assessments, enabling students to efficiently demonstrate and build Excel skills through frequent, practical evaluation.

1. Getting Started with Excel
2. Formatting a Worksheet
3. Analyzing Data Using Formulas
4. Working with Charts
5. Working with Tables
6. Managing Workbook Data
7. Working with Images and Integrating with Other Programs
8. Analyzing Data with PivotTables
9. Automating Worksheet Tasks
10. Managing Worksheets
11. Using Formulas and Functions
12. Performing What-if Analysis

Lynn Wermers

Lynn Wermers is a professor in the computer science department at North Shore Community College in Massachusetts, where she teaches IT, data management, data analysis and web development courses.