Read more
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.
List of contents
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.
About the author
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 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.
Summary
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.
