The Shelly Cashman Series Microsoft Office 365 Excel 2021 Comprehensive [Paperback]

THE SHELLY CASHMAN SERIES? MICROSOFT? OFFICE 365? & EXCEL? 2021 COMPREHENSIVE, 1st edition, delivers up-to-date coverage of Microsoft 365 and Office 2021 features along with enhanced support for Mac users. The series' trademark step-by-step, screen-by-screen, project-based approach encourages students to expand their understanding of Office applications through hands-on experimentation and critical thinking. Module Learning Objectives are mapped to Microsoft Office Specialist certification objectives, reinforcing the critical skills needed for success in college and career. Other Ways boxes help users see alternate click paths to achieve a step, while BTW call-outs offer helpful hints as readers work through projects -- enabling them to make the most of Microsoft Office tools. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study to maximize 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.