Analysis Reports in Microsoft Excel
1 hour 30 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 amongst the most popular of all analytical tools. This topic 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 information 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 explain the powerful features Excel® has to offer to analyze data.
• You will be able to create sparklines, slicers and map data.
• You will be able to identify the analysis tools to simplify statistics and mathematical functions.
• You will be able to describe the functionality of PivotTables and subtotals.