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