EXCEL FOR DATA ANALYSIS

Catalog description

Covers how to exploit the power of Excel to answer complex questions through use of functions such as XLOOKUP, INDEX, MATCH, OFFSET, and INDIRECT; time, date, and text functions, SUMIFS, AVERAGEIFS, slicers, and others. The focus is on facing real-world problems and conceptualizing them in a way that can be answered through spreadsheet analysis. While the course is open to students of all majors, it does require serious commitment to thinking analytically . Prerequisite: MATH 110 or 150, with a minimum grade of “C”