Matched 1 Courses / 1 Classes

Advanced Excel for Data Analytics (CIS214DA) 3 Credits

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 of 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.

Class# Semester Location Delivery Dates Days Times Instructor Availability
31896 Spring 2022 Scottsdale
On Your Time Online 		Online 03/21/2022 - 05/13/2022 N/A N/A
  • S. Brandt
 Open
21 of 26 Seats Available
  • Notes
    • Class Notes: This class meets for an 8-week period during the full length semester. Students should expect an increased amount of work each week during the 8 weeks as compared to the same class offered in the full semester. Students are encouraged to work with an academic advisor to be sure their course load is balanced over the course of a given semester.
      ONLINE CLASS. All classwork can be completed entirely online.
      CIS214DA uses MS Excel 2019 and focuses on advanced Excel techniques for Data Analytics.
      All registered students must contact the instructor by email at sheila.brandt@scottsdalecc.edu by the course start date.
      All textbook and course materials available at no or low cost (<$40) - may include OER (Open Educational Resources).