Training overview
Professional Course
Virtual Classroom
5 weeks
From 595 USD

Start dates
595 USD

Course description

Data Analytics for Managers

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.

Want to find out more?

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

Why choose 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.

About IPEx

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...

Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Data Analytics for Managers.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Davenport University's Institute for Professional Excellence

 Show phone number

Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available