MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam Mo-200
- Manage worksheets and workbooks
- Manage data cells and ranges
- Manage tables and table data
- Perform operations by using formulas and functions
- Manage charts
Major topics include the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. This Study Guide also covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data entry logs.
Readers will also have access to Sybex's superior online test bank, includng hundreds of practice questions, flashcards, and a glossary of important terms.
Eric Butow (Jackson, CA) has authored or co-authored 35 books, most recently Pro iOS Security and Forensics (Apress), Programming Interviews for Dummies (Wiley), and Instagram for Dummies (Wiley). Eric has also developed and taught networking, computing, and usability courses for Ed2Go, Virtual Training Company, California State University, Sacramento, and Udemy. Eric has also been a professional technical writer and started using Word, Excel, and PowerPoint professionally starting in 1994 for Dantel, a telecommunications company in Fresno, California. He also served as a technical writer for companies large and small including Intel, Wells Fargo Wachovia, TASQ Technology, Cisco Systems, and Hewlett-Packard. He is the owner of Butow Communications Group (BCG) in Jackson, California (www.butow.net). BCG offers website development, online marketing, and technical writing services.