CSC 273 - Spreadsheet Data Analysis

This course introduces basic through advanced techniques for data analysis and management using electronic spreadsheets. Topics include financial, logical, statistical, lookup, and database functions; pivot tables; “what if” analysis with data tables; importing data; complex graphs; macros; and solver features. Students focus on way to design and create accurate, professional worksheets and effective quantitative data models for decision support. Prerequisite: MATH 114 3 credits