Analysis Reports in Microsoft Excel
1 hour 5 minutes
Learn how to properly prepare an analytics report with Microsoft® Excel®.
Microsoft Excel is the most common analysis software on the market and it is not just for spreadsheets - it allows us to easily turn data into sophisticated graphics and charts. PivotTables, charts, and data analysis are among the most popular of all analytical tools. This course provides you with tools to master analysis and reporting from data cleansing to visualization. Learn how to simplify statistics and realize the importance of PivotTables. This material includes creating trend lines, charts, and maps to visually displaying your results. A working knowledge of Excel is recommended for our analysis course.
• You will be able to define the meaning of data analysis.
• You will be able to discuss how to organize your data.
• You will be able to explain frequency and trend lines.
• You will be able to review descriptive statistics.