PRODUCT ANNOUNCEMENT
Pearson Test Prep Practice Test access codes delivered online at registration.Learn more.
This eBook includes the following formats, accessible from yourAccountpage after purchase:
EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.
PDFThe popular standard, used most often with the freeAdobe® 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 inother formats.
Register your productto gain access to bonus material or receive a coupon.
Hone your advanced Excel 2016 skills. And earn the credential that proves it!
Sharpen the skills measured by these objectives:
Follow the instructions to download this book's practice files.
Chapter 1 — Manage and share workbooks
1.1 Manage workbooks
1.2 Manage workbook review
Chapter 2 — Apply custom formats and layouts
2.1 Apply custom data formats
2.2 Apply advanced conditional formatting and filtering
2.3 Apply custom styles and templates
2.4 Prepare workbooks for internationalization and accessibility
Chapter 3 — Create advanced formulas
3.1 Apply functions in formulas
3.2 Look up data by using functions
3.3 Apply advanced date and time functions
3.4 Perform data analysis and business intelligence
3.5 Troubleshoot formulas
3.6 Define named ranges and objects
Chapter 4 — Create advanced charts and tables
4.1 Create advanced chart elements
4.2 Create and manage PivotTables
4.3 Create and manage PivotCharts
We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.
Download the revised results page for 1-2a