Home Page Icon
Home Page
Table of Contents for
Cover Page
Close
Cover Page
by Paul McFedries
MOS Study Guide for Microsoft Excel Expert Exam MO-201
Cover Page
Title Page
Copyright Page
Contents
Introduction
Who this book is for
How this book is organized
Download the practice files
Ebook edition
Errata, updates, and book support
Stay in touch
Exam MO-201 Excel 2019 Expert
Prerequisites
Objective group 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
Objective group 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
Objective group 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
Objective group 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
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset