Data Analysis and Visualization with Microsoft Excel

Training Summary
Collecting and accessing data with technology is now ubiquitous in business and in life. The power and storage capabilities of cloud computing have driven organizations of all sorts to capture and store “big data.” Leveraging that data effectively can provide timely insights and competitive advantage. This means that analyzing data to find issues, insights and opportunities is now a critical part of many job roles. Plus, data analysts must present and communicate their findings in visually compelling ways. Microsoft® Excel® can help. With Excel, you can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-backed visualizations. Using Excel for data analysis helps you turn your data into thoughtful action.
To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functions
2 Days/Lecture & Lab
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using Pivot Tables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel.
Course Topics
  • Analyzing and Visualizing Data for Business
  • Analyzing Data with Formulas and Functions
  • Creating Conditional Visualizations
  • Creating PivotTables, PivotCharts, and Slicers
  • Presenting Data in an Excel Dashboard
  • Performing Statistical Analysis
  • Getting and Transforming Data
  • Modeling and Analyzing Data with Power Pivot
  • Creating Geospatial Visualizations with Excel

Related Scheduled Courses