Data Analytics and Visualization with Excel
Reskill and upskill to satisfy the growing demand for data analytics and visualization expertise from within your own workforce. This course focuses on the key aspects of managing, analyzing and visualizing data using Microsoft Excel. You’ll receive expert guidance on constructing data sets and learning visualization techniques that can be directly applied in real work settings.
Data analytics and visualization is one of the fastest growing information technology disciplines in the country, and companies across all industries are looking for experts to translate the information a business collects into better decisions and outcomes. In the Milwaukee area alone, the demand for skills in this pathway is expected to grow nearly 35% over the next 10 years. Learning data analytics and visualization with Excel equips you with valuable skills for data exploration, analysis and visualization.
This course can be applied to the Data Analysis – Advanced Certificate.
Who Should Attend
The course is aimed at individuals seeking to advance their skills in analyzing and visualizing data accurately and effectively. The learner suited for this course does not need a strong foundation in data analytics and may be just beginning to work with Microsoft Excel software.
Benefits and Learning Outcomes
Successful completion of this course will equip learners with the following skills:
- Collect and interpret accurate data sets
- Draw inferences and present insights from data
- Represent data that is accessible and impactful to audiences
- Apply data visualization to inform decision-making
- Recognize primary data visualization categories and their purposes
Course Outline/Topics
Through five modules, you will build the skills needed to convert data into positive results. Each module is designed for two weeks of learning, approximately eight hours each week.
The modules include:
- The Basics of Data and Data Management
- The Basics of Data Analysis
- Descriptive Analysis and Summarizing Data
- Data Visualization I
- Data Visualization II