Course description

Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.

Microsoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

What will i learn?

• Perform data analysis fundamentals.
• Visualize data with Excel.
• Analyze data with formulas and functions.
• Analyze data with PivotTables.
• Present visual insights with dashboards in Excel.
• Create geospatial visualization with Excel.
• Perform statistical analysis.
• Get and transform data.
• Model and analyze data with Power Pivot.
• Present insights with reports.