This course focuses on managing and sharing workbooks, applying custom formats and layouts, creating advanced formulas, and creating advanced charts and tables. The course begins with an overview of the certification program and its costs. Next, Jennifer walks through all of the certification objectives, including hands-on experience with downloadable sample documents, so you can practice as you go. She wraps up with a full-length practice test that emulates exam 77-427, together with solutions to each of the exam challenges.

Topics include:
* Reviewing the exam format and learning objectives
* Tracking, retaining, and displaying all changes
* Identifying and troubleshooting errors with tracing
* Applying custom formats and layouts
* Applying advanced conditional formatting
* Using functions to format cells and apply advanced filters
* Preparing a workbook for internationalization
* Creating advanced formulas
* Using the LOOKUP and TRANSPOSE functions
* Using functions to serialize dates and times
* Creating advanced charts and tables