Advanced Excel for Data Analytics

Catalog description

Advanced Excel spreadsheet features for data analytics including advanced functions, PivotTables, Data Modelling, Dashboard creation and forecasting for Business Intelligence (BI). Includes capstone project of an interactive dashboard using a multi-table Excel Data Model. Note: A basic understanding of statistics is required. A grade of C or better required in all Prerequisites. Prerequisites or Corequisites: [CIS114DE and (CIS117DM or CIS276DA or CIS276DB)], or permission of Instructor.