|
MFTC 219H - Honors Spreadsheet Applications This course provides a hands-on approach to spreadsheet analysis, performance management, and graphics, using Microsoft Excel 2010. Topics to be discussed include: using Excel to enter data, develop formulas, correct mistakes, use-built-in formulas and functions, perform “scenario analysis”, create graphs and charts, conduct financial forecasts, manage data, and print worksheets. Advanced topics will include: logical and lookup functions used in buyers spreadsheets and programming using Visual Basic. The course will explore the possible connections between Excel and the database Access, query data, and generate Excel pivot tables from Access. 3 credits Corequisite: Enrollment in the Fashion Scholars Program or by permission of the Dean of Academics
Add to Portfolio (opens a new window)
|
|