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 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