Overview

Demonstrate your expert-level competency with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Microsoft Excel Expert (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 you've learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Workbook Options and Settings Manage and Format Data Create Advanced Formulas and Macros Manage Advanced Charts and Tables

Full Product Details

Author:   Paul McFedries
Publisher:   Pearson Education (US)
Imprint:   Addison Wesley
Dimensions:   Width: 18.50cm , Height: 1.00cm , Length: 22.90cm
Weight:   0.340kg
ISBN:  

9780136627524

ISBN 10:   0136627528
Pages:   192
Publication Date:   21 May 2020
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Available To Order  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

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 Pivot Tables Objective 4.3: Create and modify Pivot Charts

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions