Intermediate Data Visualization with Excel

When presented in visual form, data can help management quickly understand what has happened in the past, why something happened, and how to prepare for the future. Through Bryant’s Intermediate Data Visualization with Excel course, you’ll unlock the storytelling power of Excel and craft compelling visualizations that answer critical questions for informed decision-making. 

By mastering the art of Excel dashboards, you’ll be able to slice and dice the data for decision-makers in real time. This course dives into Excel data analytics techniques such as pivot tables and charts that reveal trends. You’ll practice importing, transforming, and shaping data to create dynamic reports and visualizations. Learning these new skills will increase the value that you bring to your company or organization. 

Key Knowledge Areas in Intermediate Data Visualization 

Through our Intermediate Data Visualization with Excel course, you will:

• Use pivot tables and pivot charts to analyze and visualize complex data sets.
• Create interactive and visually compelling dashboards that effectively communicate key insights and trends.
• Use power query to efficiently import, clean, and transform data from various sources, ensuring data accuracy and consistency.
• Construct robust data models using power pivot, establishing relationships and hierarchies for in-depth analysis.
• Apply Data Analysis Expressions (DAX) to perform advanced calculations, create custom measures, and enhance data modeling capabilities.
• Develop practical skills through hands-on exercises and real-world scenarios, ensuring the ability to apply learned concepts in professional settings.

Audience

• Professionals across a wide range of careers, including project managers, business analysts, scientists and researchers, healthcare professionals, finance and banking professionals, human resource specialists, marketing and communication specialists, entrepreneurs, and start-up founders
• Any individual looking to expand their knowledge of data visualization and data analytics

Before registering for the intermediate course, Bryant recommends taking the Beginner Data Visualization with Excel course.

Certificate Requirements

This five-week, self-paced course includes guided learning with multimedia, interactive modules, and curated readings. Expect approximately 6-7 hours of work per week.

First-time online learner? “Strategies for Success” is a one-week module that will familiarize you with our learning system before you begin your certificate program and ensure you are ready to participate. Required for all first-time, self-paced Bryant learners.

After successfully completing this course, you’ll receive the Intermediate Data Visualization with Excel Certificate. Bryant plans to launch a third course this year called Advanced Data Visualization with Power BI. Earn a certificate for each course you complete. Complete all three courses to earn the Data Visualization Specialization Certificate.