糖心vlog官网观看

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You鈥檒l learn to use PowerPivot to build databases and data models. We鈥檒l show you how to perform different types of scenario and simulation analysis and you鈥檒l 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. 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. You鈥檒l use Excel to build complex graphs and Power View reports and then start to combine them into dynamic dashboards. Note: Learners will need PowerPivot to complete some of the exercises. Please use MS Excel 2013 version. If you have other MS Excel versions or a MAC you might not be able to complete all assignments. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.