MOS Study Guide for Microsoft Excel Expert Exam MO-201, 1st edition

Published by Microsoft Press (March 6, 2020) © 2020

  • Paul McFedries
Products list
$33.25 AUD

Price Reduced From: $36.95 AUD

Instant access

Access details

  • Digital eBook
  • Instant access
  • Available online, offline and via apps
  • Accessible through the VitalSource Bookshelf

Features

  • Exam coverage
  • Make highlights and notes
  • Listen as the Bookshelf reads to you
Products list
$32.96 AUD

Price Reduced From: $43.95 AUD

Free delivery

Details

  • A print copy
  • Free shipping

Features

  • Exam coverage
  • Hands-on tasks
  • Downloadable practice files

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

  • 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

Need help? Get in touch