MOS Study Guide for Microsoft Excel Exam MO-200 by Joan Lambert (English) Paperb

Description: MOS Study Guide for Microsoft Excel Exam MO-200 by Joan Lambert Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what youve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Worksheets and Workbooks Manage Data Cells and Ranges Manage Tables and Table Data Perform Operations by Using Formulas and Functions Manage Charts FORMAT Paperback LANGUAGE English CONDITION Brand New Author Biography Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), six generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows 10 and Office 2016, and GO! series books for Outlook. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer. She is also certified in Adobe InDesign and Intuit QuickBooks. A native of the Pacific Northwest and enthusiastic world traveler, Joan is now blissfully based in Americas Finest City with her simply divine daughter Trinity, Thai host daughter Thopad, and their faithful canine, feline, and aquatic companions. Table of Contents 1 Manage worksheets and workbooks Objective 1.1: Import data into workbooks Objective 1.2: Navigate within workbooks Objective 1.3: Format worksheets and workbooks Objective 1.4: Customize options and views Objective 1.5: Configure content for collaboration 2 Manage data cells and ranges Objective 2.1: Manipulate data in worksheets Objective 2.2: Format cells and ranges Objective 2.3: Define and reference named ranges Objective 2.4: Summarize data visually 3 Manage tables and table data Objective 3.1: Create and format tables Objective 3.2: Modify tables Objective 3.3: Filter and sort table data 4 Perform operations by using formulas and functions Objective 4.1: Insert references in formulas Objective 4.2: Calculate and transform data by using functions Objective 4.3: Format and modify text by using functions 5 Manage charts Objective 5.1: Create charts Objective 5.2: Modify charts Objective 5.3: Format charts Long Description Advance your everyday proficiency with Excel 2019, and earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel 2019 certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what youve learned Sample files for practice tasks Solutions files so you can check your work Sharpen the skills measured by these objectives: Create and manage worksheets and workbooks Manage data cells and ranges Create tables and manage table data Perform operations by using formulas and functions Create charts and objects About MOS A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams. Feature Review and practice the skills you must demonstrate to become a certified Microsoft Office Specialist in Excel 2019! Full, objective-by-objective exam coverage Easy-to-follow procedures and illustrations to review essential skills Hands-on tasks to practice what youve learned New Feature The MOS 2019 Study Guide for Microsoft Excel now features solutions for every practice task -- so readers can easily check their work and improve exam readiness. Details ISBN0136627153 Author Joan Lambert Publisher Pearson Education (US) Year 2020 ISBN-10 0136627153 ISBN-13 9780136627159 Format Paperback Country of Publication United States DEWEY 005.54 Language English Series MOS Study Guide Pages 192 Imprint Addison Wesley Place of Publication Boston AU Release Date 2020-06-30 NZ Release Date 2020-06-30 UK Release Date 2020-06-30 Replaces 9780735699434 Audience Professional & Vocational Publication Date 2020-07-07 US Release Date 2020-07-07 We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:130086200;

Price: 39.94 AUD

Location: Melbourne

End Time: 2024-11-21T02:06:24.000Z

Shipping Cost: 0 AUD