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.
- Type Experience
- Level Foundational
- Time Hours
- Cost Free
Skills
Earning Criteria
-
This course is open to all Binghamton University undergraduate and graduate students.
-
During this 4-hour course, students will engage in interactive Excel lab exercises using a data set to develop the following skills: basic set-up and usage of Excel; data manipulation, formatting, and analysis; data visualization, Macros and formula types; VLOOKUP and pivot tables; and Visual Basic Applications (VBA). Students will also learn about how income data demonstrates disparities among gender and racial groups within the U.S. Includes a pre-test and post-test to assess each skill set.
-
To earn this credential, the learner must pass the exam with a grade of 70% or better.
-
This course is free for Binghamton University students.