Paul McFedries

Mos Study Guide for Microsoft Excel Expert Exam Mo-201

• Broschiertes Buch

Produktbeschreibung

Hone your advanced Excel 2019 skills. And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help students practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 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 you've learned * Ready-made practice files * Solution files for the practice tasks Sharpen the skills measured by these objectives: * Create and Manage Workbooks * Apply Custom Formatting and Layouts * Create Advanced Formulas * Perform Data Analysis * Create Advanced Charts and Pivot Tables

Produktdetails

• MOS Study Guide
• Verlag: Pearson Education (US)
• Seitenzahl: 192
• Erscheinungstermin: 12. März 2020
• Englisch
• Abmessung: 230mm x 185mm x 11mm
• Gewicht: 332g
• ISBN-13: 9780136627524
• ISBN-10: 0136627528
• Artikelnr.: 57974942

Autorenporträt

Paul McFedries, a Microsoft Office expert and owner of the technical writing company Logophilia Limited, has authored nearly 100 books, including Microsoft Excel 2019 Formulas and Functions. Combined, his books have sold more than 4 million copies worldwide.

Inhaltsangabe

Chapter 1 – Manage workbook options and settings
Objective 1.1: Manage workbooks
Objective 1.2: Prepare workbooks for collaboration
Objective 1.3: Use and configure language options
Chapter 2 – Manage and format data
Objective 2.1: Fill cells based on existing data
Objective 2.2: Format and validate data
Objective 2.3: Apply advanced conditional formatting and filtering
Chapter 3 – Create advanced formulas and macros
Objective 3.1: Perform logical operations in formulas
Objective 3.2: Look up data by using functions
Objective 3.3: Apply advanced date and time functions
Objective 3.4: Perform data analysis
Objective 3.5: Troubleshoot formulas
Objective 3.6: Create and modify simple macros
Chapter 4 – Manage advanced charts and tables
Objective 4.1: Create and modify advanced charts
Objective 4.2: Create and modify PivotTables
Objective 4.3: Create and modify PivotCharts