Course description
Data Analytics for Managers - On-site Training
Analyzing data to find issues, timely insights, and opportunities is now a critical part of many job roles. Leveraging data effectively can create a significant competitive advantage. Beyond the analysis, managers must also be able to effectively present and communicate findings in visually compelling ways. Learn to perform robust data analysis and visualization using Microsoft Excel in Davenport University’s Data Analytics for Managers. Experience interactive classes and hands-on projects for analyzing and interpreting data to understand business performance, impact, and trends.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Who should attend?
Who Should Attend:
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 PivotTables, 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. To ensure success, participants should have baseline skill using Microsoft Excel worksheets.
Training content
Data Analysis Fundamentals and Visualizing Data with Excel
Identify, manipulate, and visualize data with Excel.
Analyzing Data with Formulas & Functions
Analyze data with formulas and functions in Excel. Implement data validation and create visualizations.
Analyzing Data with PivotTables and Presenting Visual Insights with Dashboards
Create and analyze PivotTable data, visualize and filter data, and create dashboards.
Transforming Data
Combine, shape and transform data using queries, data models, map charts, and visualizations.
Data Insights and Reports
Identify trends and forecasts using reports to guide more effective decision-making.
Certification / Credits
Credits: .15 CEUs
Credits: 15 PDCs
After completing this course, you will be able to:
- Perform fundamental data analysis
- Get and transform data for decisions
- Visualize data with Excel
- Analyze data with formulas, functions, and PivotTables
- Present visual insights with dashboards in Excel
- Perform statistical analysis
- Model and analyze data with Power Pivot
- Present insights with dashboards and reports
Quick stats about IPEx?
With over 150 years of innovative experience in leading-academic thought, Davenport brings the real world of business into each class.
Having strategically partnered with hundreds of businesses and organizations over the last 25 years, Davenport University’s IPEx has the experience to help organizations meet goals and achieve their vision of success.
From Michigan to Malaysia, as well as India, Canada, China, Australia, Brazil and beyond, IPEx has a global presence where learning happens with our international participants.
Contact this provider
Davenport University's Institute for Professional Excellence
Grow through professional development delivered the IPEx way — with an eye on your time and your budget. Davenport University’s Institute for Professional Excellence (IPEx) offers professional development courses focused on topics with real-world relevance, aimed at making you more...