ITEC 281 - Data Management and Analysis with Spreadsheets

Credits: (3)

Instructional Method: Three hours lecture.
A study of basic and advanced techniques for data analysis and management using electronic spreadsheets. Coverage includes the study of features for gathering, managing, manipulating, and filtering data sets including multidimensional data. Techniques for collaborative use of a spreadsheet are covered including multi-user access, formula protection, and security. Advanced analysis coverage includes built-in and user defined functions, goal seeking, sensitivity analysis, scenario management, and data visualization.