This course builds upon the foundational knowledge presented in the Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. Instruction will be personalized by version. Students have the option to progress through the course using Microsoft Excel 2013, or Microsoft Excel 2016.
Upon successful completion of this
course, you will be able to leverage the power of data analysis and
presentation in order to make informed, intelligent organizational decisions.
· You will:
1 - WORKING WITH FUNCTIONS
2 - WORKING WITH LISTS
3 - ANALYZING DATA
4 - VISUALIZING DATA WITH CHARTS
5 - USING PIVOTTABLES AND PIVOTCHARTS