This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDF The popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Also available in other formats.
Register your product to gain access to bonus material or receive a coupon.
Hone your advanced Excel 2019 skills. 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 Expert 2019 certification, this official Study Guide delivers:
Chapter 1 — Manage and share workbooks1.1 Manage workbooks1.2 Manage workbook review
Chapter 2 — Apply custom formats and layouts2.1 Apply custom data formats2.2 Apply advanced conditional formatting and filtering2.3 Apply custom styles and templates2.4 Prepare workbooks for internationalization and accessibility
Chapter 3 — Create advanced formulas3.1 Apply functions in formulas3.2 Look up data by using functions3.3 Apply advanced date and time functions3.4 Perform data analysis and business intelligence3.5 Troubleshoot formulas3.6 Define named ranges and objects
Chapter 4 — Create advanced charts and tables4.1 Create advanced chart elements4.2 Create and manage PivotTables4.3 Create and manage PivotCharts