✓ Challenge: Create advanced charts and tables

Keyboard Shortcuts

Self-test your comprehension by completing a series of hands-on objectives, then reviewing the author's solution video. Learn that time is a major factor in the Excel 2013 MOS Expert Exam, so the ability to solve objectives quickly is important. Practice creating PivotCharts, creating slicers, using filter buttons to sort and filter information in PivotCharts, and applying Chart Styles and Quick Layouts to PivotCharts,and how to change the color pallet and create a custom color.

- [Instructor] Welcome to the Chapter 5: Challnege.…For this challenge,…we'll be using the 05_04 challenge exercise file,…and I believe you should be able to complete…all the tasks in five minutes or less.…If you find that you're unable to complete the tasks…within this timeframe, please go back and watch the videos…for this chapter and try the challenge again.…You can also watch my solution video…to see how I completed each of the tasks.…

Resume Transcript Auto-Scroll

Author

Released

5/4/2017

Make evident your advanced knowledge of Excel by becoming a Microsoft Office Specialist (MOS) Expert. This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Excel 2013 Expert Part Two exam, the second part of a two-part exam. This course takes the topics from the first course further: managing and sharing workbooks, applying custom formats and layouts, creating advanced formulas, and creating advanced charts and tables.

Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
In the managing workbooks chapter, learn how to work with templates, versions, and macros. In the formatting and layout chapter, see how to apply custom formats and styles. The advanced formula chapter covers additional functions including a nested IF. The charts and tables chapter shows how to create a new PivotChart. The course concludes with a sample exam you can use for practice.