This Advanced Analytics course is designed for Business Intelligence pros, IT specialists, business analysts and others looking to enhance their Excel and data analysis skills.
Use Excel to apply statistical techniques to the analysis of data. Use Microsoft Excel for data analysis and decision-making. Properly handle data collection from multiple sources and data retention in Excel. Integrate data from multiple sources. Summarize data to quickly gain a better understanding of it. Use advanced features in Excel to assist in complex problem-solving. Visualize data through Excelâ€™s graphic functionality. Construct a frequency distribution to analyze data and translate it into relevant information. Calculate and select the most appropriate measures of central tendency. Identify and avoid the potential for hidden bias in expressing statistical findings.
The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.