From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Create advanced charts and tables
From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Challenge: Create advanced charts and tables
(gentle instrumental music) - [Instructor] Welcome to the Chapter 5 Challenge. For this challenge, we'll be using the 05_05 Challenge exercise file and you should be able to complete all the tasks for both projects in five minutes or less. If you find that you're unable to complete the task in under five minutes, go back and watch the videos for this chapter, then come and try the challenge one more time. You can also watch my solution video to see how I completed all of the tasks.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Use advanced chart formatting5m 38s
-
(Locked)
Create PivotTables and filter with slicers6m 31s
-
(Locked)
Format PivotTables and use GETPIVOTDATA8m 45s
-
(Locked)
Create and modify PivotCharts6m 53s
-
(Locked)
Challenge: Create advanced charts and tables29s
-
(Locked)
Solution: Create advanced charts and tables5m 51s
-
(Locked)
-
-