Excel Skills for Data Analytics

Issued by Binghamton University

This crash course prepares undergraduate and graduate students looking to gain Excel skills for use in data analytics such as: data manipulation, data visualization, how to use Macros and more through this micro-credential.

Level Foundational
Cost Free

Additional Details

Skills

Basic Microsoft Excel
Data Extraction And Manipulation
Data Visualization
Working with Macros in Excel

Earning Criteria

Post-test completion highlighting submission of exercises in session that will be evaluated by the instructor.
Skill-building lab exercises using a data set to develop the following skills: Basic Setup and Usage of Excel, Data Manipulation, Formatting, and Analysis, Data Visualization, Macros and Formula Types, VLOOKUP and Pivot Tables and Visual Basic Applications (VBA). They will also learn about how income data demonstrates disparities among gender and racial groups within the United States.