Excel 2013 Advanced: PivotCharts Another Computer Mama Guide: www.thecomputermama.com If you wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you build the skills and knowledge you need. Step-by-step video demonstrations Companion eBook with 220 pages of detailed instructions Sample presentations and images Practice, Quizzes and Skill Test All materials for this program are available online. The following resources are available to download throughout the lessons: Advanced Guide to Microsoft® Excel 2013 Microsoft Excel 2013 Advanced Sample files Advanced Excel Objectives In this lesson, you will learn how to: Analyze data visually with a PivotChart. Create a PivotChart and Show the Field List. Edit the Value Field Settings. Filter the data in the PivotChart. Edit the Chart Layouts.