Description
In this course, you will :
- This course will provide you with hands-on education for advanced Excel 2013 functionalities. You will learn how to utilize PowerPivot to create databases and data models.
- Show you how to undertake several sorts of scenario and simulation analysis, and you'll be able to practice these abilities using some of Excel's built-in features, such as the solver, data tables, scenario manager, and goal search.
- The second half of the course will explain how to visualize data, tell a story, and explore data by going over the fundamentals of data visualization and dashboarding.
- Utilize Excel to create complicated graphs and Power View reports before beginning to integrate them into dynamic dashboards.
Syllabus:
- Preparing a Professional Excel
- Advanced Scenario Analysis
- Data Visualization
- Dashboarding