Helping you quickly get up to speed, THE SHELLY CASHMAN SERIES® MICROSOFT® OFFICE 365® & EXCEL® 2021 COMPREHENSIVE 1st edition, includes the latest on Microsoft 365 and Office 2021 features along with enhanced support for Mac users. Its trademark step-by-step, screen-by-screen, project-based approach enables you to expand your understanding of Office applications through hands-on experimentation and critical thinking. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, reinforcing the critical skills needed for college and career success. Other Ways boxes reveal alternate click paths to achieve a step, while BTW call-outs offer helpful hints as you work through your projects so you can make the most of Microsoft Office tools. In addition, MindTap and SAM (Skills Assessment Manager) online resources help maximize your study time -- and results.
Excel Module 1: Creating a Worksheet and a Chart.
Excel Module 2: Formulas, Functions, and Formatting.
Excel Module 3: Working with Large Worksheets, Charting, and What-If Analysis.
Excel Module 4: Financial Functions, Data Tables, and Amortization Schedules.
Excel Module 5: Working with Multiple Worksheets and Workbooks.
Excel Module 6: Creating, Sorting, and Querying a Table.
Excel Module 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots.
Excel Module 8: Working with Trendlines, PivotTable Reports, PivotChart Reports, and Slicers.
Excel Module 9: Formula Auditing, Data Validation, and Complex Problem Solving.
Excel Module 10: Data Analysis with Power Tools and Creating Macros.
Excel Module 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel.
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.
Joy L. Starks
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.
Thoroughly updated coverage reflects Microsoft 365 and Office 2021 features including the new modern commenting experience that enables the user to display comments in contextual view or in the Comments pane. Other feature updates include XLOOKUP, PowerBI and the Analyze Data button in Excel, along with Microsoft's updated search feature and Backstage view.
Introductory Textbook Projects have been redesigned to ensure successful completion by Mac users.
The Shelly Cashman Series' trademark step-by-step, screen-by-screen, project-based approach encourages students to expand their understanding of Microsoft Office through hands-on experimentation and critical thinking.
Part of the Shelly Cashman Microsoft Office 365 Collection, this title provides 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 cengage.com/unlimited.
Helping learners maximize their study time, Module Learning Objectives are mapped to the Microsoft Office Specialist (MOS) exam. Users of MindTap Collections and SAM also have access to exam preparation materials and the option to purchase a discounted MOS exam voucher.
By carefully examining the context for their projects, students understand the "why" behind each step in the process, which increases their motivation to learn.
Other Ways boxes help users see alternate click paths to achieve a step -- expanding their options and expertise.
BTW call-outs provide helpful hints to readers as they work through their projects, giving them additional insight that enables them to make the most of Microsoft Office tools.
Cengage Testing, powered by Cognero® for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series® Collection, Microsoft® 365® & Office® 2021
Cengage Testing, powered by Cognero® for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series® Collection, Microsoft® 365® & Office® 2021, Instant Access
Instructor's Companion Website for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series® Collection, Microsoft® 365® & Office® 2021
Cengage eBook: The Shelly Cashman Series® Microsoft® Office 365® & Excel® 2021 Comprehensive 12 Months