Data Analytics with Excel
  • Type Certification
  • Level Foundational
  • Time Months
  • Cost Paid

Data Analytics with Excel

Issued by UC Davis Division of Continuing and Professional Education

Earners of this badge have studied data analysis applications in the healthcare, public services, consumer goods and energy industries discovering the analytics workspace. They have also practiced both functional and technical aspects of Excel to produce case-specific analysis, including forecasting analysis, variance analysis and trend analysis. The badge holder applied these skills in the Data Analytics with Excel course - completing 20 hours of instruction and 40 hours of hands-on project

  • Type Certification
  • Level Foundational
  • Time Months
  • Cost Paid

Skills

Earning Criteria

  • The learner has passed UC Davis Continuing and Professional Eduction "Data Analytics with Excel", an Academic Credit-bearing course, with a grade of "C" or better.
  • Learner completed assignment components of the course with grade of "C" or better. Assignments Included: *Excel functions related to data preparation, sorting and filtering *Pivot tables, XLOOKUP and VLOOKUP *Business and finance data models *Case-specific analysis, including forecasting analysis, variance analysis and trend analysis. Assignments were graded by the course instructor.
  • The learner has completed a "Financial Analytics" course project with grade of "C" or better as assessed by the course instructor. In the project the learner applied knowledge of Excel to create an enterprise reporting and financial data analysis.