This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017. If you have other MS Excel versions or a MAC you might not be able to complete all assignments. Note: Learners will need PowerPivot to complete some of the exercises. Please note that selecting the chart is different from selecting its bounding box. You’ll use Excel to build complex graphs and Power View reports and then start to combine them into dynamic dashboards. To rotate the pie chart, select it, right-click on it, and choose Format Data Series from the context menu. If you’re reversing the values, the check box reads Values in Reverse Order. ![]() If you want to change the order that the items appear on the horizontal axis, click that axis. ![]() In the second half of the course, will cover how to visualize data, tell a story and explore data by reviewing core principles of data visualization and dashboarding. In the Axis Options section (click the Axis Options icon if necessaryit looks like a graph), check the Categories in Reverse Order check box. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek. You’ll learn to use PowerPivot to build databases and data models. In this course, you will get hands-on instruction of advanced Excel 2013 functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |